| 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 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | JHAK | AVM_NR | Allow NULL? |
| 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | JHAP | POS_NR | Allow NULL? |
| 4 | GPROLLE | IS-M: Business Partner Role | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJG39 | JPARVW | Allow NULL? |
| 5 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | CHAR | (N' ') | No | JGTGPNR | GPNR | Allow NULL? |
| 6 | PARZA | IS-M: Partner Role Counter | nvarchar | 3 | 0 | NUMC | (N'000') | No | | JPARZA | Allow NULL? |
| 7 | GRUPPABRNR | IS-M/AM: Billing Dataset | nvarchar | 3 | 0 | NUMC | (N'000') | No | JHAGA | GRUPPABRNR | Allow NULL? |
| 8 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | JHAU | UPOS_NR | Allow NULL? |
| 9 | EIN_NR | IS-M: Schedule Line | nvarchar | 6 | 0 | NUMC | (N'000000') | No | JHAE | EIN_NR | Allow NULL? |
| 10 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | NUMC | (N'000000') | No | JHAMOT | MOTIV_NR | Allow NULL? |
| 11 | ADRNR | IS-M: Address Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | JGTSADR | JADRNR | Allow NULL? |
| 12 | LOGADR | IS-M: Logical Address Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | JLOGADR | Allow NULL? |
| 13 | ADRESSVAR | IS-M: Address Variant | char | 1 | 0 | CHAR | (N' ') | Yes | | ADRESSVAR | Allow NULL? |
| 14 | ADR_ANRED | Form of Address Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJG43 | JANRED | Allow NULL? |
| 15 | INSZ_NR | IS-M: Advertiser assignment number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | INSZ_NR | Allow NULL? |
| 16 | XINSBLANK | IS-M: Agency Order Without Advertiser Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XINSBLANK | Allow NULL? |
| 17 | HERK | IS-M: Use of Address | char | 1 | 0 | CHAR | (N' ') | Yes | | HERK | Allow NULL? |
| 18 | PARNR | IS-M: Contact Person | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISM_CNTCT_PRSN | Allow NULL? |
| 19 | X_ADRND | IS-M: Business Address For Contact Person Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | X_ADRND | Allow NULL? |
| 20 | X_ADRNP | IS-M: Home Address For Contact Person Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | X_ADRNP | Allow NULL? |
| 21 | XCPDK | Indicator: Is the account a one-time account? | char | 1 | 0 | CHAR | (N' ') | Yes | | XCPDK | Allow NULL? |
| 22 | SADR_ADRNR | Addresses: Address Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SADR | CADNR | Allow NULL? |
| 23 | POS_ART | IS-M: Order-Publishing-Media - Item Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJH17 | AVMPOS_ART | Allow NULL? |
| 24 | BELEG_ART | IS-M: Voucher Type (Proof) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJJB1 | PAM_BELART | Allow NULL? |
| 25 | BELEG_ANZ | IS-M: Number of Voucher Copies | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | PAM_BELANZ | Allow NULL? |
| 26 | BELEG_KOST | IS-M: Subject to Charge | char | 1 | 0 | CHAR | (N' ') | Yes | | BLART_KOST | Allow NULL? |
| 27 | KORR_ART | IS-M: Customer correction type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJH63 | PAM_KORART | Allow NULL? |
| 28 | KORR_ANZ | IS-M: Number of Customer Adjustment Deductions | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PAM_KORANZ | Allow NULL? |
| 29 | RECH_KOPIE | IS-M: Number of Invoice Copies | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | RECH_KOPIE | Allow NULL? |
| 30 | XAUSPOS | IS-M: Voucher Copy Recipient Was Assigned in the Item | char | 1 | 0 | CHAR | (N' ') | Yes | | XAUSPOS | Allow NULL? |
| 31 | XAUSUPOS | IS-M: Voucher Copy Recipient Was Assigned in Sub-Item | char | 1 | 0 | CHAR | (N' ') | Yes | | XAUSUNPOS | Allow NULL? |
| 32 | XAUSEINT | IS-M: Voucher Copy Rec.Assigned in Schedule Line Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XAUSEINTL | Allow NULL? |
| 33 | BE_DRERZ | Publication | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JDTDRER | DRERZ | Allow NULL? |
| 34 | BE_PVA | Edition | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JDTPVA | PVA | Allow NULL? |
| 35 | BE_DATUM | Publication Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERSCHDAT | Allow NULL? |
| 36 | BE_VBELN | IS-M/SD: Publishing Sales Order | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JKAK | AVNR | Allow NULL? |
| 37 | BE_POSNR | Sales Order Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | JKAP | APNR | Allow NULL? |
| 38 | BE_POSEX | External Item Number (Purchase Order Item) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | POSEX_ISP | Allow NULL? |
| 39 | BE_ADRNR | Address | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SADRP | ADRNR | Allow NULL? |
| 40 | BE_ERROR | IS-M: Error when Creating Voucher Shipping Order Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XBE_ERROR | Allow NULL? |
| 41 | ADRC_ADDRNUMBER | Address number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | ADRC | AD_ADDRNUM | Allow NULL? |
