| 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 | * | MANDT | Allow NULL? |
| 2 | VSNMR | Number or description of a version | nvarchar | 12 | 0 | CHAR | (N' ') | No | | VSNMR | Allow NULL? |
| 3 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | VBELN | Allow NULL? |
| 4 | POSNR | Item number of the SD document | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | POSNR | Allow NULL? |
| 5 | KONDA | Price group (customer) | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | KONDA | Allow NULL? |
| 6 | KDGRP | Customer group | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | KDGRP | Allow NULL? |
| 7 | BZIRK | Sales district | nvarchar | 6 | 0 | CHAR | (N' ') | No | * | BZIRK | Allow NULL? |
| 8 | PLTYP | Price list type | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | PLTYP | Allow NULL? |
| 9 | INCO1 | Incoterms (Part 1) | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | INCO1 | Allow NULL? |
| 10 | INCO2 | Incoterms (Part 2) | nvarchar | 28 | 0 | CHAR | (N' ') | No | | INCO2 | Allow NULL? |
| 11 | KZAZU | Order Combination Indicator | char | 1 | 0 | CHAR | (N' ') | No | | KZAZU_D | Allow NULL? |
| 12 | PERFK | Invoice dates (calendar identification) | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | PERFK | Allow NULL? |
| 13 | PERRL | Invoice list schedule (calendar identification) | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | PERRL | Allow NULL? |
| 14 | MRNKZ | Manual invoice maintenance | char | 1 | 0 | CHAR | (N' ') | No | | MRNKZ | Allow NULL? |
| 15 | KURRF | Exchange rate for FI postings | decimal | 9 | 5 | DEC | ((0)) | No | | KURRF | |
| 16 | VALTG | Additional value days | nvarchar | 2 | 0 | NUMC | (N'00') | No | | VALTG | Allow NULL? |
| 17 | VALDT | Fixed value date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | VALDT | Allow NULL? |
| 18 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | No | | DZTERM | Allow NULL? |
| 19 | ZLSCH | Payment Method | char | 1 | 0 | CHAR | (N' ') | No | * | SCHZW_BSEG | Allow NULL? |
| 20 | KTGRD | Account assignment group for this customer | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | KTGRD | Allow NULL? |
| 21 | KURSK | Exchange Rate for Price Determination | decimal | 9 | 5 | DEC | ((0)) | No | | KURSK | |
| 22 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | PRSDT | Allow NULL? |
| 23 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FKDAT | Allow NULL? |
| 24 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FBUDA | Allow NULL? |
| 25 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 26 | POPER | Posting period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | POPER | Allow NULL? |
| 27 | STCUR | Exchange rate for statistics | decimal | 9 | 5 | DEC | ((0)) | No | | STCUR | |
| 28 | MSCHL | Dunning key | char | 1 | 0 | CHAR | (N' ') | No | * | MSCHL | Allow NULL? |
| 29 | MANSP | Dunning block | char | 1 | 0 | CHAR | (N' ') | No | * | MANSP | Allow NULL? |
| 30 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | FPLNR | Allow NULL? |
| 31 | WAKTION | Promotion | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | WAKTION | Allow NULL? |
| 32 | ABSSC | Payment guarantee procedure | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | ABSSCHE_CM | Allow NULL? |
| 33 | LCNUM | Financial doc. processing: Internal financial doc. number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LCNUM | Allow NULL? |
| 34 | J_1AFITP | Tax type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | J_1AFITP_D | Allow NULL? |
| 35 | J_1ARFZ | Reason for zero VAT | char | 1 | 0 | CHAR | (N' ') | Yes | * | J_1ARFZVAT | Allow NULL? |
| 36 | J_1AREGIO | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | REGIO | Allow NULL? |
| 37 | J_1AGICD | Activity Code for Gross Income Tax | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | J_1AGICD_D | Allow NULL? |
| 38 | J_1ADTYP | Distribution Type for Employment Tax | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | J_1ADTYP_D | Allow NULL? |
| 39 | J_1ATXREL | Tax relevant classification | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | J_1ATXREL_ | Allow NULL? |
| 40 | ABTNR | Department number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ABTNR | Allow NULL? |
| 41 | EMPST | Receiving point | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | EMPST | Allow NULL? |
| 42 | BSTKD | Customer purchase order number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BSTKD | Allow NULL? |
| 43 | BSTDK | Customer purchase order date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BSTDK | Allow NULL? |
| 44 | BSARK | Customer purchase order type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BSARK | Allow NULL? |
| 45 | IHREZ | Your Reference | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | IHREZ | Allow NULL? |
| 46 | BSTKD_E | Ship-to Party's Purchase Order Number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BSTKD_E | Allow NULL? |
| 47 | BSTDK_E | Ship-to party's PO date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BSTDK_E | Allow NULL? |
| 48 | BSARK_E | Ship-to party purchase order type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BSARK_E | Allow NULL? |
| 49 | IHREZ_E | Ship-to party character | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | IHREZ_E | Allow NULL? |
| 50 | POSEX_E | Item Number of the Underlying Purchase Order | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | POSEX_E | Allow NULL? |
| 51 | KURSK_DAT | Translation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WWERT_D | Allow NULL? |
| 52 | KURRF_DAT | Translation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WWERT_D | Allow NULL? |
| 53 | KDKG1 | Customer condition group 1 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | KDKG1 | Allow NULL? |
| 54 | KDKG2 | Customer condition group 2 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | KDKG2 | Allow NULL? |
| 55 | KDKG3 | Customer condition group 3 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | KDKG3 | Allow NULL? |
| 56 | KDKG4 | Customer condition group 4 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | KDKG4 | Allow NULL? |
| 57 | KDKG5 | Customer condition group 5 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | KDKG5 | Allow NULL? |
| 58 | WKWAE | Value contract currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WKWAE | Allow NULL? |
| 59 | WKKUR | Exchange rate in value contract currency | decimal | 9 | 5 | DEC | ((0)) | Yes | | WKKUR | |
| 60 | AKWAE | Currency key for letter-of-credit procg in foreign trade | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | AKWAE | Allow NULL? |
| 61 | AKKUR | Exchange rate for letter-of-credit procg in foreign trade | decimal | 9 | 5 | DEC | ((0)) | Yes | | AKKUR | |
| 62 | AKPRZ | Depreciation percentage for financial document processing | decimal | 5 | 2 | DEC | ((0)) | Yes | | AKPRZ | |
| 63 | J_1AINDXP | Inflation Index | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | J_1AINDXP | Allow NULL? |
| 64 | J_1AIDATEP | Indexing base date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1AIDATES | Allow NULL? |
| 65 | BSTKD_M | Customer PO number as matchcode field | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BSTKD_M | Allow NULL? |
| 66 | DELCO | Agreed delivery time | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | DELCO | Allow NULL? |
| 67 | FFPRF | Dynamic Item Processor Profile | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | AD01PROFNR | Allow NULL? |
| 68 | BEMOT | Accounting Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BEMOT | Allow NULL? |
| 69 | FAKTF | Billing form | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | FAKTF | Allow NULL? |
| 70 | RRREL | Revenue recognition category | char | 1 | 0 | CHAR | (N' ') | Yes | | RR_RELTYP | Allow NULL? |
| 71 | ACDATV | Proposed start date for accrual period | char | 1 | 0 | CHAR | (N' ') | Yes | | RR_ACDATV | Allow NULL? |
| 72 | VSART | Shipping type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T173 | VSARTTR | Allow NULL? |
| 73 | TRATY | Means-of-Transport Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVTY | TRATY | Allow NULL? |
| 74 | TRMTYP | Means of Transport | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | TRMTYP | Allow NULL? |
| 75 | SDABW | Special processing indicator | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVSAK | SDABW | Allow NULL? |
| 76 | WMINR | Product catalog number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | WWMI | WMINR | Allow NULL? |
| 77 | FKBER | Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | TFKB | FKBER | Allow NULL? |
| 78 | PODKZ | Relevant for POD processing | char | 1 | 0 | CHAR | (N' ') | Yes | | PODKZ | Allow NULL? |
| 79 | CAMPAIGN | Generic project planning: GUID from external R/3 system | varbinary | 16 | 0 | RAW | | Yes | | CGPL_GUID16_R3 | |
| 80 | VKONT | Character Field of Length 12 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CHAR12 | Allow NULL? |
| 81 | STCODE | LST CST applicability code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | J_1ISTCODE | Allow NULL? |
| 82 | FORMC1 | Form Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | J_1IFORTYP | Allow NULL? |
| 83 | FORMC2 | Form Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | J_1IFORTYP | Allow NULL? |
| 84 | STEUC | Control code for consumption taxes in foreign trade | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | STEUC | Allow NULL? |
