| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | GJAHR | Posting year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR_KK | Allow NULL? |
| 4 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SH_OPBEL_KK | Allow NULL? |
| 5 | VBELN | IS-M/SD: Billing Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | ISPVBELN | Allow NULL? |
| 6 | POSNR | IS-M: Billing Item | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | ISPPOSNR | Allow NULL? |
| 7 | ISPVBELN | IS-M/SD: Publishing Sales Order | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | AVNR | Allow NULL? |
| 8 | ISPPOSNR | Sales Order Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | APNR | Allow NULL? |
| 9 | ISPETENR | Sales Order Schedule Line | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | JAENR | Allow NULL? |
| 10 | ISPAUART | IS-M/SD: Sales Document Types | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | AUART_ISP | Allow NULL? |
| 11 | ISPPOART | Internal Item Type for Sales Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | POART_ISP | Allow NULL? |
| 12 | ISPETART | Schedule Line Type for Internal Sales Order Schedule Line | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ETART_ISP | Allow NULL? |
| 13 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PRSDT | Allow NULL? |
| 14 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FBUDA | Allow NULL? |
| 15 | NETWR | IS-M/SD: Net Value of Item in Document Currency | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | ISMSD_TXW_NETWR_POS | Allow NULL? |
| 16 | ISPBRTWR_P | IS-M/SD: Gross Value of Item in Document Currency | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | ISMSD_TXW_BRTWR_POS | Allow NULL? |
| 17 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SHKZG | Allow NULL? |
| 18 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | ALAND | Allow NULL? |
| 19 | KUNWE | Ship-to party | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNWE | Allow NULL? |
| 20 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 21 | ISPDRERZ | Publication | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | DRERZ | Allow NULL? |
| 22 | ISPPVA | Edition | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | PVA | Allow NULL? |
| 23 | ISPBEZ | Mix Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BEZUGSTYP_JE_PVA | Allow NULL? |
| 24 | ISPLIFART | Delivery Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | LIEFERART | Allow NULL? |
| 25 | ISPDRUCK | IS-M: Plant (Printing Works) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ISPDRUCK | Allow NULL? |
| 26 | ISPBZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | ISPBZPERF | Allow NULL? |
| 27 | ISPFKPER | Billing Frequency | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | FKPER | Allow NULL? |
| 28 | ISPPERFK | Invoice dates (calendar identification) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERFK | Allow NULL? |
| 29 | ISPZAHLW | Billing method | char | 1 | 0 | CHAR | (N' ') | Yes | | JZAHLW | Allow NULL? |
| 30 | ISPETMENGE | Actual invoiced quantity | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TXW_FKIMG | Allow NULL? |
| 31 | ISPETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | ETMEINS | Allow NULL? |
| 32 | ISPETVOR | IS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Order | char | 1 | 0 | CHAR | (N' ') | Yes | | ISPETVOR | Allow NULL? |
| 33 | ISPPRSPER | IS-M: Price Frequency | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ISPPRSPER | Allow NULL? |
| 34 | ISPPRSMLT | IS-M: Numerator in Conversion Factor for Frequencies | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ISMSD_TXW_PRSMLT | Allow NULL? |
| 35 | ISPPRSDIV | IS-M: Denominator for Frequency Conversion Factor | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ISMSD_TXW_PRSDIV | Allow NULL? |
| 36 | ISPFAKVON | IS-M: Billing Period From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAKVON | Allow NULL? |
| 37 | ISPFAKBIS | IS-M: Billing Period To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAKBIS | Allow NULL? |
| 38 | ISPPRSANTZ | IS-M: Numerator for Proportional Prices | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISMSD_TXW_PRSANTZ | Allow NULL? |
| 39 | ISPPRSANTN | IS-M: Denominator for Proportional Prices | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISMSD_TXW_PRSANTN | Allow NULL? |
| 40 | ISPPRSANZP | IS-M: Number of Periods in Billing Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISMSD_TXW_PRSANZP | Allow NULL? |
| 41 | ISPSFPOS | Separate billing document for order item | char | 1 | 0 | CHAR | (N' ') | Yes | | XSEPFKPOS | Allow NULL? |
| 42 | ISPCOAUFNR | Order number of internal CO order for account assignment | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | J_CO_AUFNR | Allow NULL? |
| 43 | ISPVAUSGB | Issue | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VAUSGB | Allow NULL? |
| 44 | ISPXFKBALF | IS-M: Billing based on delivery | char | 1 | 0 | CHAR | (N' ') | Yes | | XFKBASLIEF | Allow NULL? |
| 45 | ISPXFKBAAU | IS-M: Billing based on order | char | 1 | 0 | CHAR | (N' ') | Yes | | XFKBASAUFT | Allow NULL? |
| 46 | ISPXFKRUEK | IS-M: Retroactive Billing of Period Already Billed | char | 1 | 0 | CHAR | (N' ') | Yes | | XFKRUECK | Allow NULL? |
| 47 | FKPERVON | IS-M: Initial Date of Full Billing Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FKPERVON | Allow NULL? |
| 48 | FKPERBIS | IS-M: Closing Date of Full Billing Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FKPERBIS | Allow NULL? |
| 49 | FAKNRRUECK | IS-M: Recalculated Billing Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISPFAKNRRUECK | Allow NULL? |
