| 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 | YVWDNR | CHD Contract Number | nvarchar | 13 | 0 | NUMC | (N'0000000000000') | No | | /BEV3/CHDTWDNR | Allow NULL? |
| 3 | VBKL_BK | Agreement Class of the Purchase Control | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | /BEV3/CHBKL_BK | Allow NULL? |
| 4 | RI_BK | Rule Identifier for Purchase Control | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | /BEV3/CHRI_BK | Allow NULL? |
| 5 | VBIN_BK | Agreement Entity of the Purchase Control | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | /BEV3/CHBIN_BK | Allow NULL? |
| 6 | ANZ_ENDABR | Number of Final Settlements | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | /BEV3/CHANZ_ENDABR | Allow NULL? |
| 7 | VBNR_BK | Agreement Number in Sequential Time Order | nvarchar | 9 | 0 | NUMC | (N'000000000') | Yes | | /BEV3/CHBNR | Allow NULL? |
| 8 | YVORGE | CH Organizational Unit | nvarchar | 4 | 0 | NUMC | (N'0000') | No | * | /BEV3/CHOE | Allow NULL? |
| 9 | VWDART | Contract Handling Document Type | nvarchar | 4 | 0 | NUMC | (N'0000') | No | * | /BEV3/CHDTVWDART | Allow NULL? |
| 10 | ABR_NR | Settlement Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | /BEV3/CHABRNR | Allow NULL? |
| 11 | ABRSLKDAT | To/Settlement Selection Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /BEV3/CHABRSLKTDAT | Allow NULL? |
| 12 | ABRDAT_L | Last Settlement Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /BEV3/CHABRDAT_L | Allow NULL? |
| 13 | ST_KZ | Cancel. ID ('X'->Cancellation; ' '->Canceled cancellation | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV3/CHST_KZ | Allow NULL? |
| 14 | USER_BK | Name of the settlement trigger for purchase control | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /BEV3/CHUSER_BK | Allow NULL? |
| 15 | DATE_BK | Creation Date of Purchase Control | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /BEV3/CHDAT_BK | Allow NULL? |
| 16 | TIME_BK | Creation Time/Hrs. of the Purchase Control | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /BEV3/CHTIME_BK | Allow NULL? |
