| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | ERKRS | Operating concern | nvarchar | 4 | 0 | CHAR | (N' ') | No | | ERKRS | Allow NULL? |
| 3 | SAPRL | SAP release when last generated | nvarchar | 4 | 0 | CHAR | (N' ') | No | | RKE_SAPRL | Allow NULL? |
| 4 | PVERS | Program Version | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RKE_PVERS | Allow NULL? |
| 5 | HITYP | Customer hierarchy type | char | 1 | 0 | CHAR | (N' ') | No | THIT | HITYP_KH | Allow NULL? |
| 6 | WAERS | Operating concern currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | RKE_WAERS | Allow NULL? |
| 7 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T009 | PERIV | Allow NULL? |
| 8 | PERFLAG | Period-type indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PERFLAG | Allow NULL? |
| 9 | PERIV2 | Fiscal year variant for alternative period type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T009 | PERIV2 | Allow NULL? |
| 10 | PERFLAG2 | Alternative period type indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PERFLAG2 | Allow NULL? |
| 11 | USEPER2I | Indicator: Update actual data in the second period type | char | 1 | 0 | CHAR | (N' ') | Yes | | USEPER2I | Allow NULL? |
| 12 | USEPER2P | Indicator: Update plan data in the 2nd period type | char | 1 | 0 | CHAR | (N' ') | Yes | | USEPER2P | Allow NULL? |
| 13 | TIMESTMP | Start time for reading data | decimal | 16 | 0 | DEC | ((0)) | Yes | | RKE_DBSTMP | |
| 14 | ALEACT | CO-PA Distribution: Active indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RKE_ALEACT | Allow NULL? |
| 15 | CHAR_CHECK | Consistency Check for Characteristic Values | char | 1 | 0 | CHAR | (N' ') | Yes | | RKE_CHAR_CHECK | Allow NULL? |
| 16 | CRERL | SAP Release in which the operating concern was created | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | RKE_CRERL | Allow NULL? |
| 17 | CREDA | Date operating concern was created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RKE_CREDA | Allow NULL? |