| 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 | PCARD_DOC | Document number for procurement card statements | nvarchar | 10 | 0 | CHAR | (N' ') | No | BBP_PCPOS | BBPPCDOCNR | Allow NULL? |
| 3 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 4 | PC_LINE | Procurement card line number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | BBPPCLIN | Allow NULL? |
| 5 | PC_SUBLINE | Sub-line number for procurement card data feed | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | BBPPCSLI | Allow NULL? |
| 6 | PCCOPROC | Procurement card splitting percentage | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | BBPPCPROC | |
| 7 | COMP_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 8 | CO_AREA | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KOKRS | Allow NULL? |
| 9 | FM_AREA | Financial Management Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FIKRS | Allow NULL? |
| 10 | ACCOUNT | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAKNR | Allow NULL? |
| 11 | GL_ACCOUNT | General Ledger Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | HKONT | Allow NULL? |
| 12 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 13 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | TXJCD | Allow NULL? |
| 14 | CALCTAX | Tax calculation indicator for procurement card | char | 1 | 0 | CHAR | (N' ') | Yes | | BBPCALCTAX | Allow NULL? |
| 15 | BUS_AREA | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 16 | BUS_ACT | Business Transaction | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | GLVOR | Allow NULL? |
| 17 | OBJ_TYPE | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | AWTYP | Allow NULL? |
| 18 | COSTCENTER | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 19 | ORDERID | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 20 | ORDER_ITNO | Order Item Number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CO_POSNR | Allow NULL? |
| 21 | ASSET_NO | Main Asset Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | ANLN1 | Allow NULL? |
| 22 | SUB_NUMBER | Asset Subnumber | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ANLN2 | Allow NULL? |
| 23 | ASVAL_DATE | Reference Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BBP_BZDAT | Allow NULL? |
| 24 | PROFIT_CTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 25 | WBS_ELEM | Work breakdown structure element (WBS element) | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | BBP_POSID | Allow NULL? |
| 26 | NETWORK | Network Number for Account Assignment | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | NPLNR | Allow NULL? |
| 27 | ACTIVITY | Operation/Activity Number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | VORNR | Allow NULL? |
| 28 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | * | FIPOS | Allow NULL? |
| 29 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FISTL | Allow NULL? |
| 30 | FUND | Fund | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BP_GEBER | Allow NULL? |
| 31 | FUNDS_RES | Document Number for Earmarked Funds | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KBLNR_FI | Allow NULL? |
| 32 | RES_ITEM | Earmarked Funds: Document Item | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | KBLPOS | Allow NULL? |
| 33 | SALES_ORD | Sales Order Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KDAUF | Allow NULL? |
| 34 | S_ORD_ITEM | Item Number in Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KDPOS | Allow NULL? |
| 35 | ZZSPREG | Special Region | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | ZZSPREG | ZREGION | Allow NULL? |
| 36 | ZZBUSPARTN | Business partner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ZZBUSPARTN | Allow NULL? |
| 37 | ZZPRODUCT | Product group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ZZPRODUCT | Allow NULL? |
| 38 | ZZLOCA | City | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ZZLOCA | Allow NULL? |
| 39 | ZZCHAN | Distribution channel | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ZZCHAN | Allow NULL? |
| 40 | ZZLOB | BUSINESS LINE | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | * | ZZLOB | Allow NULL? |
| 41 | ZZNFAL | | nvarchar | 10 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 42 | ZZUSERFLD1 | Territory | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | ZFU1 | ZZUSERFLD1 | Allow NULL? |
| 43 | ZZUSERFLD2 | Owner/Cont. | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ZZUSERFLD2 | Allow NULL? |
| 44 | ZZUSERFLD3 | Vein | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | ZZUSERFLD3 | Allow NULL? |
| 45 | ZZREGION | Location | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ZREG | ZZREGION | Allow NULL? |
| 46 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | ZZSTATE | Allow NULL? |
| 47 | KTOSL | Transaction Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | KTOSL | Allow NULL? |
| 48 | BUDGET_PERIOD | FM: Budget Period | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FM_BUDGET_PERIOD | Allow NULL? |
| 49 | DISTR_PERC | Distribution Percentage in the Case of Multiple Acct Assgt | decimal | 5 | 2 | DEC | ((0)) | Yes | | BBP_VPROZ | |
| 50 | DIST_QUAN | Quantity in Order Unit | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BBP_MNG | |
| 51 | DIST_VALUE | Net Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | BBP_VALUE | |
| 52 | DIST_IND | Distribution Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | BBP_DIST_IND | Allow NULL? |
