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