| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SRCDOC_COMP | Source Item Sender Component | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | SRCDOC_LOGSYS | Logical System of the Source Item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | SRCDOC_TYPE | Source Document Item Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | | | Allow NULL? |
| 6 | TIMESTAMP_UTC | Timestamp UTC for Revenue Accounting Item | decimal | 15 | 0 | | | | |
| 7 | KEYPP | Subarea for Parallelization | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | RAIC_TYPE | Revenue Accounting Item Class Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | RAIC | Revenue Accounting Item Class | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | STATUS | Status of Revenue Accounting Item | char | 1 | 0 | | | | Allow NULL? |
| 11 | CHHIST | History Exists | char | 1 | 0 | | | | Allow NULL? |
| 12 | HEADER_ID | Header ID of Source Document for Revenue Accouting Item | nvarchar | 20 | 0 | | | | Allow NULL? |
| 13 | ITEM_ID | Item ID of Source Document for Revenue Accouting Item | nvarchar | 15 | 0 | | | | Allow NULL? |
| 14 | REFERENCE_TYPE | Reference Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | REFERENCE_ID | Reference ID | nvarchar | 30 | 0 | | | | Allow NULL? |
| 16 | KUNNR | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 18 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | HWAER | Local Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | HWAE2 | Currency Key of Second Local Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | QUANTITY | Quantity | decimal | 18 | 6 | | | | |
| 24 | QUANTITY_UNIT | Quantity Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | BILREL | Billing Relevant | char | 1 | 0 | | | | Allow NULL? |
| 26 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | PRCTR | Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | SEGMENT | Segment for Segmental Reporting | nvarchar | 10 | 0 | | | | Allow NULL? |
| 29 | PAOBJNR | Profitability Segment Number (CO-PA) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | FKBER | Functional Area | nvarchar | 16 | 0 | | | | Allow NULL? |
| 31 | START_DATE | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | END_DATE | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | PREDOC_COMP | Predecessor Item Sender Component | nvarchar | 3 | 0 | | | | Allow NULL? |
| 34 | PREDOC_LOGSYS | Logical System of the Predecessor Item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | PREDOC_TYPE | Predecessor Item Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 36 | PREDOC_ID | Predecessor Item ID | nvarchar | 35 | 0 | | | | Allow NULL? |
| 37 | XPREDOC | Predecessor Document | char | 1 | 0 | | | | Allow NULL? |
| 38 | HIERARCHY_ROOT | Single-Character Indicator | char | 1 | 0 | | | | Allow NULL? |
| 39 | HILDOC_COMP | Higher-Level Item Sender Component | nvarchar | 3 | 0 | | | | Allow NULL? |
| 40 | HILDOC_LOGSYS | Logical System of the Higher-Level Item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 41 | HILDOC_TYPE | Higher-Level Item Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 42 | HILDOC_ID | Higher-Level Item ID | nvarchar | 35 | 0 | | | | Allow NULL? |
| 43 | RAI_ERROR | Error During Revenue Accounting Item Creation | char | 1 | 0 | | | | Allow NULL? |
| 44 | DELREL | Delivery Relevant | char | 1 | 0 | | | | Allow NULL? |
| 45 | BILL_PLAN_TYPE | Billing Plan Type | char | 1 | 0 | | | | Allow NULL? |
| 46 | SALES_ORG | Sales Organization (Compatible with SD, CRM, ...) | nvarchar | 20 | 0 | | | | Allow NULL? |
| 47 | DELETION_IND | To Be Deleted | char | 1 | 0 | | | | Allow NULL? |
| 48 | INITIAL_LOAD | Initial Load | char | 1 | 0 | | | | Allow NULL? |
| 49 | LOG_HANDLE | Application Log: Log Handle | nvarchar | 22 | 0 | | | | Allow NULL? |
| 50 | RECEIV_ACCOUNT | Receivables Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 51 | INCEPTION_DATE | Inception Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 52 | AUART | Sales Document Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 53 | KDGRP | Customer group | nvarchar | 2 | 0 | | | | Allow NULL? |
| 54 | LGORT | Storage Location | nvarchar | 4 | 0 | | | | Allow NULL? |
| 55 | MATKL | Material Group | nvarchar | 9 | 0 | | | | Allow NULL? |
| 56 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 57 | PSTYV | Sales document item category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 58 | SPART | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 59 | VBTYP | SD document category | char | 1 | 0 | | | | Allow NULL? |
| 60 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | | | | Allow NULL? |
| 61 | WERKS | Plant (Own or External) | nvarchar | 4 | 0 | | | | Allow NULL? |
