| 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 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 3 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | VRSIO | Allow NULL? |
| 4 | LCNUM | Financial doc. processing: Internal financial doc. number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | LCNUM | Allow NULL? |
| 5 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPMON | Allow NULL? |
| 6 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPTAG | Allow NULL? |
| 7 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPWOC | Allow NULL? |
| 8 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPBUP | Allow NULL? |
| 9 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 10 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 11 | CMWAE | Currency key for letter-of-credit procg in foreign trade | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | AKWAE | Allow NULL? |
| 12 | OEIKW | Letter-of-credit value used for orders | decimal | 26 | 8 | CURR | ((0)) | Yes | | WRTLC_AU | |
| 13 | OLIKW | Value of letter of credit consumed by deliveries | decimal | 26 | 8 | CURR | ((0)) | Yes | | WRTLC_LI | |
| 14 | OFAKW | Value of letter of credit consumed by billing documents | decimal | 26 | 8 | CURR | ((0)) | Yes | | WRTLC_FA | |