GLE_FI_ITEM_MODF
ECS: Modified FI Line Items (Header/Item/Currency Data)
GLE_FI_ITEM_MODF is an SAP database table in S/4HANA. ECS: Modified FI Line Items (Header/Item/Currency Data). It contains 523 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_FinSGLModifiedItem | view_entity | from | BASIC | Financial Services GL Modified Item |
Fields (523)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | item_id | GLE_DTE_ECS_ITEM_ID | ECS Item ID | |||
| awtyp | AWTYP | Ref. procedure | ||||
| awref | AWREF | Reference Doc. | ||||
| aworg | AWORG | Refer. Org.Unit | ||||
| awsys | LOGSYSTEM | Logical System | ||||
| glvor | GLVOR | Bus.transaction | ||||
| process | PROCE | Trans. | ||||
| subset | ACC_SUBSET | Subset | ||||
| usnam | USNAM | User Name | ||||
| tcode | TCODE | Transaction Code | ||||
| cpudt | CPUDT | Entered On | ||||
| cputm | CPUTM | Entered at | ||||
| bktxt | BKTXT | Doc.Header Text | ||||
| docid | SAEOBJART | Document type | ||||
| barcd | SAEARDOID | Doc. ID | ||||
| knumv | KNUMV | Doc. Condition | ||||
| status_new | ACC_STATUS_NEW | New status | ||||
| status_old | ACC_STATUS_OLD | Previous status | ||||
| grpid | GRPID_BKPF | Session Name | ||||
| acc_principle | ACCOUNTING_PRINCIPLE | Accounting Principle | ||||
| rldnr | RLDNR | Ledger | ||||
| ldgrp | FAGL_LDGRP | Ledger Group | ||||
| nosplit | XFLAG | X Flag | ||||
| glprocess | GLPROCESS | Business Transaction | ||||
| glprocvar | GLPROCVARI | Transaction Variant | ||||
| exclude_flag | EXCLUDE_FLG | PPA Exclude | ||||
| dbblg | DBBLG | Rec.Entry Doc. | ||||
| kursx | GLE_FXR_DTE_RATEX28 | MD Exchange Rate | ||||
| kur2x | GLE_FXR_DTE_RATE2X28 | MD Exch. Rate 2 | ||||
| kur3x | GLE_FXR_DTE_RATE3X28 | MD Exch. Rate 3 | ||||
| posnr | POSNR_ACC | Position | ||||
| logvo | LOGVO | Log. Trans. | ||||
| istat | ISTAT_ACC | History | ||||
| kstat | KSTAZ | Statistical | ||||
| awref_rev | AWREF_REV | Reversal Ref. | ||||
| aworg_rev | AWORG_REV | Reversal Org. | ||||
| awref_reb | AWREF_REB | InR.Ref.no. | ||||
| aworg_reb | AWORG_REB | InR.org | ||||
| bukrs_orig | GLE_DTE_ECS_ORIG_BUKRS | Original Co. Code | ||||
| bukrs | BUKRS | Company Code | ||||
| belnr | BELNR_D | Document Number | ||||
| gjahr | GJAHR | Fiscal Year | ||||
| buzei | BUZEI | Item | ||||
| obzei | OBZEI | Original Item | ||||
| docln | DOCLN6 | G/L Line Item | ||||
| bldat | BLDAT | Document Date | ||||
| budat | BUDAT | Posting Date | ||||
| wwert | WWERT_D | Translatn Date | ||||
| valut | VALUT | Value date | ||||
| monat | MONAT | Period | ||||
| blart | BLART | Document Type | ||||
| xblnr | XBLNR1 | Reference | ||||
| xref1 | XREF1 | Reference Key 1 | ||||
| xref2 | XREF2 | Reference Key 2 | ||||
| xref3 | XREF3 | Reference Key 3 | ||||
| xref1_hd | XREF1_HD | Ref.key(head) 1 | ||||
| xref2_hd | XREF2_HD | Ref.key(head.)2 | ||||
| vorgn | VORGN | Transact. Type | ||||
| prvrg | PRVRG | ValidationTrans | ||||
| prvrg_sv | PRVRG_SV | StatMan trans. | ||||
| stbuk | STBUK | Tax CoCode | ||||
| xmwst | XMWST | Calculate Tax | ||||
| mwskz | MWSKZ | Tax Code | ||||
| ktosl | KTOSL | Transaction | ||||
| knumh | KNUMH | Cond.Record No. | ||||
| txjcd | TXJCD | Tax Jur. | ||||
| txdat | TXDAT | Tax Date | ||||
| kbetr | KBETR | Amount | ||||
| txjdp | TXJCD_DEEP | Jurisdict. Code | ||||
| txjlv | TXJCD_LEVEL | Jurisdiction level | ||||
| taxps | TAX_POSNR | Tax doc. item number | ||||
| old_doc_number | OLD_DOC_NUMBER | Temporary doc. numb. | ||||
| bupla | BUPLA | Business place | ||||
| secco | SECCO | Section Code | ||||
| xskrl | XSKRL | W/o CashDsc. | ||||
| zumsk | DZUMSK | Trg.Sp.G/L Ind. | ||||
| umskz | UMSKZ | Special G/L Ind | ||||
| bstat | BSTAT_D | Document Status | ||||
| bschl | BSCHL | Posting Key | ||||
| shkzg | SHKZG | Debit/Credit | ||||
| pswsl | PSWSL | G/L Currency | ||||
| pswbt | PSWBT | G/L Amount | ||||
| pycur | PYCUR | Paymnt Crcy | ||||
| pyamt | PYAMT | Pt Crcy Amt | ||||
| koart | KOART | Account type | ||||
| kunnr | KUNNR | Customer | ||||
| lifnr | LIFNR | Supplier | ||||
| saknr | SAKNR | G/L Account | ||||
| hkont | HKONT | G/L Acct | ||||
| altkt | ALTKT | Group Account | ||||
| filkd | FILKD | Branch | ||||
| xfilkd | XFILKD | Indicator: Break Off Branch/Head Office Relationship | ||||
| lokkt | LOKKT | Local Acct No. | ||||
| gvtyp | GVTYP | P&L state. acct | ||||
| gkoar | GKOAR | Offst.Acct Type | ||||
| gkont | GKONT | Offsetting Acct | ||||
| cacct | CACCT | Offsetting acct | ||||
| linetype | LINETYPE | Item Category | ||||
| xsplitmod | XSPLITMOD | Changed | ||||
| zterm | DZTERM | Pyt Terms | ||||
| zfbdt | DZFBDT | Baseline Date | ||||
| zbd1t | DZBD1T | Days 1 | ||||
| zbd2t | DZBD2T | Days 2 | ||||
| zbd3t | DZBD3T | Days Net | ||||
| zbd1p | DZBD1P | CD Percentage 1 | ||||
| zbd2p | DZBD2P | CD Percentage 2 | ||||
| zbfix | DZBFIX | Fixed | ||||
| uzawe | UZAWE | Pmnt Meth. Sup. | ||||
| zlsch | DZLSCH | Pymt Meth. | ||||
| empfb | EMPFB | Payer | ||||
| rstgr | RSTGR | Reason Code | ||||
| rebzg | REBZG | Invoice Ref. | ||||
| rebzj | REBZJ | Fiscal Year | ||||
| rebzz | REBZZ | Item | ||||
| rebzt | REBZT | Follow-On Doc. Type | ||||
| rebzg_check | REBZG_CHECK | REBZG Checks | ||||
| maber | MABER | Dunning Area | ||||
| mschl | MSCHL | Dunning key | ||||
| madat | MADAT | Last Dunned | ||||
| manst | MAHNS_D | Dunning Level | ||||
| mansp | MANSP | Dunn. Block | ||||
| zlspr | DZLSPR | Pmnt block | ||||
| adrnr | ADRNR | Address | ||||
| stceg | STCEG | VAT Reg. No. | ||||
| xegdr | XEGDR | EU Triang. Deal | ||||
| lzbkz | LZBKZ | SCB Ind. | ||||
| landl | LANDL | Supply C/R | ||||
| land1_acnt | LAND1_ACNT | Country/Region | ||||
| diekz | DIEKZ | Service Ind. | ||||
| samnr | SAMNR | Collect.Inv. | ||||
| abper | ABPER_RF | Settl.Period | ||||
| zuonr | DZUONR | Assignment | ||||
| dtws1 | DTAT16 | Instruct. Key 1 | ||||
| dtws2 | DTAT17 | Instruct. Key 2 | ||||
| dtws3 | DTAT18 | Instruct. key 3 | ||||
| dtws4 | DTAT19 | Instruct. key 4 | ||||
| sgtxt | SGTXT | Text | ||||
| gsber | GSBER | Business Area | ||||
| kostl | KOSTL | Cost Center | ||||
| lstar | LSTAR | Activity Type | ||||
| kokrs | KOKRS | CO Area | ||||
| pernr | PERNR_D | Personnel No. | ||||
| bpmng | BPMNG | Qty in OPUn | ||||
| bprme | BPRME | PO Price Unit | ||||
| aufnr | AUFNR | Order | ||||
| anln1 | ANLN1 | Asset | ||||
| anln2 | ANLN2 | Sub-number | ||||
| bzdat | BZDAT | Asset Val. Date | ||||
| anbwa | ANBWA | Ast Transaction Type | ||||
| webud | WEBUD | GR Posting Date | ||||
| rmvct | RMVCT | Transact. Type | ||||
| abukr | ABUKR | Cleared Against | ||||
| aibn1 | AIBN1 | Original Asset | ||||
| aibn2 | AIBN2 | Asset Sub-No. AuC | ||||
| matnr | MATNR | Material | ||||
| menge | MENGE_D | Quantity | ||||
| meins | MEINS | Base Unit | ||||
| werks | WERKS_D | Plant | ||||
| bwart | BWART | Movement Type | ||||
| pargb | PARGB | Trdg Part.BA | ||||
| gsber_gp | GSBER_GP | Bus.area:prtner | ||||
| buzid | BUZID | Line Item ID | ||||
| hoart | HOART | Origin object | ||||
| hrkft | HRKFT | Origin Group | ||||
| hkmat | HKMAT | Material origin | ||||
| imkey | IMKEY | Real Estate Key | ||||
| kstrg | KSTRG | Cost Object | ||||
| paobjnr | RKEOBJNR | Profit. segment | ||||
| prznr | CO_PRZNR | Business Process | ||||
| prctr | PRCTR | Profit Center | ||||
| pprctr | PPRCTR | Partner PC | ||||
| projk | PROJK_BI | Project | ||||
| ps_psp_pnr | PS_PSP_PNR | WBS Element | ||||
| mat_pspnr | MAT_PSPNR | WBS Element | ||||
| nplnr | NPLNR | Network | ||||
| aufpl | CO_AUFPL | Plan No.f.Oper. | ||||
| aplzl | CIM_COUNT | Counter | ||||
| aufps | CO_POSNR | Item Number | ||||
| fikrs | FIKRS | FM Area | ||||
| fipos | FIPOS | Commitment item | ||||
| fistl | FISTL | Funds Center | ||||
| geber | FM_FUND | Fund | ||||
| kblnr | KBLNR | Earmarked Funds | ||||
| kblpos | KBLPOS | Document Item | ||||
| kbltyp_ext | KBL_AWTYP | EF Refer.Type | ||||
| kblref_ext | KBL_AWREF | EF Refer.No. | ||||
| kblorg_ext | KBL_AWORG | EF Refer.Org. | ||||
| kblpos_ext | KBL_AWPOS | EF Refer.Item | ||||
| erlkz | KBLERLKZ | Item Completed | ||||
| lotkz | LOTKZ | Lot No. | ||||
| sttax | STTAX | Statistical Tax | ||||
| sthtx | STHTX | Statistical Tax | ||||
| vbeln | VBELN | SD Document | ||||
| kdauf | KDAUF | Sales Order | ||||
| kdpos | KDPOS | Sales Ord. Item | ||||
| mat_kdauf | MAT_KDAUF | Sales order | ||||
| mat_kdpos | MAT_KDPOS | Sales ord. item | ||||
| kzvbr | KZVBR | Consumption | ||||
| kzbws | KZBWS | Valuation | ||||
| sobkz | SOBKZ | Special Stock | ||||
| zinkz | DZINKZ | Interest Block | ||||
| vbund | RASSC | Trading Partner | ||||
| bwkey | BWKEY | Valuation Area | ||||
| bwtar | BWTAR_D | Valuation Type | ||||
| fs_product_group | FFS_PRODUCT_GROUP | Product Group (FS) | ||||
| branch_id | FFS_BRANCH_ID | Branch (FS) | ||||
| datasource_id | FFS_DATASOURCE_ID | Data Source | ||||
| kdgrp | KDGRP | Customer Group | ||||
| land1 | COBL_LAND1_GP | Country/Region | ||||
| brsch | BRSCH | Industry | ||||
| vname | JV_NAME | Joint venture | ||||
| egrup | JV_EGROUP | Equity group | ||||
| btype | JV_BILIND | Billing ind. | ||||
| ebeln | EBELN | Purchasing Doc. | ||||
| ebelp | EBELP | Item | ||||
| zekkn | DZEKKN | Account Assgmt No. | ||||
| vprsv | VPRSV | Price control | ||||
| recid | JV_RECIND | Recovery Ind. | ||||
| recid_man | JV_RECID_M | Rec.Ind. Manual | ||||
| etype | JV_ETYPE | Equity Type | ||||
| vptnr | JV_PART | Partner | ||||
| xbilk | XBILK | Balance sheet acct | ||||
| xumsw | XUMSW | Sales-Related | ||||
| taxit | TAXIT | Tax Item | ||||
| xauto | XAUTO | Auto. created | ||||
| fcval | FCVAL | Valuated | ||||
| beknz | BEKNZ | Dr/Cr indicator | ||||
| kzbew | KZBEW | Movement ind. | ||||
| pstyp | PSTYP | Item Category | ||||
| bustw | BUSTW | Value String | ||||
| tbtkz | TBTKZ | Subseq. Dr/Cr | ||||
| xumbw | XUMBW | Revaluation | ||||
| scope | SCOPE_CV | Object Class | ||||
| autyp | AUFTYP | Order category | ||||
| xmfrw | XMFRW | Quantity update | ||||
| esrnr | ESRNR | ISR Number | ||||
| esrpz | ESRPZ | Check digit | ||||
| esrre | ESRRE | ISR/QR Ref. | ||||
| qsskz | QSSKZ | WTax Code | ||||
| bklas | BKLAS | Valuation Class | ||||
| bwmod | BWMOD | Val.Grpg Code | ||||
| mtart | MTART | Material Type | ||||
| eprctr | EPRCTR | Elimination PrCtr | ||||
| posnr_sd | POSNR | Item | ||||
| kschl | KSCHA | Condition Type | ||||
| stunr | STUNR | Step Number | ||||
| zaehk | DZAEHK | Counter | ||||
| fkart | FKART | Billing Type | ||||
| vtweg | VTWEG | Distr. Channel | ||||
| kunag | KUNAG | Sold-to Party | ||||
| spart | SPART | Division | ||||
| vkorg | VKORG | Sales Org. | ||||
| vkbur | VKBUR | Sales Office | ||||
| vkgrp | VKGRP | Sales Group | ||||
| fkdat | FKDAT | Billing Date | ||||
| fktyp | FKTYP | BillingCategory | ||||
| fbuda | FBUDA | Serv. Rend. Dte | ||||
| aubel | VBELN_VA | Sales Document | ||||
| aupos | POSNR_VA | Item | ||||
| fkimg | FKIMG | Invoiced Qty | ||||
| vrkme | VRKME | Sales Unit | ||||
| fklmg | FKLMG | Bill.Qty in SKU | ||||
| kappl | KAPPL | Application | ||||
| kntyp | KNTYP | Condit.Category | ||||
| kursk | KURSK | Exchange Rate | ||||
| kzzuab | SHKZG | Debit/Credit | ||||
| kinak | KINAK | Inactive | ||||
| ntgew | NTGEW_15 | Net Weight | ||||
| brgew | BRGEW_15 | Gross Weight | ||||
| gewei | GEWEI | Unit of Weight | ||||
| volum | VOLUM_15 | Volume | ||||
| voleh | VOLEH | Volume Unit | ||||
| vbtyp | VBTYPL | Document Cat. | ||||
| vbel2 | VBELN_VA | Sales Document | ||||
| posn2 | POSNR_VA | Item | ||||
| fdlev | FDLEV | Planning Level | ||||
| fdtag | FDTAG | Planning Date | ||||
| fdgrp | FDGRP | Planning group | ||||
| fdwbt | FDWBT | Planned Amount | ||||
| kzuml | KZUML | St.tfr./tfr.pst | ||||
| xpkon | XPKON | Check acct.ass. | ||||
| koaid | KOAID | Condition Class | ||||
| xakon | XAKON | Auto acct assgn | ||||
| fkber | FKBER | Functional Area | ||||
| afabe | AFABE_D | Deprec. area | ||||
| versa | VERSN_ABGR | RA Version | ||||
| wip_cat | PCA_WIP_CAT | WIP category | ||||
| xlifo | XLIFO | LIFO/FIFO-Rel. | ||||
| erfmg | ERFMG | Quantity in UnE | ||||
| erfme | ERFME | Unit of Entry | ||||
| dabrz | DABRBEZ | Reference date | ||||
| augdt | AUGDT | Clearing | ||||
| augcp | AUGCP | ClearingEntDate | ||||
| augbl | AUGBL | Clrng doc. | ||||
| agzei | AGZEI | Clearing Item | ||||
| xnegp | XNEGP | Negative Postg | ||||
| stgrd | STGRD | Reversal Reason | ||||
| ccins | CCINS | Card type | ||||
| ccnum | CCNUM | Card number | ||||
| ccfol | CCFOL | Suffix | ||||
| datab | DATAB_CC | Valid from | ||||
| datbi | DATBI_CC | Exp.date | ||||
| ccname | CCNAME | Cardholder | ||||
| csour | CSOUR | Entry mode | ||||
| autwr | AUTWR | Authorized Amt | ||||
| ccwae | WAERS | Currency | ||||
| settl | SETTL | Settled | ||||
| aunum | AUNUM | Auth. Number | ||||
| autra | AUTRA | Auth. Ref. Code | ||||
| audat | AUDAT_CC | Auth. Date | ||||
| autim | AUTIM | Auth. Time | ||||
| merch | MERCH | Merchant ID | ||||
| locid | LOCID_CC | PointOfReceipt | ||||
| trmid | TRMID | Terminal | ||||
| ccbtc | CCBTC | Settlement | ||||
| cctyp | CCTYP | Card Category | ||||
| ccard_guid | CCARDEC_GUID | Reference to Encrypted Payment Card Data | ||||
| payment_amount | WRBTR | Amount | ||||
| dp_token | DP_TOKEN | Token | ||||
| dp_psp | DP_PAYMENT_SERVICE_PROVIDER | Paymnt Serv. Provid. | ||||
| dp_payid | DP_PAYID | Payment ID | ||||
| dp_psp_transid | DP_PSP_TRANS_ID | PSP Transaction ID | ||||
| dp_trans_id | DP_TRANSID | Transaction/Payt ID | ||||
| dp_merchant_alias | DP_MERCHANT_ALIAS | Merchant Alias | ||||
| dp_auth_rel_id | FAR_DP_AUTH_REL_ID | Auth. Rel. ID | ||||
| dp_fraud_risk | DP_FRAUD_RISK_CODE | Fraud Risk Code | ||||
| dp_charge_trans_id | DP_TRANSID | Transaction/Payt ID | ||||
| kkber | KKBER | Cred.Contr.Area | ||||
| shkzg_va | SHKZG_VA | Returns | ||||
| sdstr | SDSTR | 3rd-party order | ||||
| posar | POSAR | Item Type | ||||
| anlo1 | ANLN1 | Asset | ||||
| anlo2 | ANLN2 | Sub-number | ||||
| condi | JV_CONDCOD | CondKey | ||||
| bemot | BEMOT | AcctIndicator | ||||
| absbt | ABSBT | Hedged Amount | ||||
| kidno | KIDNO | Payment Ref. | ||||
| brnch | J_1ABRNCH | Branch number | ||||
| numpg | J_1ANOPG | Number of Pages | ||||
| adisc | J_1ADISC | discount document | ||||
| gricd | J_1AGICD_D | Activity Code | ||||
| grirg | REGIO | Region | ||||
| gityp | J_1ADTYP_D | Distr. Type | ||||
| wt_key | WT_KEY | Grouping Key | ||||
| xbgbb | XBGBB | Ind.pst.offsEnt | ||||
| vertt | RANTYP | Contract Type | ||||
| vertn | RANL | Contract Number | ||||
| vbewa | SBEWART | Flow Type | ||||
| bvtyp | BVTYP | Part.bank type | ||||
| hbkid | HBKID | House Bank | ||||
| hktid | HKTID | Account ID | ||||
| nebtr | NEBTR | Payment Amt | ||||
| mwsk1 | MWSKX | Tax Code | ||||
| dmbt1 | DMBTX | Amount | ||||
| mwsk2 | MWSKX | Tax Code | ||||
| dmbt2 | DMBTX | Amount | ||||
| mwsk3 | MWSKX | Tax Code | ||||
| dmbt3 | DMBTX | Amount | ||||
| abwze | VVABWZE | Alt.payee | ||||
| bvtypabw | VVBVTYPABW | BankTyp alt.pyr | ||||
| bapi_param | FIELDNAME | Field Name | ||||
| bapi_tabix | SYTABIX | Table Row | ||||
| ccact | CCACT | G/L Account | ||||
| co_kakst | CO_KAKST | AAT: Cost Ctr | ||||
| co_kaauf | CO_KAAUF | AAType: Order | ||||
| co_kapro | CO_KAPRO | Proj.Acct Assgn | ||||
| co_kaktr | CO_KAKTR | AAT: Cost Obj. | ||||
| co_kanpl | CO_KANPL | AAType: Network | ||||
| co_kaimo | CO_KAIMO | AAT: RealEstObj | ||||
| co_kakda | CO_KAKDA | AAT: Sales Ord. | ||||
| co_kaerg | CO_KAERG | BusSeg.AcctAssn | ||||
| co_kaabs | CO_KAABS | AAT: Rec. Obj. | ||||
| co_kaprz | CO_KAPRZ | AAT: Bus. Proc. | ||||
| co_kasvd | CO_KASVD | AAT: Srv. Doc. | ||||
| co_kasat | CO_KASAT | AAType Not Used | ||||
| dummy_incl_eew_cobl | CFD_DUMMY | Dummy | ||||
| bvaltnr | CKML_ALPROCNR | PrcrmntAlt/Proc | ||||
| kaln1 | CK_KALNR1 | ProdCostEst.No. | ||||
| aufnr_org | CK_AUFNR_ORG | Orig. Order No. | ||||
| cession_kz | CESSION_KZ | AR Pledging Ind | ||||
| mlmaa | CK_ML_MAAC | ML Act. | ||||
| mlast | CK_ML_ABST | Price Determ. | ||||
| zeile | CK_ZEILE | Item | ||||
| urzeile | CK_URZEILE | Item | ||||
| mlbwg | CKML_MLBWG | Mvmt Type Group | ||||
| mlnprd | CK_MLNPRD | No Brkdwn Pr.Diff. | ||||
| lsqty | CK_LSQTY | Last Amt Settld | ||||
| prqty | CK_PRQTY | PrDifQty InvVer | ||||
| ekorg | EKORG | Purchasing Org. | ||||
| vkwrt | VKWRT | SalVal inc. VAT | ||||
| ummat | UMMAT | Receiving Mat. | ||||
| umwrk | UMWRK | Receiving plant | ||||
| knttp | KNTTP | Acct Assgmt Cat | ||||
| umsok | UMSOK | Sp.ind.st.tfr. | ||||
| umwer | WERTU | Value updating | ||||
| rrrel | RR_RELTYP | Rev. Recognition | ||||
| mat_lifnr | MAT_LIFNR | Vendor | ||||
| xobew | XOBEW | Vendor stk val. | ||||
| tpknz | TPKNZ | TP indic. | ||||
| xinve | XINVE | Invest.ID | ||||
| kruek | KRUEK | Accruals | ||||
| awtyp_rev | AWTYP | Ref. procedure | ||||
| awtyp_reb | AWTYP | Ref. procedure | ||||
| vornr | VORNR | Activity | ||||
| pgeber | FM_PFUND | Partner Fund | ||||
| penrc | PENRC | Reason f. Delay | ||||
| grant_nbr | GM_GRANT_NBR | Grant | ||||
| pgrant_nbr | GM_GRANT_PARTNER | Partner Grant | ||||
| gmvkz | FM_GMVKZ | Execution | ||||
| srtype | FM_SRTYPE | Addit.Receivab. | ||||
| reindat | REINDAT | Inv. Recpt Date | ||||
| idxsp | J_1AINDXSP | Inflation Index | ||||
| intreno | VVINTRENO | RE code | ||||
| glupm | GLUPM | Update | ||||
| measure | FM_MEASURE | Funded Program | ||||
| stblg | STBLG | Reversed With | ||||
| hzuon | HZUON | Sp.G/L Assgt | ||||
| segment | FB_SEGMENT | Segment | ||||
| psegment | FB_PSEGMENT | Partner Segment | ||||
| pfkber | SFKBER | Partner FArea | ||||
| pkostl | SKOST | Sender Cost Ctr | ||||
| kstar | KSTAR | Cost Element | ||||
| flg_nobud | FM_NBUD | N. Budget-Rel. | ||||
| ppa_ex_ind | EXCLUDE_FLG | PPA Exclude | ||||
| case_guid_core | SCMG_CASE_GUID | Case Key | ||||
| longnum | /SAPPSPRO/LONGNUM | Smart Number | ||||
| stodt | STODT | Reversal Date | ||||
| bdgt_subtype | BP_SUBVO | Budget Subtype | ||||
| cohort | FM_COHORT | Year Cohort | ||||
| publaw | FM_PUBLAW | Public Law | ||||
| legis | FM_LEGIS | Legislation | ||||
| fmcmmtstr | FMCMMTSTR | Commitment string | ||||
| prodper | JV_PRODPER | Prod.Month | ||||
| tcobjnr | J_OBJNR | Object number | ||||
| dateofservice | VVBEACTDATE | Date of Service | ||||
| notaxcorr | VVREITNOTAXCORR | Do Not Correct | ||||
| diffoptrate | POPTSATZ | Option Rate | ||||
| hasdiffoptrate | VVREITUSEDIFFOPTRATE | Diff. Opt. Rate | ||||
| logsystem_sender | LOGSYSTEM_SENDER | Sender Log Sys. | ||||
| bukrs_sender | BUKRS_SENDER | Sender CoCode | ||||
| belnr_sender | BELNR_SENDER | Sender Doc.No. | ||||
| gjahr_sender | GJAHR_SENDER | Sender FiscalYr | ||||
| buzei_sender | BUZEI_SENDER | Sender Item | ||||
| acdoc_eew_dummy | CFD_DUMMY | Dummy | ||||
| txdat_from | FOT_TXDAT_FROM | Tax Rate Valid-From | ||||
| tax_country | FOT_TAX_COUNTRY | Tax Ctry/Reg. | ||||
| lwste | LWSTE_BSET | Tax Rept. Crcy | ||||
| lwbas | LWBAS_BSET | Base Amount | ||||
| curtp | CURTP | Crcy type/val. | ||||
| waers | WAERS | Currency | ||||
| wrbtr | ACBTR | Amount | ||||
| fwbas | ACSBS | Base amount | ||||
| skfbt | ACFBT | CD Base | ||||
| wskto | ACSKT | CD Amount | ||||
| qsshb | ACQBS | W/Tax Base | ||||
| qsfbt | ACQBT | W/Tax-Exempt | ||||
| bualt | BUALT | Amount | ||||
| kwert | KWERT | Condition Value | ||||
| navbt | NAVFW | Non-Deductible | ||||
| wmwst | WMWST | Tax Amount | ||||
| currtyp | CURRTYP | Currency Type | ||||
| valutyp | VALUTYP | Valuation View | ||||
| gbetr | GBETR | Hedged | ||||
| kursr | KURSR | Hedged Ex.Rt | ||||
| wrbtr_fix | ACBTR_FIX | Amount | ||||
| wrbtr_avg | GLE_DTE_ADB_AVERAGE_AMOUNT | Average Amount | ||||
| curt1 | CURT1 | LC1 curr.type | ||||
| hwaer | HWAER | Local Currency | ||||
| dmbtr | DMBTR | Amount in LC | ||||
| kursf | KURSF | Exchange rate | ||||
| hwste | HWSTE | LC Tax | ||||
| hwbas | HWBAS | LC Base | ||||
| txkrs | TXKRS_BKPF | Rate for Taxes | ||||
| sknto | SKNTO | Discount Amt | ||||
| kzbtr | KZBTR_FI | Orig.Reduction | ||||
| mwsts | MWSTS | LC Tax | ||||
| dmbtr_avg | GLE_DTE_ADB_AVERAGE_AMOUNT | Average Amount | ||||
| curt2 | CURT2 | LC2 Crcy Type | ||||
| hwae2 | HWAE2 | Local curr. 2 | ||||
| dmbe2 | DMBE2 | LC2 Amount | ||||
| kurs2 | KURS2 | Exchange Rate 2 | ||||
| h2ste | H2STE | LC 2 Tax | ||||
| sknt2 | SKNT2 | CD Amt LC2 | ||||
| mwst2 | MWST2 | LC2 Tax | ||||
| txbh2 | TXBH2 | LC2 Tax Base Amount | ||||
| basw2 | CURSR | Source Currency | ||||
| umrd2 | UMRD2 | Trans. Date | ||||
| kuty2 | KURST | Exch. Rate Type | ||||
| dmbe2_avg | GLE_DTE_ADB_AVERAGE_AMOUNT | Average Amount | ||||
| curt3 | CURT3 | LC3 Crcy Type | ||||
| hwae3 | HWAE3 | Local curr. 3 | ||||
| dmbe3 | DMBE3 | LC3 Amount | ||||
| kurs3 | KURS3 | Exchange Rate 3 | ||||
| h3ste | H3STE | LC 3 Tax | ||||
| sknt3 | SKNT3 | CD Amt LC3 | ||||
| mwst3 | MWST3 | LC3 Tax | ||||
| txbh3 | TXBH3 | LC3 Tax Base Amount | ||||
| basw3 | CURSR | Source Currency | ||||
| umrd3 | UMRD3 | Trans. Date | ||||
| kuty3 | KURST | Exch. Rate Type | ||||
| dmbe3_avg | GLE_DTE_ADB_AVERAGE_AMOUNT | Average Amount | ||||
| curt4 | GLE_FINS_CURTYPE | Currency type | ||||
| hwae4 | GLE_FINS_HWAE4 | Local curr. 4 | ||||
| dmbe4 | GLE_FINS_DMBE4 | LC4 amount | ||||
| curt5 | GLE_FINS_CURTYPE | Currency type | ||||
| hwae5 | GLE_FINS_HWAE5 | Local curr. 4 | ||||
| dmbe5 | GLE_FINS_DMBE5 | LC5 amount | ||||
| curt6 | GLE_FINS_CURTYPE | Currency type | ||||
| hwae6 | GLE_FINS_HWAE6 | Local curr. 6 | ||||
| dmbe6 | GLE_FINS_DMBE6 | LC6 amount | ||||
| curt7 | GLE_FINS_CURTYPE | Currency type | ||||
| hwae7 | GLE_FINS_HWAE7 | Local curr. 7 | ||||
| dmbe7 | GLE_FINS_DMBE7 | LC7 amount | ||||
| curt8 | GLE_FINS_CURTYPE | Currency type | ||||
| hwae8 | GLE_FINS_HWAE8 | Local curr. 8 | ||||
| dmbe8 | GLE_FINS_DMBE8 | LC8 amount | ||||
| curt9 | GLE_FINS_CURTYPE | Currency type | ||||
| hwae9 | GLE_FINS_HWAE9 | Local curr. 9 | ||||
| dmbe9 | GLE_FINS_DMBE9 | LC9 amount | ||||
| curt10 | GLE_FINS_CURTYPE | Currency type | ||||
| hwae10 | GLE_FINS_HWAE10 | Local curr. 10 | ||||
| dmbe10 | GLE_FINS_DMBE10 | LC10 amount |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- ECS: Modified FI Line Items (Header/Item/Currency Data)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GLE_FI_ITEM_MODF (
MANDT, -- Client [MANDT]
ITEM_ID, -- ECS Item ID [GLE_DTE_ECS_ITEM_ID]
AWTYP, -- Ref. procedure [AWTYP]
AWREF, -- Reference Doc. [AWREF]
AWORG, -- Refer. Org.Unit [AWORG]
AWSYS, -- Logical System [LOGSYSTEM]
GLVOR, -- Bus.transaction [GLVOR]
PROCESS, -- Trans. [PROCE]
SUBSET, -- Subset [ACC_SUBSET]
USNAM, -- User Name [USNAM]
TCODE, -- Transaction Code [TCODE]
CPUDT, -- Entered On [CPUDT]
CPUTM, -- Entered at [CPUTM]
BKTXT, -- Doc.Header Text [BKTXT]
DOCID, -- Document type [SAEOBJART]
BARCD, -- Doc. ID [SAEARDOID]
KNUMV, -- Doc. Condition [KNUMV]
STATUS_NEW, -- New status [ACC_STATUS_NEW]
STATUS_OLD, -- Previous status [ACC_STATUS_OLD]
GRPID, -- Session Name [GRPID_BKPF]
ACC_PRINCIPLE, -- Accounting Principle [ACCOUNTING_PRINCIPLE]
RLDNR, -- Ledger [RLDNR]
LDGRP, -- Ledger Group [FAGL_LDGRP]
NOSPLIT, -- X Flag [XFLAG]
GLPROCESS, -- Business Transaction [GLPROCESS]
GLPROCVAR, -- Transaction Variant [GLPROCVARI]
EXCLUDE_FLAG, -- PPA Exclude [EXCLUDE_FLG]
DBBLG, -- Rec.Entry Doc. [DBBLG]
KURSX, -- MD Exchange Rate [GLE_FXR_DTE_RATEX28]
KUR2X, -- MD Exch. Rate 2 [GLE_FXR_DTE_RATE2X28]
KUR3X, -- MD Exch. Rate 3 [GLE_FXR_DTE_RATE3X28]
POSNR, -- Position [POSNR_ACC]
LOGVO, -- Log. Trans. [LOGVO]
ISTAT, -- History [ISTAT_ACC]
KSTAT, -- Statistical [KSTAZ]
AWREF_REV, -- Reversal Ref. [AWREF_REV]
AWORG_REV, -- Reversal Org. [AWORG_REV]
AWREF_REB, -- InR.Ref.no. [AWREF_REB]
AWORG_REB, -- InR.org [AWORG_REB]
BUKRS_ORIG, -- Original Co. Code [GLE_DTE_ECS_ORIG_BUKRS]
BUKRS, -- Company Code [BUKRS]
BELNR, -- Document Number [BELNR_D]
GJAHR, -- Fiscal Year [GJAHR]
BUZEI, -- Item [BUZEI]
OBZEI, -- Original Item [OBZEI]
DOCLN, -- G/L Line Item [DOCLN6]
BLDAT, -- Document Date [BLDAT]
BUDAT, -- Posting Date [BUDAT]
WWERT, -- Translatn Date [WWERT_D]
VALUT, -- Value date [VALUT]
MONAT, -- Period [MONAT]
BLART, -- Document Type [BLART]
XBLNR, -- Reference [XBLNR1]
XREF1, -- Reference Key 1 [XREF1]
XREF2, -- Reference Key 2 [XREF2]
XREF3, -- Reference Key 3 [XREF3]
XREF1_HD, -- Ref.key(head) 1 [XREF1_HD]
XREF2_HD, -- Ref.key(head.)2 [XREF2_HD]
VORGN, -- Transact. Type [VORGN]
PRVRG, -- ValidationTrans [PRVRG]
PRVRG_SV, -- StatMan trans. [PRVRG_SV]
STBUK, -- Tax CoCode [STBUK]
XMWST, -- Calculate Tax [XMWST]
MWSKZ, -- Tax Code [MWSKZ]
KTOSL, -- Transaction [KTOSL]
KNUMH, -- Cond.Record No. [KNUMH]
TXJCD, -- Tax Jur. [TXJCD]
TXDAT, -- Tax Date [TXDAT]
KBETR, -- Amount [KBETR]
TXJDP, -- Jurisdict. Code [TXJCD_DEEP]
TXJLV, -- Jurisdiction level [TXJCD_LEVEL]
TAXPS, -- Tax doc. item number [TAX_POSNR]
OLD_DOC_NUMBER, -- Temporary doc. numb. [OLD_DOC_NUMBER]
BUPLA, -- Business place [BUPLA]
SECCO, -- Section Code [SECCO]
XSKRL, -- W/o CashDsc. [XSKRL]
ZUMSK, -- Trg.Sp.G/L Ind. [DZUMSK]
UMSKZ, -- Special G/L Ind [UMSKZ]
BSTAT, -- Document Status [BSTAT_D]
BSCHL, -- Posting Key [BSCHL]
SHKZG, -- Debit/Credit [SHKZG]
PSWSL, -- G/L Currency [PSWSL]
PSWBT, -- G/L Amount [PSWBT]
PYCUR, -- Paymnt Crcy [PYCUR]
PYAMT, -- Pt Crcy Amt [PYAMT]
KOART, -- Account type [KOART]
KUNNR, -- Customer [KUNNR]
LIFNR, -- Supplier [LIFNR]
SAKNR, -- G/L Account [SAKNR]
HKONT, -- G/L Acct [HKONT]
ALTKT, -- Group Account [ALTKT]
FILKD, -- Branch [FILKD]
XFILKD, -- Indicator: Break Off Branch/Head Office Relationship [XFILKD]
LOKKT, -- Local Acct No. [LOKKT]
GVTYP, -- P&L state. acct [GVTYP]
GKOAR, -- Offst.Acct Type [GKOAR]
GKONT, -- Offsetting Acct [GKONT]
CACCT, -- Offsetting acct [CACCT]
LINETYPE, -- Item Category [LINETYPE]
XSPLITMOD, -- Changed [XSPLITMOD]
ZTERM, -- Pyt Terms [DZTERM]
ZFBDT, -- Baseline Date [DZFBDT]
ZBD1T, -- Days 1 [DZBD1T]
ZBD2T, -- Days 2 [DZBD2T]
ZBD3T, -- Days Net [DZBD3T]
ZBD1P, -- CD Percentage 1 [DZBD1P]
ZBD2P, -- CD Percentage 2 [DZBD2P]
ZBFIX, -- Fixed [DZBFIX]
UZAWE, -- Pmnt Meth. Sup. [UZAWE]
ZLSCH, -- Pymt Meth. [DZLSCH]
EMPFB, -- Payer [EMPFB]
RSTGR, -- Reason Code [RSTGR]
REBZG, -- Invoice Ref. [REBZG]
REBZJ, -- Fiscal Year [REBZJ]
REBZZ, -- Item [REBZZ]
REBZT, -- Follow-On Doc. Type [REBZT]
REBZG_CHECK, -- REBZG Checks [REBZG_CHECK]
MABER, -- Dunning Area [MABER]
MSCHL, -- Dunning key [MSCHL]
MADAT, -- Last Dunned [MADAT]
MANST, -- Dunning Level [MAHNS_D]
MANSP, -- Dunn. Block [MANSP]
ZLSPR, -- Pmnt block [DZLSPR]
ADRNR, -- Address [ADRNR]
STCEG, -- VAT Reg. No. [STCEG]
XEGDR, -- EU Triang. Deal [XEGDR]
LZBKZ, -- SCB Ind. [LZBKZ]
LANDL, -- Supply C/R [LANDL]
LAND1_ACNT, -- Country/Region [LAND1_ACNT]
DIEKZ, -- Service Ind. [DIEKZ]
SAMNR, -- Collect.Inv. [SAMNR]
ABPER, -- Settl.Period [ABPER_RF]
ZUONR, -- Assignment [DZUONR]
DTWS1, -- Instruct. Key 1 [DTAT16]
DTWS2, -- Instruct. Key 2 [DTAT17]
DTWS3, -- Instruct. key 3 [DTAT18]
DTWS4, -- Instruct. key 4 [DTAT19]
SGTXT, -- Text [SGTXT]
GSBER, -- Business Area [GSBER]
KOSTL, -- Cost Center [KOSTL]
LSTAR, -- Activity Type [LSTAR]
KOKRS, -- CO Area [KOKRS]
PERNR, -- Personnel No. [PERNR_D]
BPMNG, -- Qty in OPUn [BPMNG]
BPRME, -- PO Price Unit [BPRME]
AUFNR, -- Order [AUFNR]
ANLN1, -- Asset [ANLN1]
ANLN2, -- Sub-number [ANLN2]
BZDAT, -- Asset Val. Date [BZDAT]
ANBWA, -- Ast Transaction Type [ANBWA]
WEBUD, -- GR Posting Date [WEBUD]
RMVCT, -- Transact. Type [RMVCT]
ABUKR, -- Cleared Against [ABUKR]
AIBN1, -- Original Asset [AIBN1]
AIBN2, -- Asset Sub-No. AuC [AIBN2]
MATNR, -- Material [MATNR]
MENGE, -- Quantity [MENGE_D]
MEINS, -- Base Unit [MEINS]
WERKS, -- Plant [WERKS_D]
BWART, -- Movement Type [BWART]
PARGB, -- Trdg Part.BA [PARGB]
GSBER_GP, -- Bus.area:prtner [GSBER_GP]
BUZID, -- Line Item ID [BUZID]
HOART, -- Origin object [HOART]
HRKFT, -- Origin Group [HRKFT]
HKMAT, -- Material origin [HKMAT]
IMKEY, -- Real Estate Key [IMKEY]
KSTRG, -- Cost Object [KSTRG]
PAOBJNR, -- Profit. segment [RKEOBJNR]
PRZNR, -- Business Process [CO_PRZNR]
PRCTR, -- Profit Center [PRCTR]
PPRCTR, -- Partner PC [PPRCTR]
PROJK, -- Project [PROJK_BI]
PS_PSP_PNR, -- WBS Element [PS_PSP_PNR]
MAT_PSPNR, -- WBS Element [MAT_PSPNR]
NPLNR, -- Network [NPLNR]
AUFPL, -- Plan No.f.Oper. [CO_AUFPL]
APLZL, -- Counter [CIM_COUNT]
AUFPS, -- Item Number [CO_POSNR]
FIKRS, -- FM Area [FIKRS]
FIPOS, -- Commitment item [FIPOS]
FISTL, -- Funds Center [FISTL]
GEBER, -- Fund [FM_FUND]
KBLNR, -- Earmarked Funds [KBLNR]
KBLPOS, -- Document Item [KBLPOS]
KBLTYP_EXT, -- EF Refer.Type [KBL_AWTYP]
KBLREF_EXT, -- EF Refer.No. [KBL_AWREF]
KBLORG_EXT, -- EF Refer.Org. [KBL_AWORG]
KBLPOS_EXT, -- EF Refer.Item [KBL_AWPOS]
ERLKZ, -- Item Completed [KBLERLKZ]
LOTKZ, -- Lot No. [LOTKZ]
STTAX, -- Statistical Tax [STTAX]
STHTX, -- Statistical Tax [STHTX]
VBELN, -- SD Document [VBELN]
KDAUF, -- Sales Order [KDAUF]
KDPOS, -- Sales Ord. Item [KDPOS]
MAT_KDAUF, -- Sales order [MAT_KDAUF]
MAT_KDPOS, -- Sales ord. item [MAT_KDPOS]
KZVBR, -- Consumption [KZVBR]
KZBWS, -- Valuation [KZBWS]
SOBKZ, -- Special Stock [SOBKZ]
ZINKZ, -- Interest Block [DZINKZ]
VBUND, -- Trading Partner [RASSC]
BWKEY, -- Valuation Area [BWKEY]
BWTAR, -- Valuation Type [BWTAR_D]
FS_PRODUCT_GROUP, -- Product Group (FS) [FFS_PRODUCT_GROUP]
BRANCH_ID, -- Branch (FS) [FFS_BRANCH_ID]
DATASOURCE_ID, -- Data Source [FFS_DATASOURCE_ID]
KDGRP, -- Customer Group [KDGRP]
LAND1, -- Country/Region [COBL_LAND1_GP]
BRSCH, -- Industry [BRSCH]
VNAME, -- Joint venture [JV_NAME]
EGRUP, -- Equity group [JV_EGROUP]
BTYPE, -- Billing ind. [JV_BILIND]
EBELN, -- Purchasing Doc. [EBELN]
EBELP, -- Item [EBELP]
ZEKKN, -- Account Assgmt No. [DZEKKN]
VPRSV, -- Price control [VPRSV]
RECID, -- Recovery Ind. [JV_RECIND]
RECID_MAN, -- Rec.Ind. Manual [JV_RECID_M]
ETYPE, -- Equity Type [JV_ETYPE]
VPTNR, -- Partner [JV_PART]
XBILK, -- Balance sheet acct [XBILK]
XUMSW, -- Sales-Related [XUMSW]
TAXIT, -- Tax Item [TAXIT]
XAUTO, -- Auto. created [XAUTO]
FCVAL, -- Valuated [FCVAL]
BEKNZ, -- Dr/Cr indicator [BEKNZ]
KZBEW, -- Movement ind. [KZBEW]
PSTYP, -- Item Category [PSTYP]
BUSTW, -- Value String [BUSTW]
TBTKZ, -- Subseq. Dr/Cr [TBTKZ]
XUMBW, -- Revaluation [XUMBW]
SCOPE, -- Object Class [SCOPE_CV]
AUTYP, -- Order category [AUFTYP]
XMFRW, -- Quantity update [XMFRW]
ESRNR, -- ISR Number [ESRNR]
ESRPZ, -- Check digit [ESRPZ]
ESRRE, -- ISR/QR Ref. [ESRRE]
QSSKZ, -- WTax Code [QSSKZ]
BKLAS, -- Valuation Class [BKLAS]
BWMOD, -- Val.Grpg Code [BWMOD]
MTART, -- Material Type [MTART]
EPRCTR, -- Elimination PrCtr [EPRCTR]
POSNR_SD, -- Item [POSNR]
KSCHL, -- Condition Type [KSCHA]
STUNR, -- Step Number [STUNR]
ZAEHK, -- Counter [DZAEHK]
FKART, -- Billing Type [FKART]
VTWEG, -- Distr. Channel [VTWEG]
KUNAG, -- Sold-to Party [KUNAG]
SPART, -- Division [SPART]
VKORG, -- Sales Org. [VKORG]
VKBUR, -- Sales Office [VKBUR]
VKGRP, -- Sales Group [VKGRP]
FKDAT, -- Billing Date [FKDAT]
FKTYP, -- BillingCategory [FKTYP]
FBUDA, -- Serv. Rend. Dte [FBUDA]
AUBEL, -- Sales Document [VBELN_VA]
AUPOS, -- Item [POSNR_VA]
FKIMG, -- Invoiced Qty [FKIMG]
VRKME, -- Sales Unit [VRKME]
FKLMG, -- Bill.Qty in SKU [FKLMG]
KAPPL, -- Application [KAPPL]
KNTYP, -- Condit.Category [KNTYP]
KURSK, -- Exchange Rate [KURSK]
KZZUAB, -- Debit/Credit [SHKZG]
KINAK, -- Inactive [KINAK]
NTGEW, -- Net Weight [NTGEW_15]
BRGEW, -- Gross Weight [BRGEW_15]
GEWEI, -- Unit of Weight [GEWEI]
VOLUM, -- Volume [VOLUM_15]
VOLEH, -- Volume Unit [VOLEH]
VBTYP, -- Document Cat. [VBTYPL]
VBEL2, -- Sales Document [VBELN_VA]
POSN2, -- Item [POSNR_VA]
FDLEV, -- Planning Level [FDLEV]
FDTAG, -- Planning Date [FDTAG]
FDGRP, -- Planning group [FDGRP]
FDWBT, -- Planned Amount [FDWBT]
KZUML, -- St.tfr./tfr.pst [KZUML]
XPKON, -- Check acct.ass. [XPKON]
KOAID, -- Condition Class [KOAID]
XAKON, -- Auto acct assgn [XAKON]
FKBER, -- Functional Area [FKBER]
AFABE, -- Deprec. area [AFABE_D]
VERSA, -- RA Version [VERSN_ABGR]
WIP_CAT, -- WIP category [PCA_WIP_CAT]
XLIFO, -- LIFO/FIFO-Rel. [XLIFO]
ERFMG, -- Quantity in UnE [ERFMG]
ERFME, -- Unit of Entry [ERFME]
DABRZ, -- Reference date [DABRBEZ]
AUGDT, -- Clearing [AUGDT]
AUGCP, -- ClearingEntDate [AUGCP]
AUGBL, -- Clrng doc. [AUGBL]
AGZEI, -- Clearing Item [AGZEI]
XNEGP, -- Negative Postg [XNEGP]
STGRD, -- Reversal Reason [STGRD]
CCINS, -- Card type [CCINS]
CCNUM, -- Card number [CCNUM]
CCFOL, -- Suffix [CCFOL]
DATAB, -- Valid from [DATAB_CC]
DATBI, -- Exp.date [DATBI_CC]
CCNAME, -- Cardholder [CCNAME]
CSOUR, -- Entry mode [CSOUR]
AUTWR, -- Authorized Amt [AUTWR]
CCWAE, -- Currency [WAERS]
SETTL, -- Settled [SETTL]
AUNUM, -- Auth. Number [AUNUM]
AUTRA, -- Auth. Ref. Code [AUTRA]
AUDAT, -- Auth. Date [AUDAT_CC]
AUTIM, -- Auth. Time [AUTIM]
MERCH, -- Merchant ID [MERCH]
LOCID, -- PointOfReceipt [LOCID_CC]
TRMID, -- Terminal [TRMID]
CCBTC, -- Settlement [CCBTC]
CCTYP, -- Card Category [CCTYP]
CCARD_GUID, -- Reference to Encrypted Payment Card Data [CCARDEC_GUID]
PAYMENT_AMOUNT, -- Amount [WRBTR]
DP_TOKEN, -- Token [DP_TOKEN]
DP_PSP, -- Paymnt Serv. Provid. [DP_PAYMENT_SERVICE_PROVIDER]
DP_PAYID, -- Payment ID [DP_PAYID]
DP_PSP_TRANSID, -- PSP Transaction ID [DP_PSP_TRANS_ID]
DP_TRANS_ID, -- Transaction/Payt ID [DP_TRANSID]
DP_MERCHANT_ALIAS, -- Merchant Alias [DP_MERCHANT_ALIAS]
DP_AUTH_REL_ID, -- Auth. Rel. ID [FAR_DP_AUTH_REL_ID]
DP_FRAUD_RISK, -- Fraud Risk Code [DP_FRAUD_RISK_CODE]
DP_CHARGE_TRANS_ID, -- Transaction/Payt ID [DP_TRANSID]
KKBER, -- Cred.Contr.Area [KKBER]
SHKZG_VA, -- Returns [SHKZG_VA]
SDSTR, -- 3rd-party order [SDSTR]
POSAR, -- Item Type [POSAR]
ANLO1, -- Asset [ANLN1]
ANLO2, -- Sub-number [ANLN2]
CONDI, -- CondKey [JV_CONDCOD]
BEMOT, -- AcctIndicator [BEMOT]
ABSBT, -- Hedged Amount [ABSBT]
KIDNO, -- Payment Ref. [KIDNO]
BRNCH, -- Branch number [J_1ABRNCH]
NUMPG, -- Number of Pages [J_1ANOPG]
ADISC, -- discount document [J_1ADISC]
GRICD, -- Activity Code [J_1AGICD_D]
GRIRG, -- Region [REGIO]
GITYP, -- Distr. Type [J_1ADTYP_D]
WT_KEY, -- Grouping Key [WT_KEY]
XBGBB, -- Ind.pst.offsEnt [XBGBB]
VERTT, -- Contract Type [RANTYP]
VERTN, -- Contract Number [RANL]
VBEWA, -- Flow Type [SBEWART]
BVTYP, -- Part.bank type [BVTYP]
HBKID, -- House Bank [HBKID]
HKTID, -- Account ID [HKTID]
NEBTR, -- Payment Amt [NEBTR]
MWSK1, -- Tax Code [MWSKX]
DMBT1, -- Amount [DMBTX]
MWSK2, -- Tax Code [MWSKX]
DMBT2, -- Amount [DMBTX]
MWSK3, -- Tax Code [MWSKX]
DMBT3, -- Amount [DMBTX]
ABWZE, -- Alt.payee [VVABWZE]
BVTYPABW, -- BankTyp alt.pyr [VVBVTYPABW]
BAPI_PARAM, -- Field Name [FIELDNAME]
BAPI_TABIX, -- Table Row [SYTABIX]
CCACT, -- G/L Account [CCACT]
CO_KAKST, -- AAT: Cost Ctr [CO_KAKST]
CO_KAAUF, -- AAType: Order [CO_KAAUF]
CO_KAPRO, -- Proj.Acct Assgn [CO_KAPRO]
CO_KAKTR, -- AAT: Cost Obj. [CO_KAKTR]
CO_KANPL, -- AAType: Network [CO_KANPL]
CO_KAIMO, -- AAT: RealEstObj [CO_KAIMO]
CO_KAKDA, -- AAT: Sales Ord. [CO_KAKDA]
CO_KAERG, -- BusSeg.AcctAssn [CO_KAERG]
CO_KAABS, -- AAT: Rec. Obj. [CO_KAABS]
CO_KAPRZ, -- AAT: Bus. Proc. [CO_KAPRZ]
CO_KASVD, -- AAT: Srv. Doc. [CO_KASVD]
CO_KASAT, -- AAType Not Used [CO_KASAT]
DUMMY_INCL_EEW_COBL, -- Dummy [CFD_DUMMY]
BVALTNR, -- PrcrmntAlt/Proc [CKML_ALPROCNR]
KALN1, -- ProdCostEst.No. [CK_KALNR1]
AUFNR_ORG, -- Orig. Order No. [CK_AUFNR_ORG]
CESSION_KZ, -- AR Pledging Ind [CESSION_KZ]
MLMAA, -- ML Act. [CK_ML_MAAC]
MLAST, -- Price Determ. [CK_ML_ABST]
ZEILE, -- Item [CK_ZEILE]
URZEILE, -- Item [CK_URZEILE]
MLBWG, -- Mvmt Type Group [CKML_MLBWG]
MLNPRD, -- No Brkdwn Pr.Diff. [CK_MLNPRD]
LSQTY, -- Last Amt Settld [CK_LSQTY]
PRQTY, -- PrDifQty InvVer [CK_PRQTY]
EKORG, -- Purchasing Org. [EKORG]
VKWRT, -- SalVal inc. VAT [VKWRT]
UMMAT, -- Receiving Mat. [UMMAT]
UMWRK, -- Receiving plant [UMWRK]
KNTTP, -- Acct Assgmt Cat [KNTTP]
UMSOK, -- Sp.ind.st.tfr. [UMSOK]
UMWER, -- Value updating [WERTU]
RRREL, -- Rev. Recognition [RR_RELTYP]
MAT_LIFNR, -- Vendor [MAT_LIFNR]
XOBEW, -- Vendor stk val. [XOBEW]
TPKNZ, -- TP indic. [TPKNZ]
XINVE, -- Invest.ID [XINVE]
KRUEK, -- Accruals [KRUEK]
AWTYP_REV, -- Ref. procedure [AWTYP]
AWTYP_REB, -- Ref. procedure [AWTYP]
VORNR, -- Activity [VORNR]
PGEBER, -- Partner Fund [FM_PFUND]
PENRC, -- Reason f. Delay [PENRC]
GRANT_NBR, -- Grant [GM_GRANT_NBR]
PGRANT_NBR, -- Partner Grant [GM_GRANT_PARTNER]
GMVKZ, -- Execution [FM_GMVKZ]
SRTYPE, -- Addit.Receivab. [FM_SRTYPE]
REINDAT, -- Inv. Recpt Date [REINDAT]
IDXSP, -- Inflation Index [J_1AINDXSP]
INTRENO, -- RE code [VVINTRENO]
GLUPM, -- Update [GLUPM]
MEASURE, -- Funded Program [FM_MEASURE]
STBLG, -- Reversed With [STBLG]
HZUON, -- Sp.G/L Assgt [HZUON]
SEGMENT, -- Segment [FB_SEGMENT]
PSEGMENT, -- Partner Segment [FB_PSEGMENT]
PFKBER, -- Partner FArea [SFKBER]
PKOSTL, -- Sender Cost Ctr [SKOST]
KSTAR, -- Cost Element [KSTAR]
FLG_NOBUD, -- N. Budget-Rel. [FM_NBUD]
PPA_EX_IND, -- PPA Exclude [EXCLUDE_FLG]
CASE_GUID_CORE, -- Case Key [SCMG_CASE_GUID]
LONGNUM, -- Smart Number [/SAPPSPRO/LONGNUM]
STODT, -- Reversal Date [STODT]
BDGT_SUBTYPE, -- Budget Subtype [BP_SUBVO]
COHORT, -- Year Cohort [FM_COHORT]
PUBLAW, -- Public Law [FM_PUBLAW]
LEGIS, -- Legislation [FM_LEGIS]
FMCMMTSTR, -- Commitment string [FMCMMTSTR]
PRODPER, -- Prod.Month [JV_PRODPER]
TCOBJNR, -- Object number [J_OBJNR]
DATEOFSERVICE, -- Date of Service [VVBEACTDATE]
NOTAXCORR, -- Do Not Correct [VVREITNOTAXCORR]
DIFFOPTRATE, -- Option Rate [POPTSATZ]
HASDIFFOPTRATE, -- Diff. Opt. Rate [VVREITUSEDIFFOPTRATE]
LOGSYSTEM_SENDER, -- Sender Log Sys. [LOGSYSTEM_SENDER]
BUKRS_SENDER, -- Sender CoCode [BUKRS_SENDER]
BELNR_SENDER, -- Sender Doc.No. [BELNR_SENDER]
GJAHR_SENDER, -- Sender FiscalYr [GJAHR_SENDER]
BUZEI_SENDER, -- Sender Item [BUZEI_SENDER]
ACDOC_EEW_DUMMY, -- Dummy [CFD_DUMMY]
TXDAT_FROM, -- Tax Rate Valid-From [FOT_TXDAT_FROM]
TAX_COUNTRY, -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
LWSTE, -- Tax Rept. Crcy [LWSTE_BSET]
LWBAS, -- Base Amount [LWBAS_BSET]
CURTP, -- Crcy type/val. [CURTP]
WAERS, -- Currency [WAERS]
WRBTR, -- Amount [ACBTR]
FWBAS, -- Base amount [ACSBS]
SKFBT, -- CD Base [ACFBT]
WSKTO, -- CD Amount [ACSKT]
QSSHB, -- W/Tax Base [ACQBS]
QSFBT, -- W/Tax-Exempt [ACQBT]
BUALT, -- Amount [BUALT]
KWERT, -- Condition Value [KWERT]
NAVBT, -- Non-Deductible [NAVFW]
WMWST, -- Tax Amount [WMWST]
CURRTYP, -- Currency Type [CURRTYP]
VALUTYP, -- Valuation View [VALUTYP]
GBETR, -- Hedged [GBETR]
KURSR, -- Hedged Ex.Rt [KURSR]
WRBTR_FIX, -- Amount [ACBTR_FIX]
WRBTR_AVG, -- Average Amount [GLE_DTE_ADB_AVERAGE_AMOUNT]
CURT1, -- LC1 curr.type [CURT1]
HWAER, -- Local Currency [HWAER]
DMBTR, -- Amount in LC [DMBTR]
KURSF, -- Exchange rate [KURSF]
HWSTE, -- LC Tax [HWSTE]
HWBAS, -- LC Base [HWBAS]
TXKRS, -- Rate for Taxes [TXKRS_BKPF]
SKNTO, -- Discount Amt [SKNTO]
KZBTR, -- Orig.Reduction [KZBTR_FI]
MWSTS, -- LC Tax [MWSTS]
DMBTR_AVG, -- Average Amount [GLE_DTE_ADB_AVERAGE_AMOUNT]
CURT2, -- LC2 Crcy Type [CURT2]
HWAE2, -- Local curr. 2 [HWAE2]
DMBE2, -- LC2 Amount [DMBE2]
KURS2, -- Exchange Rate 2 [KURS2]
H2STE, -- LC 2 Tax [H2STE]
SKNT2, -- CD Amt LC2 [SKNT2]
MWST2, -- LC2 Tax [MWST2]
TXBH2, -- LC2 Tax Base Amount [TXBH2]
BASW2, -- Source Currency [CURSR]
UMRD2, -- Trans. Date [UMRD2]
KUTY2, -- Exch. Rate Type [KURST]
DMBE2_AVG, -- Average Amount [GLE_DTE_ADB_AVERAGE_AMOUNT]
CURT3, -- LC3 Crcy Type [CURT3]
HWAE3, -- Local curr. 3 [HWAE3]
DMBE3, -- LC3 Amount [DMBE3]
KURS3, -- Exchange Rate 3 [KURS3]
H3STE, -- LC 3 Tax [H3STE]
SKNT3, -- CD Amt LC3 [SKNT3]
MWST3, -- LC3 Tax [MWST3]
TXBH3, -- LC3 Tax Base Amount [TXBH3]
BASW3, -- Source Currency [CURSR]
UMRD3, -- Trans. Date [UMRD3]
KUTY3, -- Exch. Rate Type [KURST]
DMBE3_AVG, -- Average Amount [GLE_DTE_ADB_AVERAGE_AMOUNT]
CURT4, -- Currency type [GLE_FINS_CURTYPE]
HWAE4, -- Local curr. 4 [GLE_FINS_HWAE4]
DMBE4, -- LC4 amount [GLE_FINS_DMBE4]
CURT5, -- Currency type [GLE_FINS_CURTYPE]
HWAE5, -- Local curr. 4 [GLE_FINS_HWAE5]
DMBE5, -- LC5 amount [GLE_FINS_DMBE5]
CURT6, -- Currency type [GLE_FINS_CURTYPE]
HWAE6, -- Local curr. 6 [GLE_FINS_HWAE6]
DMBE6, -- LC6 amount [GLE_FINS_DMBE6]
CURT7, -- Currency type [GLE_FINS_CURTYPE]
HWAE7, -- Local curr. 7 [GLE_FINS_HWAE7]
DMBE7, -- LC7 amount [GLE_FINS_DMBE7]
CURT8, -- Currency type [GLE_FINS_CURTYPE]
HWAE8, -- Local curr. 8 [GLE_FINS_HWAE8]
DMBE8, -- LC8 amount [GLE_FINS_DMBE8]
CURT9, -- Currency type [GLE_FINS_CURTYPE]
HWAE9, -- Local curr. 9 [GLE_FINS_HWAE9]
DMBE9, -- LC9 amount [GLE_FINS_DMBE9]
CURT10, -- Currency type [GLE_FINS_CURTYPE]
HWAE10, -- Local curr. 10 [GLE_FINS_HWAE10]
DMBE10, -- LC10 amount [GLE_FINS_DMBE10]
PRIMARY KEY (MANDT, ITEM_ID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA