| 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 | * | MANDT | Allow NULL? |
| 2 | BK_LFDNR | Sequence Number | nvarchar | 16 | 0 | NUMC | (N'0000000000000000') | No | | /BEV3/CHLFDNR16 | Allow NULL? |
| 3 | BK_VG | CH Number of a Purchase Control Transaction | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | /BEV3/CHBKNR | Allow NULL? |
| 4 | YVWDNR | CHD Contract Number | nvarchar | 13 | 0 | NUMC | (N'0000000000000') | No | | /BEV3/CHDTWDNR | Allow NULL? |
| 5 | VBKL | Agreement Class | nvarchar | 4 | 0 | CHAR | (N' ') | No | /BEV3/CHCTVB | /BEV3/CHBKL | Allow NULL? |
| 6 | RI | Rule Identifier | nvarchar | 6 | 0 | NUMC | (N'000000') | No | /BEV3/CHCTRGI | /BEV3/CHDTRI | Allow NULL? |
| 7 | VBIN | Agreement Entity | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | /BEV3/CHBIN | Allow NULL? |
| 8 | VBNR | Agreement Number in Sequential Time Order | nvarchar | 9 | 0 | NUMC | (N'000000000') | Yes | | /BEV3/CHBNR | Allow NULL? |
| 9 | ABR_NR | Settlement Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | /BEV3/CHABRNR | Allow NULL? |
| 10 | AB_BWDAT | Start of Valuation Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /BEV3/CHABBWDAT | Allow NULL? |
| 11 | BIS_BWDAT | End of the Valuation Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /BEV3/CHBISBWDAT | Allow NULL? |
| 12 | ABNHM_MNG | Purchase Commitment in Valuation Period | decimal | 15 | 5 | QUAN | ((0)) | Yes | | /BEV3/CHABNMNG | |
| 13 | ABSTZ_MNG | Sales in Valuation Period | decimal | 15 | 5 | QUAN | ((0)) | Yes | | /BEV3/CHABSMNG | |
| 14 | MHR_BZG | Extra Purchase in Valuation Period | decimal | 15 | 5 | QUAN | ((0)) | Yes | | /BEV3/CHMHRBZG | |
| 15 | MNDR_BZG | Purchase Shortfall in Valuation Period | decimal | 15 | 5 | QUAN | ((0)) | Yes | | /BEV3/CHMNDRBZG | |
| 16 | BWRT_MNG | Sales without Goods Movement | decimal | 15 | 5 | QUAN | ((0)) | Yes | | /BEV3/CHBWRTMNG | |
| 17 | ME_BZG | Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /BEV3/CHMEINH | Allow NULL? |
| 18 | SOLL_UMS | Target Sales in Valuation Period | decimal | 16 | 2 | CURR | ((0)) | Yes | | /BEV3/CHSOLLUMS | |
| 19 | IST_UMS | Sales in Valaution Period | decimal | 16 | 2 | CURR | ((0)) | Yes | | /BEV3/CHISTUMS | |
| 20 | MHR_UMS | Additional Sales in Valuation Period | decimal | 16 | 2 | CURR | ((0)) | Yes | | /BEV3/CHMHRUMS | |
| 21 | MNDR_UMS | Sales Shortfall in Valuation Period | decimal | 16 | 2 | CURR | ((0)) | Yes | | /BEV3/CHMNDRUMS | |
| 22 | BWRT_UMS | Sales without Goods Movement | decimal | 16 | 2 | CURR | ((0)) | Yes | | /BEV3/CHBWRTUMS | |
| 23 | BEW_BTRG | Valuated Sales (Net) | decimal | 16 | 2 | CURR | ((0)) | Yes | | /BEV3/CHBEWBTRG | |
| 24 | ABW_BTRG | Deviating Valued Sales | decimal | 16 | 2 | CURR | ((0)) | Yes | | /BEV3/CHABWBTRG | |
| 25 | WAERK | Currency indicator | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | /BEV3/CHWAERK | Allow NULL? |
| 26 | INDRKT_FLG | Indirect Sales | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV3/CHINDRKT | Allow NULL? |
| 27 | DRKT_FLG | Direct Sales | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV3/CHDRKT | Allow NULL? |
| 28 | YVWDNR_TM | CHD Contract Number of the Date | nvarchar | 13 | 0 | NUMC | (N'0000000000000') | Yes | | /BEV3/CHWDNR_TM | Allow NULL? |
| 29 | VBKL_TM | Agreement Class of the Date | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | /BEV3/CHCTVB | /BEV3/CHBKL_TM | Allow NULL? |
| 30 | RI_TM | Rule Identifier for Date | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | /BEV3/CHCTRGI | /BEV3/CHRI_TM | Allow NULL? |
| 31 | VBIN_TM | Agreement Entity of the Date | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | /BEV3/CHBIN_TM | Allow NULL? |
| 32 | ABRSLKTDT | To/Settlement Selection Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /BEV3/CHABRSLKTDAT | Allow NULL? |
| 33 | BLG_DAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 34 | FKTR_DAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 35 | BKRESSTAT | Processing Status of Purchase Control Result | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV3/CHBKRSTAT | Allow NULL? |
| 36 | ACTNR | CH Number of a Transaction | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | /BEV3/CHACTNR | Allow NULL? |
| 37 | NULLSATZ | Zero Record Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV3/CHNULLSATZ | Allow NULL? |
| 38 | TMABRAUTO | Field to select a date to be settled automatically | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV3/CHTMABRAUTO | Allow NULL? |
| 39 | BKUSER | Changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | USER | Allow NULL? |
| 40 | BKDATE | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATUM | Allow NULL? |
| 41 | BKTIME | Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | UZEIT | Allow NULL? |
| 42 | CHUSER | Changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | USER | Allow NULL? |
| 43 | CHDATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LAEDA | Allow NULL? |
| 44 | CHTIME | Time of Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEZEIT | Allow NULL? |
