| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | GUID_CUIT | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 3 | GUID_CUHD | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 4 | ITVSY | External Document Item ID from Feeder System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | ERNAM | Name of User Who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 6 | CRTSP | UTC Time Stamp When Object Was Added | decimal | 15 | 0 | | | | |
| 7 | AENAM | Name of User Who Changed the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | CHTSP | UTC Time Stamp When Object Was Changed | decimal | 15 | 0 | | | | |
| 9 | CUITA | Item Category in SAP GTS | nvarchar | 6 | 0 | | | | Allow NULL? |
| 10 | GUID_FTVBS | Primary Key of Business Partner | varbinary | 16 | 0 | | | | |
| 11 | ITLEG | Indicator: Item Is Active | char | 1 | 0 | | | | Allow NULL? |
| 12 | ITREC | Indicator: Item Is Relevant for New Check | char | 1 | 0 | | | | Allow NULL? |
| 13 | CTYPL | Country of Actual Physical Location | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | CTYDP | Country of Departure Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | CTYAR | Country of Destination Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | CTYIV | Billing Country | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | CTYTR | Trading Country for Legal and Logistics Services | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | GUID_PR | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 19 | PRBUM | Base Unit of Measure in Product Master | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | DOCUM | Weight Unit and Quantity Unit of Business Transaction | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | CVQDP_FLT | Conversion Factor: Doc. Unit/Base Unit as Floating Pt. Field | float | 15 | 16 | | | | |
| 22 | CUCOO | Custom Product's Country of Origin | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | CUROO | Product's Region of Origin (CIC) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | DOCUR | Currency of Business Transaction | nvarchar | 5 | 0 | | | | Allow NULL? |
| 25 | RPTDT | Time Stamp for Business Transaction | decimal | 15 | 0 | | | | |
| 26 | NETVAL_FLT | Net Value as Floating Point Field for SLL | float | 15 | 16 | | | | |
| 27 | NTCUR | Currency of a Value | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | GROVAL_FLT | Gross Value as Floating Point Field | float | 15 | 16 | | | | |
| 29 | GRCUR | Currency of a Value | nvarchar | 5 | 0 | | | | Allow NULL? |
| 30 | TAXVAL_FLT | Tax Value as Floating Point Field | float | 15 | 16 | | | | |
| 31 | TXCUR | Currency of a Value | nvarchar | 5 | 0 | | | | Allow NULL? |
| 32 | QUANT_FLT | Quantity as Floating Point Field | float | 15 | 16 | | | | |
| 33 | QUAUM | Unit of Measurement of a Dimension | nvarchar | 3 | 0 | | | | Allow NULL? |
| 34 | WEINET_FLT | Net Weight as Floating Point Field | float | 15 | 16 | | | | |
| 35 | WEIGRO_FLT | Gross Weight as Floating Point Field | float | 15 | 16 | | | | |
| 36 | WEIDIM | Unit of Weight | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | INCOT | Incoterm | nvarchar | 3 | 0 | | | | Allow NULL? |
| 38 | INCOL | Incoterm Location | nvarchar | 40 | 0 | | | | Allow NULL? |
| 39 | FRCHG | Free-of-Charge Item | char | 1 | 0 | | | | Allow NULL? |
| 40 | EXART | Customs Business Transaction Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 41 | AUART | ExportType | nvarchar | 2 | 0 | | | | Allow NULL? |
| 42 | DCTYP | Customs Status/Declaration | nvarchar | 10 | 0 | | | | Allow NULL? |
| 43 | FLCNF | Conformity Indicator | char | 1 | 0 | | | | Allow NULL? |
| 44 | CCNGA | Range of Goods | nvarchar | 2 | 0 | | | | Allow NULL? |
| 45 | ITSTA | Item Status | char | 1 | 0 | | | | Allow NULL? |
| 46 | ITREF | Reference Document Item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 47 | CRECO | Method of Entry | nvarchar | 2 | 0 | | | | Allow NULL? |
| 48 | SVMEB | Indicator: Additional Information/Export Restriction | char | 1 | 0 | | | | Allow NULL? |
| 49 | SVMEA | Ind.: Additional Information / Export Duties | char | 1 | 0 | | | | Allow NULL? |
| 50 | SVMEX | Ind.: Additional Information / Export | char | 1 | 0 | | | | Allow NULL? |
| 51 | SVMEE | Ind.: Additional Information / Export EU | char | 1 | 0 | | | | Allow NULL? |
| 52 | SVMCO | Ind.: Additional Information / Export Country | nvarchar | 3 | 0 | | | | Allow NULL? |
| 53 | SGICD | SGI Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 54 | SGIQU_FLT | Sensitive SGI Quantity | float | 15 | 16 | | | | |
| 55 | GUID_CUIV | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 56 | ITNEX | External Identification Number of Doc. Item for EDI Commun. | nvarchar | 20 | 0 | | | | Allow NULL? |
| 57 | GUID_BOPHD | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 58 | PRMET | Preference: Comparison Method | char | 1 | 0 | | | | Allow NULL? |
| 59 | EPVAL_FLT | Comparison Value Preference from Document Item | float | 15 | 16 | | | | |
| 60 | CPVAL_FLT | Preference Threshold Value | float | 15 | 16 | | | | |
| 61 | PRCUR | Currency of Comparison Value for Preference Processing | nvarchar | 5 | 0 | | | | Allow NULL? |
| 62 | PRECD | Preference Indicator for Customs Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 63 | PREFL | Preference Status: 0 - No / 1 - Yes | char | 1 | 0 | | | | Allow NULL? |
| 64 | SUPGA | Number of Packages in Safekeeping | int | 10 | 0 | | | | Allow NULL? |
| 65 | SUPGB | Number of Declared Packages | int | 10 | 0 | | | | Allow NULL? |
| 66 | RRATEDIM_FLT | Base Weight for Restitution Rate | float | 15 | 16 | | | | |
| 67 | RRATEUM | Unit of Measurement of a Dimension | nvarchar | 3 | 0 | | | | Allow NULL? |
| 68 | RRATEAMNT_FLT | Restitution Rate by Base Weight | float | 15 | 16 | | | | |
| 69 | RRATECU | Currency of a Value | nvarchar | 5 | 0 | | | | Allow NULL? |
| 70 | IVMST | Update Status for Inventory Management | char | 1 | 0 | | | | Allow NULL? |
| 71 | PRDES | Target Procedure | nvarchar | 2 | 0 | | | | Allow NULL? |
| 72 | PRSRC | Source Procedure | nvarchar | 2 | 0 | | | | Allow NULL? |
| 73 | ECPID | Customs ID for Customs Procedures CWH, IP, PUCC | nvarchar | 10 | 0 | | | | Allow NULL? |
| 74 | CUFIS | Customs Status | char | 1 | 0 | | | | Allow NULL? |
| 75 | IVMIT | Inventory Management: Item ID | nvarchar | 6 | 0 | | | | Allow NULL? |
| 76 | ZTERM | Term of Payment | nvarchar | 6 | 0 | | | | Allow NULL? |
| 77 | IVMRE | Reservation Status for Inventory Management | char | 1 | 0 | | | | Allow NULL? |
| 78 | QUABU_FLT | Document Quantity in Product's Base Unit of Measure | float | 15 | 16 | | | | |
| 79 | IZUAB | Indicator: Receipt/Issue | char | 1 | 0 | | | | Allow NULL? |
| 80 | NORDES | 'Normal Treatment' Indicator | char | 1 | 0 | | | | Allow NULL? |
| 81 | IBLIS | Category of Goods Movement | char | 1 | 0 | | | | Allow NULL? |
| 82 | IKMAT | Indicator for KMAT | char | 1 | 0 | | | | Allow NULL? |
| 83 | IDGDS | Additional ID for Stock Separation in CWH, IP, PUCC | nvarchar | 20 | 0 | | | | Allow NULL? |
| 84 | LOCID | Location ID | nvarchar | 3 | 0 | | | | Allow NULL? |
| 85 | ADDDA1 | Additional Data 1 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 86 | ADDDA2 | Additional Data 2 | nvarchar | 15 | 0 | | | | Allow NULL? |
| 87 | ADDDA3 | Additional Data 3 | nvarchar | 30 | 0 | | | | Allow NULL? |
| 88 | ADDDA0 | Additional Data for Unrestricted Use | char | 1 | 0 | | | | Allow NULL? |
| 89 | ENDUSE | End Use of a Customs Product (for Classification) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 90 | OPREL | Declaration for Outward Processing | char | 1 | 0 | | | | Allow NULL? |
| 91 | ECPID_OP | Customs ID for Outward Processing Customs Procedure | nvarchar | 10 | 0 | | | | Allow NULL? |
| 92 | IDGDSP | Additional ID for Stock Separation in Outward Processing | nvarchar | 20 | 0 | | | | Allow NULL? |
| 93 | IVMST_OP | Posting Status of Inventory Management for Outw. Processing | char | 1 | 0 | | | | Allow NULL? |
| 94 | STDEX | Standard Exchange (Indicator) | char | 1 | 0 | | | | Allow NULL? |
| 95 | ORGVS | Identification of Organizational Unit from Feeder System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 96 | BPTVS | Document Item Category ID from Feeder System | nvarchar | 5 | 0 | | | | Allow NULL? |
| 97 | PRONR | Project Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 98 | SCPREL | Declaration in Special Customs Procedure | char | 1 | 0 | | | | Allow NULL? |
| 99 | IVMST_SCP | Posting Status of Inv. Mgt. for Special Customs Procedure | char | 1 | 0 | | | | Allow NULL? |
| 100 | GUID_REFPR | GUID of Ref. Product for Special Customs Proc. (IP/PUCC) | varbinary | 16 | 0 | | | | |
| 101 | CUSWEI | Base for Customs Duty Calculation by Weight | char | 1 | 0 | | | | Allow NULL? |
| 102 | BOMID | Unique Identification of a Document BOP | nvarchar | 32 | 0 | | | | Allow NULL? |
| 103 | ITMMN | Item Number of Main Item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 104 | LCLPR | Type of Logistics Process for Legal Control | nvarchar | 2 | 0 | | | | Allow NULL? |
| 105 | IVMST_FCP | Posting Status of Inventory Management for FC w/PEU | char | 1 | 0 | | | | Allow NULL? |
| 106 | FCPREL | Relevancy for Free Circulation for Prescribed End Use | char | 1 | 0 | | | | Allow NULL? |
| 107 | FLMVQ | Flag: Minimum Values and Quantities Exist | char | 1 | 0 | | | | Allow NULL? |
| 108 | FLEMC | Flag: Relevant for Excise Duty | char | 1 | 0 | | | | Allow NULL? |
| 109 | TAX_GROUP | Product Tax Group | nvarchar | 20 | 0 | | | | Allow NULL? |
| 110 | CVRTS | Fixed Exchange Rate (Indicator) | char | 1 | 0 | | | | Allow NULL? |
| 111 | CVRTQ | Indirect Quoted Exchange Rate | decimal | 9 | 5 | | | | |