| 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_TM | Agreement Class of the Date | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | /BEV3/CHBKL_TM | Allow NULL? |
| 4 | RI_TM | Rule Identifier for Date | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | /BEV3/CHRI_TM | Allow NULL? |
| 5 | VBIN_TM | Agreement Entity of the Date | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | /BEV3/CHBIN_TM | Allow NULL? |
| 6 | ABR_NR | Settlement Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | /BEV3/CHABRNR | Allow NULL? |
| 7 | LFDNR_TM | Sequence Number of Date in Period Tracking | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | /BEV3/CHLFDNRTM | Allow NULL? |
| 8 | VBNR_TM | Agreement Number in Sequential Time Order | nvarchar | 9 | 0 | NUMC | (N'000000000') | Yes | | /BEV3/CHBNR | Allow NULL? |
| 9 | YVORGE | CH Organizational Unit | nvarchar | 4 | 0 | NUMC | (N'0000') | No | * | /BEV3/CHOE | Allow NULL? |
| 10 | VWDART | Contract Handling Document Type | nvarchar | 4 | 0 | NUMC | (N'0000') | No | * | /BEV3/CHDTVWDART | Allow NULL? |
| 11 | AUSL_AUSN | Exception Handling: Exception Number of Cancellation | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | /BEV3/CHAUSN_ABRUCH | Allow NULL? |
| 12 | PROTSATZ | Count parameters | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | NUMC4 | Allow NULL? |
| 13 | VBKL_AUSN | Agreement Class - Exception Trigger | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | /BEV3/CHBKL_AUSN | Allow NULL? |
| 14 | RI_AUSN | Rule Identifier - Exception Trigger | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | /BEV3/CHRI_AUSN | Allow NULL? |
| 15 | VBIN_AUSN | Agreement Entity - Exception Trigger | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | /BEV3/CHBIN_AUSN | Allow NULL? |
| 16 | VBNR_AUSN | Agreement Number in Seq. Time Order - Exception Initiator | nvarchar | 9 | 0 | NUMC | (N'000000000') | Yes | | /BEV3/CHBNR_AUSN | Allow NULL? |
| 17 | USER_TM | Name of Settlement Initiator | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /BEV3/CHUSER_TM | Allow NULL? |
| 18 | DATE_TM | Creation On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /BEV3/CHDAT_TM | Allow NULL? |
| 19 | TIME_TM | Time Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /BEV3/CHTIME_TM | Allow NULL? |
