| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | DOCNUM | Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | ITMNUM | Document Item Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | TAXTYP | Tax Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | SERNO | CIAP Document Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | KNTYP | Object Assignment Type | nvarchar | 35 | 0 | | | | Allow NULL? |
| 8 | CONDNO | CIAP Condition Number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | REGIO | Region (State, Province, County) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | BRANCH | Business Place | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 15 | ANLN1 | Main Asset Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | ANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | KOKRS | Controlling Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | KOSTL | Cost Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 19 | PRCTR | Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | AUFNR | Order Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | PSPNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | | | Allow NULL? |
| 23 | KOART | Account Type | char | 1 | 0 | | | | Allow NULL? |
| 24 | SUP_KEY_TYPES1 | Additional Key 1 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | SUP_KEY_VALUE1 | Value for Additional Key 1 | nvarchar | 25 | 0 | | | | Allow NULL? |
| 26 | SUP_KEY_TYPES2 | Additional Key 2 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | SUP_KEY_VALUE2 | Value for Additional Key 2 | nvarchar | 25 | 0 | | | | Allow NULL? |
| 28 | CIAP_VALUE_START | Start Date of CIAP Value in Current CIAP Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | CIAP_VALUE_STOP | End Date of CIAP Value in Current CIAP Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | CIAP_START_DATE | Initial Start Date of the Current CIAP Object | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | | | | Allow NULL? |
| 32 | TAXVAL | Tax Value | decimal | 15 | 2 | | | | |
| 33 | MENGE | Quantity | decimal | 13 | 3 | | | | |
| 34 | RET_SALE_LOSS | Describes how a CIAP object was deactivated | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | BU_TM | Time of Entry | nvarchar | 6 | 0 | | | | Allow NULL? |
| 38 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 39 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 40 | ERDTM | Time of Entry | nvarchar | 6 | 0 | | | | Allow NULL? |
| 41 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 42 | UPDDT | Date of the Last Document Update | nvarchar | 8 | 0 | | | | Allow NULL? |
| 43 | UPDTM | Time of Entry | nvarchar | 6 | 0 | | | | Allow NULL? |
| 44 | VORGN | Transaction Type for General Ledger | nvarchar | 4 | 0 | | | | Allow NULL? |
| 45 | TCODE | Transaction Code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 46 | BWASL | Asset Transaction Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 47 | BWART | Movement Type (Inventory Management) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 48 | BELNR | Reference Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 49 | LFDNR | Sequence number (four characters) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 50 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 51 | AWKEY | Reference Key | nvarchar | 20 | 0 | | | | Allow NULL? |
| 52 | AWTYP | Reference Transaction | nvarchar | 5 | 0 | | | | Allow NULL? |
| 53 | AWORG | Reference Organizational Units | nvarchar | 10 | 0 | | | | Allow NULL? |
| 54 | AWSYS | Logical System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 55 | DOCREF | Reference to NF | nvarchar | 10 | 0 | | | | Allow NULL? |
| 56 | ITMREF | Reference to item number (Return) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 57 | REFTYP | Reference type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 58 | REFKEY | Reference to source document | nvarchar | 35 | 0 | | | | Allow NULL? |
| 59 | REFITM | Reference item to source document | nvarchar | 6 | 0 | | | | Allow NULL? |
| 60 | LOG_KEY_CHAR35 | Sender Key | nvarchar | 35 | 0 | | | | Allow NULL? |
| 61 | CIAP_OBJ_FLAG | Identified as CIAP Object | char | 1 | 0 | | | | Allow NULL? |
| 62 | CIAP_STATUS | Internal Status of the CIAP Object Set by the System | nvarchar | 3 | 0 | | | | Allow NULL? |
| 63 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 64 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 65 | TEXT | Text Field | nvarchar | 50 | 0 | | | | Allow NULL? |
