| 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 | ORDNR | Request Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | | ORDNR_KK | Allow NULL? |
| 3 | VERSN | Execution Period of a Standing Request | nvarchar | 3 | 0 | NUMC | (N'000') | No | | AOVERSN_KK | Allow NULL? |
| 4 | LINENR | Line Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | LINENR_KK | Allow NULL? |
| 5 | BUKRS_BP | Company Code of Business Partner Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS_BP_KK | Allow NULL? |
| 6 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPART_KK | Allow NULL? |
| 7 | VKONT | Contract Account Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | VKONT_KK | Allow NULL? |
| 8 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VTREF_KK | Allow NULL? |
| 9 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | HVORG_KK | Allow NULL? |
| 10 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TVORG_KK | Allow NULL? |
| 11 | KOFIZ | Account Determination ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | KOFIZ_KK | Allow NULL? |
| 12 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 13 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SPART_KK | Allow NULL? |
| 14 | HKONT_BP | Reconciliation Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | HKONT_BP_KK | Allow NULL? |
| 15 | TEXTPOS | Item Text for Request | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TEXTPOS_KK | Allow NULL? |
| 16 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 17 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDN_KK | Allow NULL? |
| 18 | FAEDS | Due Date for Cash Discount | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDS_KK | Allow NULL? |
| 19 | DISC_DAYS | Cash Discount Days | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | DISC_DAYS_KK | Allow NULL? |
| 20 | SKTPZ | Cash discount rate | decimal | 5 | 3 | DEC | ((0)) | Yes | | SKTPZ_KK | |
| 21 | BETRW | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETRW_KK | |
| 22 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETRH_KK | |
| 23 | KURSF | Exchange rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURSF_KK | |
| 24 | PYBLOCK | Payment Lock | char | 1 | 0 | CHAR | (N' ') | Yes | | PYBLOCK_KK | Allow NULL? |
| 25 | PYMET | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | * | PYMET_KK | Allow NULL? |
| 26 | GRKEY | Grouping Key for Displaying Open Items | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | GRKEY_KK | Allow NULL? |
| 27 | MAHNV | Dunning Procedure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MAHNV_KK | Allow NULL? |
| 28 | DNBLOCK | Dunning Lock | char | 1 | 0 | CHAR | (N' ') | Yes | | DNBLOCK_KK | Allow NULL? |
| 29 | INTBLOCK | Interest Lock | char | 1 | 0 | CHAR | (N' ') | Yes | | INTBLOCK_KK | Allow NULL? |
| 30 | CRLBLOCK | Clearing Lock | char | 1 | 0 | CHAR | (N' ') | Yes | | CRLBLOCK_KK | Allow NULL? |
| 31 | EMGPA | Alternative Business Partner for Payments | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EMGPA_KK | Allow NULL? |
| 32 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | EMBVT_KK | Allow NULL? |
| 33 | EMCRD | Alternative Payment Card ID in Document | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | EMCRD_KK | Allow NULL? |
| 34 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PERSL_KK | Allow NULL? |
| 35 | ABRZU | Lower Limit of Settlement Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ABRZU_KK | Allow NULL? |
| 36 | ABRZO | Upper Limit of the Billing Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ABRZO_KK | Allow NULL? |
| 37 | BUKRS | Company Code of G/L Account Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS_AC_KK | Allow NULL? |
| 38 | HKONT | G/L Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | HKONT_AC_KK | Allow NULL? |
| 39 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 40 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 41 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 42 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KDAUF | Allow NULL? |
| 43 | KDPOS | Item Number in Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KDPOS | Allow NULL? |
| 44 | KDEIN | Delivery Schedule for Sales Order | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | KDEIN | Allow NULL? |
| 45 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PS_PSP_PNR | Allow NULL? |
| 46 | PAOBJNR | Profitability Segment Number (CO-PA) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | RKEOBJNR | Allow NULL? |
| 47 | PASUBNR | Profitability segment changes (CO-PA) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | RKESUBNR | Allow NULL? |
| 48 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | TXJCD | Allow NULL? |
| 49 | FINRE | Contract Account of Final Recipient | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | FINRE_KK | Allow NULL? |
| 50 | RDSTA | Current Distribution Status | char | 1 | 0 | CHAR | (N' ') | Yes | | RDSTA_KK | Allow NULL? |
| 51 | RDSTB | Last Distribution Status Reported | char | 1 | 0 | CHAR | (N' ') | Yes | | RDSTB_KK | Allow NULL? |
| 52 | FDGRP | Planning Group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T035 | FDGRP_KK | Allow NULL? |
| 53 | FDLEV | Planning level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T036 | FDLEV_KK | Allow NULL? |
| 54 | FDZTG | Additional Days for Cash Management | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FDZTG_KK | Allow NULL? |
| 55 | SUBAP | Subapplication in Contract Accounts Receivable and Payable | char | 1 | 0 | CHAR | (N' ') | Yes | | SUBAP_KK | Allow NULL? |
| 56 | PSGRP | Grouping Key for Document Items | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | PSGRP_KK | Allow NULL? |
| 57 | ANLN1 | Main Asset Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | ANLN1 | Allow NULL? |
| 58 | ANLN2 | Asset Subnumber | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ANLN2 | Allow NULL? |
| 59 | ANBWA | Asset Transaction Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | ANBWA | Allow NULL? |
| 60 | BZDAT | Asset value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BZDAT | Allow NULL? |
| 61 | XEIBH | Create Separate Document in General Ledger | char | 1 | 0 | CHAR | (N' ') | Yes | | XEIBH_KK | Allow NULL? |
| 62 | XEIPH | Create Line Item in General Ledger | char | 1 | 0 | CHAR | (N' ') | Yes | | XEIPH_KK | Allow NULL? |
| 63 | MENGE | Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MENGE_D | |
| 64 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEINS | Allow NULL? |
| 65 | KBLPOS_TAX | Line Item for Earmarked Funds (Tax Part) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | KBLPOS_TAX_KK | Allow NULL? |
