| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BLT | NF document category | char | 1 | 0 | | | | Allow NULL? |
| 3 | BELNR | Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | POSNR | Document Item Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | NES | NF Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | NFS | Rate Determination Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | KTA | Actual Rate Date of NF Metal | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | NDT | Key Date for NF Rate Determination | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | NMO | Rate Month for NF Metal | nvarchar | 6 | 0 | | | | Allow NULL? |
| 12 | NKU | Rate in Document Currency | decimal | 15 | 2 | | | | |
| 13 | STK | Statistical Rate | char | 1 | 0 | | | | Allow NULL? |
| 14 | FSP | NF Billing / Invoice Block | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | EDS | Coverage Key for NF Metal | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | EDM | Coverage quantity | decimal | 15 | 3 | | | | |
| 17 | NEB | Base Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | BWR | Base Value in Document Currency | decimal | 15 | 2 | | | | |
| 19 | BWM | Indicator: Base Value Changed Manually | char | 1 | 0 | | | | Allow NULL? |
| 20 | BWA | Old Base Value | decimal | 15 | 2 | | | | |
| 21 | STB | Statistical Base Value | char | 1 | 0 | | | | Allow NULL? |
| 22 | BCU | Base Value Currency Key (Document Currency) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | BZU | Percentage Procurement Surcharge | decimal | 3 | 1 | | | | |
| 24 | NNO | Net Rate | decimal | 13 | 2 | | | | |
| 25 | VGW | Charge Weight of NF Metal for Each Reference Quantity | decimal | 15 | 3 | | | | |
| 26 | VGE | Reference quantity for charge weight | decimal | 5 | 0 | | | | |
| 27 | BEI | Material Provision | char | 1 | 0 | | | | Allow NULL? |
| 28 | KPT | Indicator: Rate determination completed (posting allowed) | char | 1 | 0 | | | | Allow NULL? |
| 29 | BMG | Base Quantity for NF Metal | decimal | 5 | 0 | | | | |
| 30 | BME | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | BEM | Provision Quantity | decimal | 15 | 3 | | | | |
| 32 | EIND | NF Metal Vendor for Coverage | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | BEK | NF Metal Provider | nvarchar | 10 | 0 | | | | Allow NULL? |
| 34 | BZS | Absolute surcharge on base value | decimal | 15 | 2 | | | | |
| 35 | KZS | Provision cash discount for rate | decimal | 15 | 2 | | | | |
| 36 | BKW | Base Value Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 37 | BWB | Base value in base value currency | decimal | 15 | 2 | | | | |
| 38 | BKS | Base Value Rate for Conversion to Local Currency | decimal | 9 | 5 | | | | |
| 39 | NKW | Rate Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 40 | NKN | Rate in Rate Currency (J_1NNCU) | decimal | 13 | 2 | | | | |
| 41 | NKS | Rate for conversion of rate currency to local currency | decimal | 9 | 5 | | | | |
| 42 | KURSK | Exchange Rate for Price Determination | decimal | 9 | 5 | | | | |
| 43 | PRT | CS Internal Hex Field | varbinary | 2 | 0 | | | | |
| 44 | BWE | Reporting Base (Uniform Base) | decimal | 15 | 2 | | | | |
| 45 | NBD | Number of Posting Days | nvarchar | 3 | 0 | | | | Allow NULL? |
| 46 | KPOSN | Condition item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 47 | KGW1 | Structural Weight of NF Metal for Each Reference Quantity | decimal | 15 | 3 | | | | |
| 48 | KGU1 | Reference Quantity for Structural Weight | decimal | 13 | 3 | | | | |
| 49 | EING | Coverage Issue Posting for Structural Weight | char | 1 | 0 | | | | Allow NULL? |
| 50 | KGFE | Indicator: Structural weight missing | char | 1 | 0 | | | | Allow NULL? |
| 51 | KGSP | Indicator: Posting block due to missing structural weight | char | 1 | 0 | | | | Allow NULL? |
| 52 | BSL | Exchange Key for NF Processing | nvarchar | 3 | 0 | | | | Allow NULL? |
| 53 | LOEKZ | Deletion Indicator in Purchasing Document | char | 1 | 0 | | | | Allow NULL? |
| 54 | VTP_NFS | CS: Default Type for NF Defaults | nvarchar | 2 | 0 | | | | Allow NULL? |
| 55 | VTP_NEB | CS: Default Type for NF Defaults | nvarchar | 2 | 0 | | | | Allow NULL? |
