| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | EC_CLIENT | Allow NULL? |
| 2 | REQNO | Requirement Coverage Request Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | EC_REQNO | Allow NULL? |
| 3 | REQLLINE | Administrative line number of requirement coverage request | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | REQLLINE | Allow NULL? |
| 4 | SERIAL_NO | Serial number for PReq account assignment segment | nvarchar | 2 | 0 | NUMC | (N'00') | No | | DZEBKN | Allow NULL? |
| 5 | REQSLINE | Temporary Item Number of Requirement Coverage Request | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | REQSLINE | Allow NULL? |
| 6 | PREQ_QTY | Purchase Requisition Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BAMNG | |
| 7 | DISTR_PERC | Distribution Percentage in Case of Multiple Account Assgt | decimal | 3 | 1 | DEC | ((0)) | Yes | | VPROZ | |
| 8 | G_L_ACCT | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAKNR | Allow NULL? |
| 9 | BUS_AREA | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 10 | COST_CTR | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 11 | PROJ_NO | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | PROJN | Allow NULL? |
| 12 | SD_DOC | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN | Allow NULL? |
| 13 | SDOC_ITEM | Sales Document Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | POSNR_VA | Allow NULL? |
| 14 | SCHED_LINE | Delivery Schedule Line Number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | ETENR | Allow NULL? |
| 15 | ASSET_NO | Main Asset Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | ANLN1 | Allow NULL? |
| 16 | SUB_NUMBER | Asset Subnumber | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ANLN2 | Allow NULL? |
| 17 | ORDER_NO | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 18 | GR_RCPT | Goods Recipient/Ship-To Party | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | WEMPF | Allow NULL? |
| 19 | UNLOAD_PT | Unloading Point | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | ABLAD | Allow NULL? |
| 20 | CO_AREA | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KOKRS | Allow NULL? |
| 21 | TO_COSTCTR | Posting to cost center? | char | 1 | 0 | CHAR | (N' ') | Yes | | XBKST | Allow NULL? |
| 22 | TO_ORDER | Post To Order | char | 1 | 0 | CHAR | (N' ') | Yes | | XBAUF | Allow NULL? |
| 23 | TO_PROJECT | Post to project | char | 1 | 0 | CHAR | (N' ') | Yes | | XBPRO | Allow NULL? |
| 24 | COST_OBJ | Cost Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | KSTRG | Allow NULL? |
| 25 | PROF_SEGM | Profitability Segment Number (CO-PA) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | RKEOBJNR | Allow NULL? |
| 26 | PROFIT_CTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 27 | WBS_ELEM | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PS_PSP_PNR | Allow NULL? |
| 28 | NETWORK | Network Number for Account Assignment | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | NPLNR | Allow NULL? |
| 29 | ROUTING_NO | Routing number of operations in the order | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | CO_AUFPL | Allow NULL? |
| 30 | RL_EST_KEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | IMKEY | Allow NULL? |
| 31 | COUNTER | Internal counter | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | CIM_COUNT | Allow NULL? |
| 32 | PART_ACCT | Partner account number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | JV_PART | Allow NULL? |
| 33 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | * | FIPOS | Allow NULL? |
| 34 | REC_IND | Recovery Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | JV_RECIND | Allow NULL? |
| 35 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FISTL | Allow NULL? |
| 36 | FUND | Fund | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BP_GEBER | Allow NULL? |
| 37 | FUNC_AREA | Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FKBER | Allow NULL? |
| 38 | REF_DATE | Reference Date for Settlement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DABRBEZ | Allow NULL? |
| 39 | CHANGE_ID | Change Type (U, I, S, D) | char | 1 | 0 | CHAR | (N' ') | Yes | | CDCHNGIND | Allow NULL? |
| 40 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 41 | PREQ_UNIT | Purchase Requisition Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | BAMEI | Allow NULL? |
| 42 | WBS_ELEM_E | Work Breakdown Structure Element (WBS Element) | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | WBS_ELEM | Allow NULL? |
| 43 | PROJ_EXT | Project definition | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | EPS_PSPID | Allow NULL? |
| 44 | ACTIVITY | Operation/Activity Number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | VORNR | Allow NULL? |
| 45 | LINE_TYPE | Line category | char | 1 | 0 | NUMC | (N'0') | Yes | | LITYPE | Allow NULL? |
| 46 | BBP_PROJECT | Ext.representation of work breakdown structure (WBS) element | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | PROJECT_BBP | Allow NULL? |
| 47 | ACC_CAT | Account Assignment Category in SRM | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | BBP_ACC_CAT | Allow NULL? |
| 48 | ACC_STR | Generic Account Assignment | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | BBP_ACC_GENERIC | Allow NULL? |
| 49 | ZZNFAL | | nvarchar | 10 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 50 | BUDGET_PERIOD | FM: Budget Period | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FM_BUDGET_PERIOD | Allow NULL? |
