| 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 | BILLDOCITEM | Sequential Number of Document Item | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | BILLDOCITEM_KK | Allow NULL? |
| 4 | REFITEM | Number of Line Item in External System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | REFITEM_KK | Allow NULL? |
| 5 | ITEMTYPE | Type of Billing Item | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TFK2608 | BILL_ITEMTYPE_KK | Allow NULL? |
| 6 | BILL_AMOUNT | Amount in Billing Document Item | decimal | 13 | 2 | CURR | ((0)) | Yes | | BILL_AMOUNT_KK | |
| 7 | BILL_CURR | Currency of Billing Document | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | BILL_CURR_KK | Allow NULL? |
| 8 | ITEM_SIMULATED | Line Item Is Simulated | char | 1 | 0 | CHAR | (N' ') | Yes | | ITEM_SIMULATED_KK | Allow NULL? |
| 9 | REVERSALITEM | Reversal Item | char | 1 | 0 | CHAR | (N' ') | Yes | | REVERSALITEM_KK | Allow NULL? |
| 10 | CORRCAT | Category of Invoice Correction | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CORRCAT_KK | Allow NULL? |
| 11 | POSTREL | Posting-Relevant Line Item | char | 1 | 0 | CHAR | (N' ') | Yes | | POSTREL_KK | Allow NULL? |
| 12 | NOT_BPREL | Not Relevant for Business Partner Items | char | 1 | 0 | CHAR | (N' ') | Yes | | NOT_BPREL_KK | Allow NULL? |
| 13 | PRINTREL | Line Item Is Relevant for Printing | char | 1 | 0 | CHAR | (N' ') | Yes | | PRINTREL_KK | Allow NULL? |
| 14 | PRINT_SUBSTITUTE | Substitute Group for Invoice Printing | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | PRINT_SUBSTITUTE_KK | Allow NULL? |
| 15 | DATE_FROM | Start of Period of Line Item | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ITEMPERIOD_FROM_KK | Allow NULL? |
| 16 | DATE_TO | End of Period of Line Item | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ITEMPERIOD_TO_KK | Allow NULL? |
| 17 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDN_KK | Allow NULL? |
| 18 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TSPA | SPART_KK | Allow NULL? |
| 19 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 20 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 21 | BUPLA | Business Place | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | J_1BBRANCH | BUPLA | Allow NULL? |
| 22 | SEGMT | Segment for Segmental Reporting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | FAGL_SEGM | SEGMT_KK | Allow NULL? |
| 23 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 24 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFKHVO | HVORG_KK | Allow NULL? |
| 25 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFKTVO | TVORG_KK | Allow NULL? |
| 26 | KOFIZ | Account Determination ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | KOFIZ_KK | Allow NULL? |
| 27 | TAX_DET_TYPE | Type of Tax Calculation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TAX_DET_TYPE_KK | Allow NULL? |
| 28 | TAX_COUNTRY | Destination Country That Is Relevant for Tax Report | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | TAX_COUNTRY_KK | Allow NULL? |
| 29 | TAX_DATE_TYPE | Type of Tax Date | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TAX_DATE_TYPE_KK | Allow NULL? |
| 30 | TAX_INCLUDED | Tax Included in Amount | char | 1 | 0 | CHAR | (N' ') | Yes | | TAX_INCLUDED_KK | Allow NULL? |
| 31 | TAX_GROUP | Grouping of Tax Items | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | TAX_GROUP_KK | Allow NULL? |
| 32 | EXT_TAX_DATE | External Tax Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EXT_TAX_DATE_KK | Allow NULL? |
| 33 | ERMWSKZ | Indicator: Tax Determination Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ERMWSKZ | Allow NULL? |
| 34 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 35 | ERMWSKZ_B2B | Alternative Tax Determination Code for Foreign Deliveries | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ERMWSKZ_B2B_KK | Allow NULL? |
| 36 | MWSKZ_B2B | Alternate Tax Code for Deliveries Abroad | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ_B2B_KK | Allow NULL? |
| 37 | STRKZ | Tax Code for Other Taxes | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | STRKZ_KK | Allow NULL? |
| 38 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | TTXJ | TXJCD | Allow NULL? |
| 39 | QSSKZ | Withholding Tax Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | QSSKZ | Allow NULL? |
| 40 | XANZA | Item is a Down Payment/Down Payment Request | char | 1 | 0 | CHAR | (N' ') | Yes | | XANZA_KK | Allow NULL? |
| 41 | STAKZ | Type of statistical item | char | 1 | 0 | CHAR | (N' ') | Yes | | STAKZ_KK | Allow NULL? |
| 42 | DEFREV_CAT | Category of Deferred Revenues | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | DEFREV_CAT_KK | Allow NULL? |
| 43 | DEFREV_PDATE | Transfer Posting Date for Delayed Revenues | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATE_KK | Allow NULL? |
| 44 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 45 | QTY_BW_REL | Quantity Is BI-Relevant | char | 1 | 0 | CHAR | (N' ') | Yes | | QTY_BW_REL_KK | Allow NULL? |
| 46 | QTY_FI_CO_REL | Quantity Is FI/CO-Relevant | char | 1 | 0 | CHAR | (N' ') | Yes | | QTY_FI_CO_REL_KK | Allow NULL? |
| 47 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VTREF_KK | Allow NULL? |
| 48 | VTPOS | Contract: Item Number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | VTPOS_KK | Allow NULL? |
| 49 | SUBAP | Subapplication in Contract Accounts Receivable and Payable | char | 1 | 0 | CHAR | (N' ') | Yes | | SUBAP_KK | Allow NULL? |
| 50 | PREPAID | Prepaid | char | 1 | 0 | CHAR | (N' ') | Yes | | PREPAID_KK | Allow NULL? |
| 51 | PPREFILL | Prepaid Account Balance Change | char | 1 | 0 | CHAR | (N' ') | Yes | | PPREFILL_KK | Allow NULL? |
| 52 | PSCAT | Partner Settlement Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PSCAT_KK | Allow NULL? |
| 53 | ITEM_CRMET | Method Used to Create Billing Document Item | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BILLITEM_CRMET_KK | Allow NULL? |
| 54 | BILL_FUNCTION | Billing Function | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | TFK8065R | BILL_FUNCTION_KK | Allow NULL? |
| 55 | ADD_GROUP | Grouping of Additional Items | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ADD_GROUP_KK | Allow NULL? |
| 56 | PY_GROUP | Grouping of Payment Data | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PY_GROUP_KK | Allow NULL? |
| 57 | SRC_GROUP | Grouping of Source Items | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SRC_GROUP_KK | Allow NULL? |
| 58 | DISC_GROUP | Grouping of Base Items in Billing Document | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | DISC_GROUP_KK | Allow NULL? |
| 59 | SEC_REASON | Reason for Requesting a Security Deposit | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | REASON_KK | Allow NULL? |
| 60 | DISCKEY | Discount/Charge Key | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TFK8117 | DISCKEY_KK | Allow NULL? |
| 61 | DISCKEY_VERSNO | Version Number of Disccount on Billable Items | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | DISCKEY_VERSNO_KK | Allow NULL? |
| 62 | BILLACCOUNT | Billing Account Number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | BILLACCOUNT_KK | Allow NULL? |
| 63 | BILLITEM_FROM | Start of Period for Document Item as UTC Time Stamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | BILLITEMTSFROM_KK | |
| 64 | BILLITEM_TO | End of Period of Document Item as UTC Time Stamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | BILLITEMTSTO_KK | |
| 65 | BILLRATECAT | Billing Rate Category | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BILLRATECAT_KK | Allow NULL? |
| 66 | BILLRATE | Billing Rate | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BILLRATE_KK | Allow NULL? |
| 67 | BILLRATEITEM | Billing Rate Item | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | BILLRATEITEM_KK | Allow NULL? |
| 68 | BILLINGCAT | Billing Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BILLINGCAT_KK | Allow NULL? |
| 69 | BILLPROCEDURE | Billing Procedure | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BILLPROCEDURE_KK | Allow NULL? |
| 70 | BILLPERTYPE | Billing Period Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BILLPERTYPE_KK | Allow NULL? |
| 71 | QUANTITY_PDP | Billing Quantity: Places before Decimal Point | decimal | 17 | 0 | DEC | ((0)) | Yes | | QUANTITY_PDP_KK | |
| 72 | QUANTITY_ADP | Billing Quantity: Places after Decimal Point | decimal | 14 | 14 | DEC | ((0)) | Yes | | QUANTITY_ADP_KK | |
