| 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 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | DFKKINVBILL_H | BILLDOCNO_KK | Allow NULL? |
| 3 | BILLDOCSRCITEM | Sequence Number of Source Item | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | BILLDOCSRCITEM_KK | Allow NULL? |
| 4 | SRC_GROUP | Grouping of Source Items | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SRC_GROUP_KK | Allow NULL? |
| 5 | BILLDOCRECTYPE | Record Type in Billing Document | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BILLDOCRECTYPE_KK | Allow NULL? |
| 6 | SIMULATED | Billing Document Is Simulated | char | 1 | 0 | CHAR | (N' ') | Yes | | SIMULATED_KK | Allow NULL? |
| 7 | CRDATE | Date on Which Billing Document Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BILLCRDATE_KK | Allow NULL? |
| 8 | CITCAT | Consumption Item Class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CITCAT_KK | Allow NULL? |
| 9 | BITCAT | Billable Item Class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFK8101C | BITCAT_KK | Allow NULL? |
| 10 | BITSTATUS | Status of Billable Item | char | 1 | 0 | CHAR | (N' ') | Yes | | BITSTATUS_KK | Allow NULL? |
| 11 | BITRECTYPE | Record Type of Billable Item | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BITRECTYPE_KK | Allow NULL? |
| 12 | BIT_DBTAB | Database Table Containing Billable Item | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | BIT_DBTAB_KK | Allow NULL? |
| 13 | BIT_GRPNO | Grouping of Billable Items in Billing Document | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | BIT_GRPNO_KK | Allow NULL? |
| 14 | SUBPROCESS | Subprocess of Billing | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | SUB_PROCESS_KK | Allow NULL? |
| 15 | BITTYPE | Type of Billable Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFK8102 | BITTYPE_KK | Allow NULL? |
| 16 | SRCTATYPE | Source Transaction Type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TFK8103 | SRCTATYPE_KK | Allow NULL? |
| 17 | SRCREFTYPE | Type of Reference to Source Transaction in Billing Document | char | 1 | 0 | CHAR | (N' ') | Yes | | BILL_SRCREFTYPE_KK | Allow NULL? |
| 18 | SRCREF | Reference to Source Transaction in Billing Document | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | BILL_SRCREF_KK | Allow NULL? |
| 19 | XPRIMARY | Primary Billable Item | char | 1 | 0 | CHAR | (N' ') | Yes | | XPRIMARY_KK | Allow NULL? |
| 20 | RELTYPE_PRIMARY | Type of Relationship to Primary Item | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | RELTYPE_PRIMARY_KK | Allow NULL? |
| 21 | BITMONTH | Month of Origin of Billable Item | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | BITMONTH_KK | Allow NULL? |
| 22 | BITCRMONTH | Month in Which Billable Item Was Created | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | BITCRMONTH_KK | Allow NULL? |
| 23 | BIT_AMOUNT | Amount of Billable Item | decimal | 13 | 2 | CURR | ((0)) | Yes | | BIT_AMOUNT_KK | |
| 24 | BIT_CURR | Currency of Billable Item | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BIT_CURR_KK | Allow NULL? |
| 25 | BIT_NUMBER | Number of Billable Items | int | 10 | 0 | INT4 | ((0)) | Yes | | BIT_NUMBER_KK | Allow NULL? |
