ACDOCTEMP
Universal Journal: Temporary Data
ACDOCTEMP is an SAP database table in S/4HANA. Universal Journal: Temporary Data. It contains 501 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| fins_cnv_rec_clr_bc_aa | view_entity | from | LCC: Select of cleared JE before LCC | |
| fins_cnv_rec_clr_bc_naa | view_entity | from | LCC: Select of cleared JE before LCC | |
| I_TempGLAccountLineItem | view | from | BASIC | i cds view for acdoctemp |
| V_ACDOCT_EXT_DDL | view | from | Universal Journal Entry: Temp Data - Ext |
Fields (501)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | rclnt | MANDT | Client | |||
| KEY | temp_appl | FINS_ACDOCTEMP_APPL | Application | |||
| KEY | temp_id | FINS_ACDOCTEMP_ID | Temp. Data ID | |||
| KEY | rldnr | FINS_LEDGER | Ledger | |||
| KEY | rbukrs | BUKRS | Company Code | |||
| KEY | gjahr | GJAHR | Fiscal Year | |||
| KEY | belnr | BELNR_D | Document Number | |||
| KEY | docln | DOCLN6 | G/L Line Item | |||
| ryear | GJAHR_POS | G/L Fiscal Year | ||||
| docnr_ld | FINS_DOCNR_LD | Ledger spec. DocNo | ||||
| rrcty | RRCTY | Record Type | ||||
| rmvct | RMVCT | Transact. Type | ||||
| vorgn | VORGN | Transact. Type | ||||
| vrgng | CO_VORGANG | Bus.Transaction | ||||
| bttype | FINS_BTTYPE | Bus. Trans. Category | ||||
| cbttype | FINS_CUSTBTTYPE | Bus. Trans. Type | ||||
| closingstep | FINS_CLOSINGSTEP | Closing Step | ||||
| awtyp | AWTYP | Ref. procedure | ||||
| awsys | AWSYS | Logical System | ||||
| aworg | AWORG | Refer. Org.Unit | ||||
| awref | AWREF | Reference Doc. | ||||
| awitem | FINS_AWITEM | Ref. Doc. Item | ||||
| awitgrp | FINS_AWITGRP | Ref. Item Group | ||||
| subta | FINS_SUBTA | Sub Transaction | ||||
| acctg_notif_uuid | FAN_HDR_TECHNICAL_ID | Accounting Notification UUID | ||||
| offstg_docln | DOCLN6_OFFSETTING | Offst Entry Itm | ||||
| xreversing | FINS_XREVERSING | Is Reversing | ||||
| xreversed | FINS_XREVERSED | Is Reversed | ||||
| xtruerev | FINS_XTRUEREV | Is true reversal | ||||
| awtyp_rev | AWTYP_REV | ReversalRefTran | ||||
| aworg_rev | AWORG_REV | Reversal Org. | ||||
| awref_rev | AWREF_REV | Reversal Ref. | ||||
| awitem_rev | AWITEM_REV | Reversal Ref.Doc. LI | ||||
| subta_rev | FINS_SUBTA_REV | Reversal Sub Trans | ||||
| xsettling | FINS_XSETTLING | Is Settling | ||||
| xsettled | FINS_XSETTLED | Is Settled | ||||
| prec_awtyp | FINS_PREC_AWTYP | PrecRefTransact | ||||
| prec_awsys | FINS_PREC_AWSYS | PrecRefLogSys | ||||
| prec_aworg | FINS_PREC_AWORG | PrecRefOrgUnit | ||||
| prec_awref | FINS_PREC_AWREF | PrecRefDocument | ||||
| prec_awitem | FINS_PREC_AWITEM | Prec. Ref. Doc. Item | ||||
| prec_subta | FINS_PREC_SUBTA | Prec. Sub Transactn | ||||
| prec_awmult | FINS_PREC_AWMULT_UUID | MultPrecRefID | ||||
| prec_bukrs | FINS_PREC_BUKRS | PrecJE CoCode | ||||
| prec_gjahr | FINS_PREC_GJAHR | PrecJE Year | ||||
| prec_belnr | FINS_PREC_BELNR | PrecJE DocNo | ||||
| prec_docln | FINS_PREC_DOCLN | PrecJE LineItem | ||||
| xsecondary | FINS_SECONDARY_ENTRY | Secondary entry | ||||
| closing_run_id | CLS_RUN_ID | Closing Run UUID | ||||
| orgl_change | FINOC_ORGL_CHANGE | Organizational Change | ||||
| src_awtyp | FINS_SRC_AWTYP | Src Doc Type | ||||
| src_awsys | FINS_SRC_AWSYS | Src Doc Sys | ||||
| src_aworg | FINS_SRC_AWORG | Source Org Unit | ||||
| src_awref | FINS_SRC_AWREF | Source Doc. No. | ||||
| src_awitem | FINS_SRC_AWITEM | Source Doc. LineItem | ||||
| src_awsubit | FINS_SRC_AWSUBIT | Source Doc. Subitem | ||||
| xcommitment | FINS_XCOMMITMENT | Commitment | ||||
| obs_reason | FINS_OBSOLETE_ITEM_REASON | Obsolete Reason | ||||
| rtcur | FINS_CURRT | Bal. Transac. Crcy | ||||
| rwcur | FINS_CURRW | Transaction Currency | ||||
| rhcur | FINS_CURRH | CompanyCode Currency | ||||
| rkcur | FINS_CURRK | Global Currency | ||||
| rfccur | FINS_CURRFC | Functional Currency | ||||
| rocur | FINS_CURR1 | Free Defined Crcy 1 | ||||
| rvcur | FINS_CURR2 | Free Defined Crcy 2 | ||||
| rbcur | FINS_CURR3 | Free Defined Crcy 3 | ||||
| rccur | FINS_CURR4 | Free Defined Crcy 4 | ||||
| rdcur | FINS_CURR5 | Free Defined Crcy 5 | ||||
| recur | FINS_CURR6 | Free Defined Crcy 6 | ||||
| rfcur | FINS_CURR7 | Free Defined Crcy 7 | ||||
| rgcur | FINS_CURR8 | Free Defined Crcy 8 | ||||
| rco_ocur | FINS_CO_OCUR | CO Object Currency | ||||
| rgm_ocur | GM_GRANT_CURRENCY | Grant Currency | ||||
| runit | MEINS | Base Unit | ||||
| rvunit | RVUNIT | Valuation UoM | ||||
| rrunit | RRUNIT | Reference UoM | ||||
| rmsl_type | FINS_RMSL_QTY_TYPE_CODE | Ref. Quantity Type | ||||
| riunit | FINS_RIUNIT | Inventory UoM | ||||
| qunit1 | FCO_QUNIT1 | Add Unit Meas 1 | ||||
| qunit2 | FCO_QUNIT2 | Add Unit Meas 2 | ||||
| qunit3 | FCO_QUNIT3 | Add Unit Meas 3 | ||||
| co_meinh | FCO_MEINH | UoM COValQty | ||||
| racct | RACCT | Account Number | ||||
| rcntr | KOSTL | Cost Center | ||||
| prctr | PRCTR | Profit Center | ||||
| rfarea | FKBER | Functional Area | ||||
| rbusa | GSBER | Business Area | ||||
| kokrs | KOKRS | CO Area | ||||
| segment | FB_SEGMENT | Segment | ||||
| scntr | SKOST | Sender Cost Ctr | ||||
| pprctr | PPRCTR | Partner PC | ||||
| sfarea | SFKBER | Partner FArea | ||||
| sbusa | PARGB | Trdg Part.BA | ||||
| rassc | RASSC | Trading Partner | ||||
| psegment | FB_PSEGMENT | Partner Segment | ||||
| tsl | FINS_VTCUR12 | Amnt in Bal Tr Crcy | ||||
| wsl | FINS_VWCUR12 | Amnt in Trans. Crcy | ||||
| wsl2 | FINS_VWCUR12_2 | GV Amnt in TransCrcy | ||||
| wsl3 | FINS_VWCUR12_3 | PCV Amnt in TrnsCrcy | ||||
| hsl | FINS_VHCUR12 | Amnt in Comp Cd Crcy | ||||
| ksl | FINS_VKCUR12 | Amnt in Global Crcy | ||||
| fcsl | FINS_VFCCUR12 | Amount in FunctCrcy | ||||
| osl | FINS_VOCUR12 | Amount in Currency 1 | ||||
| vsl | FINS_VVCUR12 | Amount in Currency 2 | ||||
| bsl | FINS_VBCUR12 | Amount in Currency 3 | ||||
| csl | FINS_VCCUR12 | Amount in Currency 4 | ||||
| dsl | FINS_VDCUR12 | Amount in Currency 5 | ||||
| esl | FINS_VECUR12 | Amount in Currency 6 | ||||
| fsl | FINS_VFCUR12 | Amount in Currency 7 | ||||
| gsl | FINS_VGCUR12 | Amount in Currency 8 | ||||
| kfsl | FINS_VGCUR12_FIX | Fixed Amnt in GC | ||||
| kfsl2 | FINS_VGCUR12_FIX2 | GV Fixd Amt Glb Crcy | ||||
| kfsl3 | FINS_VGCUR12_FIX3 | PCV FixdAmt Glb Crcy | ||||
| psl | FINS_VPCUR12 | Price Variance | ||||
| psl2 | FINS_VPCUR12_2 | GVal TPrice Varc GC | ||||
| psl3 | FINS_VPCUR12_3 | PCVal TPrice Varc GC | ||||
| pfsl | FINS_VPFCUR12 | Price Var. Fxd | ||||
| pfsl2 | FINS_VPFCUR12_2 | GVal FPrice Varc GC | ||||
| pfsl3 | FINS_VPFCUR12_3 | PCVal FPrice Varc GC | ||||
| co_osl | FINS_VCO_OCUR12 | Amount in Obj Crcy | ||||
| gm_osl | GM_GRANT_AMOUNT | Amount in Grant Crcy | ||||
| hslalt | MLHSLALT | AltValue LC | ||||
| kslalt | MLKSLALT | AltValue GC | ||||
| oslalt | MLOSLALT | AltValue in Crcy 1 | ||||
| vslalt | ML4SLALT | AltValue in Crcy 2 | ||||
| bslalt | MLBSLALT | AltValue in Crcy 3 | ||||
| cslalt | MLCSLALT | AltValue in Crcy 4 | ||||
| dslalt | MLDSLALT | AltValue in Crcy 5 | ||||
| eslalt | MLESLALT | AltValue in Crcy 6 | ||||
| fslalt | MLFSLALT | AltValue in Crcy 7 | ||||
| gslalt | MLGSLALT | AltValue in Crcy 8 | ||||
| hslext | MLHSLEXT | ExtValue LC | ||||
| kslext | MLKSLEXT | ExtValue GC | ||||
| oslext | MLOSLEXT | ExtValue in Crcy 1 | ||||
| vslext | ML4SLEXT | ExtValue in Crcy 2 | ||||
| bslext | MLBSLEXT | ExtValue in Crcy 3 | ||||
| cslext | MLCSLEXT | ExtValue in Crcy 4 | ||||
| dslext | MLDSLEXT | ExtValue in Crcy 5 | ||||
| eslext | MLESLEXT | ExtValue in Crcy 6 | ||||
| fslext | MLFSLEXT | ExtValue in Crcy 7 | ||||
| gslext | MLGSLEXT | ExtValue in Crcy 8 | ||||
| hvkwrt | MLHVKWRT | Value SP LCrcy | ||||
| msl | QUAN1_12 | Quantity | ||||
| mfsl | QUAN1_12_FIX | Fixed quantity | ||||
| vmsl | VQUAN1_12 | Val. quantity | ||||
| vmfsl | VQUAN1_12_FIX | Fixed val. qty | ||||
| rmsl | RQUAN1_12 | Ref. quantity | ||||
| quant1 | FCO_QUAN1_L | Add. Quantity 1 | ||||
| quant2 | FCO_QUAN2_L | Add. Quantity 2 | ||||
| quant3 | FCO_QUAN3_L | Add. Quantity 3 | ||||
| co_megbtr | FCO_MEGBTR | COValQty | ||||
| co_mefbtr | FCO_MEFBTR | COValQtyFix | ||||
| hsalk3 | MLHSALK3 | InvValue LCrcy | ||||
| ksalk3 | MLKSALK3 | InvValue GCrcy | ||||
| osalk3 | MLOSALK3 | InvValue FDC 1 | ||||
| vsalk3 | ML4SALK3 | InvValue FDC 2 | ||||
| hsalkv | MLHSALKV | AltInvValue LC | ||||
| ksalkv | MLKSALKV | AltInvValue GC | ||||
| osalkv | MLOSALKV | AltInvV FDC 1 | ||||
| vsalkv | ML4SALKV | AltInvV FDC 2 | ||||
| hpvprs | MLHPVPRS | MAP LCrcy | ||||
| kpvprs | MLKPVPRS | MAP GCrcy | ||||
| opvprs | MLOPVPRS | MAP ACrcy | ||||
| vpvprs | ML4PVPRS | MAP 4Crcy | ||||
| hstprs | MLHSTPRS | StdPrice LCrcy | ||||
| kstprs | MLKSTPRS | StdPrice GCrcy | ||||
| ostprs | MLOSTPRS | StdPrice ACrcy | ||||
| vstprs | ML4STPRS | StdPrice 4Crcy | ||||
| hvksal | MLHVKSAL | InvVal SP LCrcy | ||||
| lbkum | MLLBKUM | Inv. Quantity | ||||
| drcrk | SHKZG | Debit/Credit | ||||
| poper | POPER | Posting Period | ||||
| periv | PERIV | FY Variant | ||||
| fiscyearper | JAHRPER | Period/Year | ||||
| budat | BUDAT | Posting Date | ||||
| bldat | BLDAT | Document Date | ||||
| blart | BLART | Document Type | ||||
| buzei | BUZEI | Item | ||||
| zuonr | DZUONR | Assignment | ||||
| bschl | BSCHL | Posting Key | ||||
| bstat | BSTAT_D | Document Status | ||||
| bus_trans_item_category | FINS_BUS_TRANS_ITEM_CATEGORY | Business Transaction Item Category | ||||
| linetype | LINETYPE | Item Category | ||||
| ktosl | KTOSL | Transaction | ||||
| slalittype | SLALITTYPE | SLALineItemType | ||||
| xsplitmod | XSPLITMOD | Changed | ||||
| usnam | USNAM | User Name | ||||
| timestamp | FIS_CREA_TSTAMP | Creation Time | ||||
| last_change_datetime | FIS_CHNG_TSTAMP | Last Changed At | ||||
| eprctr | EPRCTR | Elimination PrCtr | ||||
| rhoart | HOART | Origin object | ||||
| glaccount_type | GLACCOUNT_TYPE | G/L Account Type | ||||
| ktopl | KTOPL | Chart of Accts | ||||
| lokkt | ALTKT_SKB1 | Altern. Account | ||||
| ktop2 | KTOP2 | Alternative COA | ||||
| rbunit | FINCS_MD_BUNIT | Consolidation Unit | ||||
| rbuptr | FINCS_MD_BUPTR | Partner Unit | ||||
| rcomp | RCOMP_D | Company | ||||
| ritclg | FC_ITCLG | Cons. COA | ||||
| ritem | FINCS_FSI_ITEM | FS Item | ||||
| sityp | FC_SITYP | Subitem Category | ||||
| subit | FC_SITEM | Subitem | ||||
| rebzg | REBZG | Invoice Ref. | ||||
| rebzj | REBZJ | Fiscal Year | ||||
| rebzz | REBZZ | Item | ||||
| rebzt | REBZT | Follow-On Doc. Type | ||||
| rbest | CO_RBEST | PO Category | ||||
| ebeln_logsys | EBELN_LOGSYS | LogSys of PurchDoc | ||||
| ebeln | EBELN | Purchasing Doc. | ||||
| ebelp | EBELP | Item | ||||
| zekkn | DZEKKN | Account Assgmt No. | ||||
| sgtxt | SGTXT | Text | ||||
| kdauf | KDAUF | Sales Order | ||||
| kdpos | KDPOS | Sales Ord. Item | ||||
| matnr | MATNR | Material | ||||
| werks | WERKS_D | Plant | ||||
| lifnr | LIFNR | Supplier | ||||
| kunnr | KUNNR | Customer | ||||
| fbuda | FBUDA | Serv. Rend. Dte | ||||
| perop_beg | FM_PEROP_FI_LOW | Per. of Perf. Start | ||||
| perop_end | FM_PEROP_FI_HIGH | Per. of Perf. End | ||||
| coco_num | WCB_COCO_NUM | Condition Contract | ||||
| wwert | WWERT_D | Translatn Date | ||||
| prctr_drvtn_source_type | FINOC_PRCTR_DRVTN_SOURCE_TYPE | Profit Center Source | ||||
| ucb_id | FUCB_ID | Breakdown ID | ||||
| ucb_scale_numerator | FUCB_SCALE_NUMERATOR | Scale Numerator | ||||
| koart | KOART | Account type | ||||
| umskz | UMSKZ | Special G/L Ind | ||||
| tax_country | FOT_TAX_COUNTRY | Tax Ctry/Reg. | ||||
| mwskz | MWSKZ | Tax Code | ||||
| hbkid | HBKID | House Bank | ||||
| hktid | HKTID | Account ID | ||||
| valut | VALUT | Value date | ||||
| xopvw | XOPVW | OI Management | ||||
| augdt | AUGDT | Clearing | ||||
| augbl | AUGBL | Clrng doc. | ||||
| auggj | AUGGJ | Clrg Fiscal Yr | ||||
| oi_ref_type | FINS_OI_REF_TYPE | Open Item Ref Type | ||||
| oi_ref_id | FINS_OI_REF_ID | Open Item Ref ID | ||||
| aging | FINS_AGING | Aging | ||||
| aging_incrmnt | FINS_INCRMNT | Increment | ||||
| afabe | AFABER | Deprec. Area | ||||
| anln1 | ANLN1 | Asset | ||||
| anln2 | ANLN2 | Sub-number | ||||
| bzdat | BZDAT | Asset Val. Date | ||||
| anbwa | ANBWA | Ast Transaction Type | ||||
| movcat | FAA_MOVCAT | Trans.Type Cat. | ||||
| depr_period | PERAF | Deprec. Period | ||||
| anlgr | ANLGR | Group Asset | ||||
| anlgr2 | ANLGR2 | Subnumber | ||||
| settlement_rule | BUREG | Distr. Rule Grp | ||||
| anlkl | ANLKL | Asset Class | ||||
| ktogr | KTOGR | Account Determ. | ||||
| panl1 | PANL1 | Partner Asset | ||||
| panl2 | PANL2 | Partner Sub-No. | ||||
| anln2_pn | ANLN2_PN | Asset Subnumber | ||||
| bwasl_pn | BWASL | Trans. Type | ||||
| bzdat_pn | BZDAT_PN | Asset Val. Date | ||||
| ubzdt_pn | UBZDT | Orig. Val. Dat | ||||
| xvabg_pn | XVABG | Compl.Retiremnt | ||||
| anbtr_pn | ANBTR | Amount Posted | ||||
| prozs_pn | PROZS | Percentage Rate | ||||
| xmanpropval_pn | XMANPROPVAL | Man. Proport. Values | ||||
| kalnr | CK_KALNR | Cost EstimateNo | ||||
| vprsv | VPRSV | Price control | ||||
| mlast | CK_ML_ABST | Price Determ. | ||||
| kzbws | MLKZBWS | Valuation | ||||
| xobew | MLXOBEW | Vendor stk val. | ||||
| sobkz | SOBKZ | Special Stock | ||||
| vtstamp | VTIMESTAMPL | Valu. TimeStamp | ||||
| mat_kdauf | MLMAT_KDAUF | SD Doc of Inv. | ||||
| mat_kdpos | MLMAT_KDPOS | SD Item of Inv. | ||||
| mat_pspnr | MLMAT_PSPNR | WBSElem of Inv. | ||||
| mat_ps_posid | MLMAT_PS_POSID | WBSElem of Inv. | ||||
| mat_lifnr | MLMAT_LIFNR | Vendor of Inv. | ||||
| bwtar | BWTAR_D | Valuation Type | ||||
| bwkey | BWKEY | Valuation Area | ||||
| hpeinh | MLHPEINH | Price Unit LC | ||||
| kpeinh | MLKPEINH | Price Unit GC | ||||
| opeinh | MLOPEINH | Price Unit AC | ||||
| vpeinh | ML4PEINH | Price Unit 4C | ||||
| mlptyp | ML_PTYP_ORG | Orig. proc.cat. | ||||
| mlcateg | ML_KATEGORIE | Category | ||||
| qsbvalt | ML_QSBVALT | PrcrmntAlt/proc | ||||
| qsprocess | ML_QSPROCESS | Prod. Proc. No. | ||||
| perart | ML_PER_ART | Period Type | ||||
| mlposnr | ML_MLPOS | Item | ||||
| inv_mov_categ | FBV_INV_MOV_CATEG | Inv Movement Categ | ||||
| bukrs_sender | BUKRS_SENDER | Sender CoCode | ||||
| racct_sender | RACCT_SENDER | Sender GL Account | ||||
| accas_sender | ACCAS_SENDER | Sender Acct Assgmt | ||||
| accasty_sender | ACCASTY_SENDER | Sndr AcctAssgmt Type | ||||
| objnr | J_OBJNR | Object number | ||||
| hrkft | CO_SUBKEY | CO subkey | ||||
| hkgrp | HRKFT | Origin Group | ||||
| parob1 | PAROB1 | Partner Object | ||||
| parobsrc | FINS_PAROB_SRC | ParObj Source | ||||
| uspob | USPOB | Source Object | ||||
| co_belkz | FINS_CO_BELKZ | Dr/Cr ind. CO | ||||
| co_beknz | FINS_CO_BEKNZ | Dr/Cr (Origin) | ||||
| beltp | BP_INOUT | Debit Type | ||||
| muvflg | FCO_MUV_CODE | Qty Is Incomplete | ||||
| gkont | GKONT | Offsetting Acct | ||||
| gkoar | GKOAR | Offst.Acct Type | ||||
| erlkz | KBLERLKZ | Item Completed | ||||
| pernr | PERNR_D | Personnel No. | ||||
| paobjnr | RKEOBJNR | Profit. segment | ||||
| prof_seg_type | FINS_PROF_SEG_TYPE | Prof. Segment Type | ||||
| xpaobjnr_co_rel | FINS_XPAOBJNR_CO_REL | PAObj is CO relevant | ||||
| scope | SCOPE_CV | Object Class | ||||
| logsyso | LOGSYSO | Logical System | ||||
| pbukrs | PBUKRS | Partner CoCode | ||||
| pscope | PSCOPE_CV | PartnerObjClass | ||||
| logsysp | LOGSYSP | Logical system | ||||
| bwstrat | BWSTRAT | Val.strategy | ||||
| objnr_hk | OBJNR_HK | Origin object | ||||
| aufnr_org | AUFNR_HK | Origin Order | ||||
| ukostl | USP_KOSTL | OrigCCtr | ||||
| ulstar | USP_LSTAR | OrigAct. | ||||
| uprznr | USP_PRZNR | Sce: BProc. | ||||
| uprctr | FINS_ORIGIN_PRCTR | Origin Profit Center | ||||
| umatnr | FINS_ORIGIN_MATNR | Origin Material | ||||
| varc_uacct | FINS_VARC_ORIGIN_ACCT | Varc. Origin Account | ||||
| varc_hkgrp | FINS_VARC_ORIGIN_GROUP | Varc. Origin Group | ||||
| accas | ACCAS | Account Assignment | ||||
| accasty | J_OBART | Object Type | ||||
| lstar | LSTAR | Activity Type | ||||
| aufnr | AUFNR | Order | ||||
| autyp | AUFTYP | Order category | ||||
| ps_psp_pnr | PS_PSP_PNR | WBS Element | ||||
| ps_posid | PS_POSID | WBS Element | ||||
| ps_prj_pnr | PS_INTNR | Project def. | ||||
| ps_pspid | PS_PSPID | Project def. | ||||
| nplnr | NPLNR | Network | ||||
| nplnr_vorgn | NPVRG | Netwk activity | ||||
| prznr | CO_PRZNR | Business Process | ||||
| kstrg | KSTRG | Cost Object | ||||
| bemot | BEMOT | AcctIndicator | ||||
| rsrce | CO_RESSOURCE | Resource | ||||
| qmnum | QMNUM | Notification | ||||
| service_doc_type | FCO_SRVDOC_TYPE | Service Doc. Type | ||||
| service_doc_id | FCO_SRVDOC_ID | Service Document | ||||
| service_doc_item_id | FCO_SRVDOC_ITEM_ID | Service Doc. Item | ||||
| service_contract_type | FCO_SRVCONTRACT_TYPE | Serv. Contract Type | ||||
| service_contract_id | FCO_SRVCONTRACT_ID | Service Contract | ||||
| service_contract_item_id | FCO_SRVCONTRACT_ITEM_ID | Srv Contract Item | ||||
| solution_order_id | FCO_SOLUTION_ORDER_ID | Solution Order | ||||
| solution_order_item_id | FCO_SOLUTION_ORDER_ITEM_ID | Solution Order Item | ||||
| vtkey | VTKEY_KK | Contract | ||||
| vtpos | VTPOS_KK | Contract Item | ||||
| ra_contract_id | FARR_CONTRACT_ID | Contract | ||||
| ra_pob_id | FARR_POB_ID | POB | ||||
| erkrs | ERKRS | Operating concern | ||||
| paccas | PACCAS | Part. Acct Assgmt | ||||
| paccasty | CO_POBART | Prt.object type | ||||
| plstar | PAR_LSTAR | ParActvy | ||||
| paufnr | PAR_AUFNR | Partner order | ||||
| pautyp | FCO_PAR_AUFTYP | Prtnr Ord. Cat. | ||||
| pps_psp_pnr | FCO_PAR_PSP_PNR | Partner WBS Element | ||||
| pps_posid | FCO_PAR_POSID | Partner WBS Element | ||||
| pps_prj_pnr | FCO_PAR_PRJ_PNR | Partner Project Def. | ||||
| pps_pspid | FCO_PAR_PSPID | Part. Proj. Def | ||||
| pkdauf | PAR_KDAUF | Partner SalOrd | ||||
| pkdpos | PAR_KDPOS | Part. SlsOrd Item | ||||
| ppaobjnr | RKEPOBJ | PartnerPrf.Seg. | ||||
| pnplnr | PAR_NPLN | Part. Proj. Network | ||||
| pnplnr_vorgn | PAR_VORNR_AUF | Part.Proj.Ntwk.Acty | ||||
| pprznr | PAR_PRZNR | Part. Bus. Process | ||||
| pkstrg | PAR_KSTRG | Partner Cost Object | ||||
| pservice_doc_type | FCO_PSRVDOC_TYPE | Par. Service DocType | ||||
| pservice_doc_id | FCO_PSRVDOC_ID | Partner Service Doc. | ||||
| pservice_doc_item_id | FCO_PSRVDOC_ITEM_ID | Par. Service DocItem | ||||
| co_accasty_n1 | FINS_ACCASTY_N1 | Stat. AcctAss.Type 1 | ||||
| co_accasty_n2 | FINS_ACCASTY_N2 | Stat. AcctAss.Type 2 | ||||
| co_accasty_n3 | FINS_ACCASTY_N3 | Stat. AcctAss.Type 3 | ||||
| co_zlenr | DZLENR | Item | ||||
| co_belnr | CO_BELNR | Document Number | ||||
| co_buzei | CO_BUZEI | Posting Row | ||||
| co_buzei1 | FCO_BUZEI1 | CO PostingRow 1 | ||||
| co_buzei2 | FCO_BUZEI2 | CO PostingRow 2 | ||||
| co_buzei5 | FCO_BUZEI5 | CO PostingRow 5 | ||||
| co_buzei6 | FCO_BUZEI6 | CO PostingRow 6 | ||||
| co_buzei7 | FCO_BUZEI7 | CO PostingRow 7 | ||||
| co_refbz | CO_REFBZ | Posting Row | ||||
| co_refbz1 | FCO_REFBZ1 | RefPostRow 1 | ||||
| co_refbz2 | FCO_REFBZ2 | RefPostRow 2 | ||||
| co_refbz5 | FCO_REFBZ5 | RefPostRow 5 | ||||
| co_refbz6 | FCO_REFBZ6 | RefPostRow 6 | ||||
| co_refbz7 | FCO_REFBZ7 | RefPostRow 7 | ||||
| overtimecat | CATS_OVERTIME_CATEGORY | Overtime Category | ||||
| work_item_id | /CPD/PFP_WORKITEM_ID | Work Item ID | ||||
| arbid | CR_OBJID | Object ID | ||||
| vornr | VORNR | Activity | ||||
| aufps | CO_POSNR | Item Number | ||||
| uvorn | UVORN | Suboperation | ||||
| equnr | EQUNR | Equipment | ||||
| tplnr | TPLNR | Functional loc. | ||||
| istru | ISTRU | Assembly | ||||
| ilart | ILA | MaintActivType | ||||
| plknz | AUF_PLKNZ | OrderPlanInd. | ||||
| artpr | ARTPR | PriorityType | ||||
| priok | PRIOK | Priority | ||||
| maufnr | MAUFNR | Superior Order | ||||
| matkl_mm | FINS_MATKL_MM | Material Group | ||||
| paufps | FCO_PAR_AUFPS | Partner Order item | ||||
| vornr_org | FINS_ORIGIN_OPERATION | Origin Operation | ||||
| planned_parts_work | FINS_PLANNED_PARTS_WORK | Planned Parts/Work | ||||
| fkart | FKART | Billing Type | ||||
| vkorg | VKORG | Sales Org. | ||||
| vtweg | VTWEG | Distr. Channel | ||||
| spart | SPART | Division | ||||
| matnr_copa | FINS_MATNR_PA | Product Sold | ||||
| matkl | FINS_MATKL_PA | Product Sold Group | ||||
| kdgrp | KDGRP | Customer Group | ||||
| land1 | COBL_LAND1_GP | Country/Region | ||||
| brsch | BRSCH | Industry | ||||
| bzirk | BZIRK | Sales District | ||||
| kunre | KUNRE | Bill-to Party | ||||
| kunwe | KUNWE | Ship-to Party | ||||
| konzs | KONZS | Group | ||||
| acdoc_copa_eew_dummy_pa | DUMMY | Dummy function in length 1 | ||||
| dummy_mrkt_sgmnt_eew_ps | CFD_DUMMY | Dummy | ||||
| re_bukrs | FIS_RE_BUKRS | Cash Origin CoCode | ||||
| re_account | FIS_RE_ACCOUNT | Cash Origin Account | ||||
| fikrs | FIKRS | FM Area | ||||
| fipex | FM_FIPEX | Commitment Item | ||||
| fistl | FISTL | Funds Center | ||||
| measure | FM_MEASURE | Funded Program | ||||
| rfund | BP_GEBER | Fund | ||||
| rgrant_nbr | GM_GRANT_NBR | Grant | ||||
| rbudget_pd | FM_BUDGET_PERIOD | Budget Period | ||||
| sfund | BP_P_GEBER | Partner Fund | ||||
| sgrant_nbr | GM_GRANT_PARTNER | Partner Grant | ||||
| sbudget_pd | FM_PBUDGET_PERIOD | Par. BudPer | ||||
| bdgt_account | PSM_BDGT_ACCOUNT | Budget Account | ||||
| bdgt_account_cocode | PSM_BDGT_ACCOUNT_COCODE | Company Code for Budget Account | ||||
| bdgt_cnsmpn_date | PSM_BDGT_CNSMPN_DATE | Budget Consumption Date | ||||
| bdgt_cnsmpn_period | PSM_BDGT_CNSMPN_PERIOD | Posting Period for Budget Consumption | ||||
| bdgt_cnsmpn_year | PSM_BDGT_CNSMPN_YEAR | Year of Budget Consumption | ||||
| bdgt_relevant | PSM_BDGT_RELEVANT | Budget-Relevant | ||||
| bdgt_cnsmpn_type | PSM_BDGT_CNSMPN_TYPE | Budget Consumption Type | ||||
| bdgt_cnsmpn_amount_type | PSM_BDGT_CNSMPN_AMOUNT_TYPE | Amount Type for Budget Consumption | ||||
| rsponsored_prog | GM_SPONSORED_PROG | Sponsored Program | ||||
| rsponsored_class | GM_SPONSORED_CLASS | Sponsored Class | ||||
| rbdgt_vldty_nbr | GM_BDGT_VLDTY_NBR | Bdgt Validty No. | ||||
| kblnr | KBLNR_FI | Earmarked funds | ||||
| kblpos | KBLPOS | Document Item | ||||
| fs_product_group | FFS_PRODUCT_GROUP | Product Group (FS) | ||||
| branch_id | FFS_BRANCH_ID | Branch (FS) | ||||
| datasource_id | FFS_DATASOURCE_ID | Data Source | ||||
| vname | JV_NAME | Joint venture | ||||
| egrup | JV_EGROUP | Equity group | ||||
| recid | JV_RECIND | Recovery Ind. | ||||
| vptnr | JV_PART | Partner | ||||
| btype | JV_BILIND | Billing ind. | ||||
| etype | JV_ETYPE | Equity Type | ||||
| prodper | JV_PRODPER | Prod.Month | ||||
| billm | JV_BILLM | Billing Month | ||||
| pom | JV_POM | Proc.Oper.Month | ||||
| cbrunid | JV_CBRUNID | Cutback Run ID (JVA) | ||||
| jvactivity | JV_ACTIVITY | JVA Activity | ||||
| pvname | JV_PVNAME | Partner Venture JVA | ||||
| pegrup | JV_PEGRUP | Partner EG (JVA) | ||||
| s_recind | JV_SRECIND | Sender Rec. Ind | ||||
| cbracct | JV_CBRACCT | Cutback Account JVA | ||||
| cbobjnr | JV_CBOBJNR | Cutback CO (JVA) | ||||
| swenr | REBDBENO | Business Entity | ||||
| sgenr | REBDBUNO | Building | ||||
| sgrnr | REBDPRNO | Land | ||||
| smenr | REBDRONO | Rental Object | ||||
| recnnr | RECNNUMBER | Contract | ||||
| snksl | RESCSCKEY | Srv. Charge Key | ||||
| sempsl | RESCSUID | Settlement Unit | ||||
| dabrz | DABRBEZ | Reference date | ||||
| pswenr | FINS_PAR_SWENR | Ptnr. Bus. Entity | ||||
| psgenr | FINS_PAR_SGENR | Ptnr. Building | ||||
| psgrnr | FINS_PAR_SGRNR | Partner Land | ||||
| psmenr | FINS_PAR_SMENR | Ptnr. Rent. Unit | ||||
| precnnr | FINS_PAR_RECNNR | Ptnr. Contract No. | ||||
| psnksl | FINS_PAR_SNKSL | Ptnr. Srv. Chrg. Key | ||||
| psempsl | FINS_PAR_SEMPSL | Ptnr. Sett. Unit | ||||
| pdabrz | FINS_PAR_DABRBEZ | Ptnr. Reference Date | ||||
| acrobjtype | ACR_OBJ_TYPE | Accrual Object Type | ||||
| acrlogsys | ACR_LOGSYS | Logical Syst. AcrObj | ||||
| acrobj_id | ACR_OBJ_ID | Accrual Object | ||||
| acrsobj_id | ACR_SUBOBJ_ID | Accrual Subobject | ||||
| acritmtype | ACR_ITEM_TYPE | Accrual Item Type | ||||
| acrrefobj_id | ACR_REFOBJ_ID | Acr. Reference ID | ||||
| acrvaldat | ACR_VALUE_DATE | Accrual Value Date | ||||
| valobjtype | VAL_OBJ_TYPE | Type of Fin.Val.Obj. | ||||
| valobj_id | VAL_OBJ_ID | Fin Valuation Object | ||||
| valsobj_id | VAL_SUBOBJ_ID | Fin.Val.Sub.Object | ||||
| netdt | NETDT | Due On | ||||
| risk_class | UKM_RISK_CLASS | Risk Class | ||||
| acdoc_eew_dummy | CFD_DUMMY | Dummy | ||||
| dummy_incl_eew_cobl | CFD_DUMMY | Dummy | ||||
| fup_action | FINS_ACDOC_FOLLOW_UP_ACTION | Follow-up action | ||||
| sdm_version | FINS_SDM_VERSION_ACDOCA | SDM Versioning | ||||
| mig_source | FINS_ACDOC_MIG_SOURCE | Migr. Source | ||||
| mig_docln | FINS_MIG_DOCLN | Migr. Line Item ID | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging |
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.
-- Universal Journal: Temporary Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACDOCTEMP (
RCLNT, -- Client [MANDT]
TEMP_APPL, -- Application [FINS_ACDOCTEMP_APPL]
TEMP_ID, -- Temp. Data ID [FINS_ACDOCTEMP_ID]
RLDNR, -- Ledger [FINS_LEDGER]
RBUKRS, -- Company Code [BUKRS]
GJAHR, -- Fiscal Year [GJAHR]
BELNR, -- Document Number [BELNR_D]
DOCLN, -- G/L Line Item [DOCLN6]
RYEAR, -- G/L Fiscal Year [GJAHR_POS]
DOCNR_LD, -- Ledger spec. DocNo [FINS_DOCNR_LD]
RRCTY, -- Record Type [RRCTY]
RMVCT, -- Transact. Type [RMVCT]
VORGN, -- Transact. Type [VORGN]
VRGNG, -- Bus.Transaction [CO_VORGANG]
BTTYPE, -- Bus. Trans. Category [FINS_BTTYPE]
CBTTYPE, -- Bus. Trans. Type [FINS_CUSTBTTYPE]
CLOSINGSTEP, -- Closing Step [FINS_CLOSINGSTEP]
AWTYP, -- Ref. procedure [AWTYP]
AWSYS, -- Logical System [AWSYS]
AWORG, -- Refer. Org.Unit [AWORG]
AWREF, -- Reference Doc. [AWREF]
AWITEM, -- Ref. Doc. Item [FINS_AWITEM]
AWITGRP, -- Ref. Item Group [FINS_AWITGRP]
SUBTA, -- Sub Transaction [FINS_SUBTA]
ACCTG_NOTIF_UUID, -- Accounting Notification UUID [FAN_HDR_TECHNICAL_ID]
OFFSTG_DOCLN, -- Offst Entry Itm [DOCLN6_OFFSETTING]
XREVERSING, -- Is Reversing [FINS_XREVERSING]
XREVERSED, -- Is Reversed [FINS_XREVERSED]
XTRUEREV, -- Is true reversal [FINS_XTRUEREV]
AWTYP_REV, -- ReversalRefTran [AWTYP_REV]
AWORG_REV, -- Reversal Org. [AWORG_REV]
AWREF_REV, -- Reversal Ref. [AWREF_REV]
AWITEM_REV, -- Reversal Ref.Doc. LI [AWITEM_REV]
SUBTA_REV, -- Reversal Sub Trans [FINS_SUBTA_REV]
XSETTLING, -- Is Settling [FINS_XSETTLING]
XSETTLED, -- Is Settled [FINS_XSETTLED]
PREC_AWTYP, -- PrecRefTransact [FINS_PREC_AWTYP]
PREC_AWSYS, -- PrecRefLogSys [FINS_PREC_AWSYS]
PREC_AWORG, -- PrecRefOrgUnit [FINS_PREC_AWORG]
PREC_AWREF, -- PrecRefDocument [FINS_PREC_AWREF]
PREC_AWITEM, -- Prec. Ref. Doc. Item [FINS_PREC_AWITEM]
PREC_SUBTA, -- Prec. Sub Transactn [FINS_PREC_SUBTA]
PREC_AWMULT, -- MultPrecRefID [FINS_PREC_AWMULT_UUID]
PREC_BUKRS, -- PrecJE CoCode [FINS_PREC_BUKRS]
PREC_GJAHR, -- PrecJE Year [FINS_PREC_GJAHR]
PREC_BELNR, -- PrecJE DocNo [FINS_PREC_BELNR]
PREC_DOCLN, -- PrecJE LineItem [FINS_PREC_DOCLN]
XSECONDARY, -- Secondary entry [FINS_SECONDARY_ENTRY]
CLOSING_RUN_ID, -- Closing Run UUID [CLS_RUN_ID]
ORGL_CHANGE, -- Organizational Change [FINOC_ORGL_CHANGE]
SRC_AWTYP, -- Src Doc Type [FINS_SRC_AWTYP]
SRC_AWSYS, -- Src Doc Sys [FINS_SRC_AWSYS]
SRC_AWORG, -- Source Org Unit [FINS_SRC_AWORG]
SRC_AWREF, -- Source Doc. No. [FINS_SRC_AWREF]
SRC_AWITEM, -- Source Doc. LineItem [FINS_SRC_AWITEM]
SRC_AWSUBIT, -- Source Doc. Subitem [FINS_SRC_AWSUBIT]
XCOMMITMENT, -- Commitment [FINS_XCOMMITMENT]
OBS_REASON, -- Obsolete Reason [FINS_OBSOLETE_ITEM_REASON]
RTCUR, -- Bal. Transac. Crcy [FINS_CURRT]
RWCUR, -- Transaction Currency [FINS_CURRW]
RHCUR, -- CompanyCode Currency [FINS_CURRH]
RKCUR, -- Global Currency [FINS_CURRK]
RFCCUR, -- Functional Currency [FINS_CURRFC]
ROCUR, -- Free Defined Crcy 1 [FINS_CURR1]
RVCUR, -- Free Defined Crcy 2 [FINS_CURR2]
RBCUR, -- Free Defined Crcy 3 [FINS_CURR3]
RCCUR, -- Free Defined Crcy 4 [FINS_CURR4]
RDCUR, -- Free Defined Crcy 5 [FINS_CURR5]
RECUR, -- Free Defined Crcy 6 [FINS_CURR6]
RFCUR, -- Free Defined Crcy 7 [FINS_CURR7]
RGCUR, -- Free Defined Crcy 8 [FINS_CURR8]
RCO_OCUR, -- CO Object Currency [FINS_CO_OCUR]
RGM_OCUR, -- Grant Currency [GM_GRANT_CURRENCY]
RUNIT, -- Base Unit [MEINS]
RVUNIT, -- Valuation UoM [RVUNIT]
RRUNIT, -- Reference UoM [RRUNIT]
RMSL_TYPE, -- Ref. Quantity Type [FINS_RMSL_QTY_TYPE_CODE]
RIUNIT, -- Inventory UoM [FINS_RIUNIT]
QUNIT1, -- Add Unit Meas 1 [FCO_QUNIT1]
QUNIT2, -- Add Unit Meas 2 [FCO_QUNIT2]
QUNIT3, -- Add Unit Meas 3 [FCO_QUNIT3]
CO_MEINH, -- UoM COValQty [FCO_MEINH]
RACCT, -- Account Number [RACCT]
RCNTR, -- Cost Center [KOSTL]
PRCTR, -- Profit Center [PRCTR]
RFAREA, -- Functional Area [FKBER]
RBUSA, -- Business Area [GSBER]
KOKRS, -- CO Area [KOKRS]
SEGMENT, -- Segment [FB_SEGMENT]
SCNTR, -- Sender Cost Ctr [SKOST]
PPRCTR, -- Partner PC [PPRCTR]
SFAREA, -- Partner FArea [SFKBER]
SBUSA, -- Trdg Part.BA [PARGB]
RASSC, -- Trading Partner [RASSC]
PSEGMENT, -- Partner Segment [FB_PSEGMENT]
TSL, -- Amnt in Bal Tr Crcy [FINS_VTCUR12]
WSL, -- Amnt in Trans. Crcy [FINS_VWCUR12]
WSL2, -- GV Amnt in TransCrcy [FINS_VWCUR12_2]
WSL3, -- PCV Amnt in TrnsCrcy [FINS_VWCUR12_3]
HSL, -- Amnt in Comp Cd Crcy [FINS_VHCUR12]
KSL, -- Amnt in Global Crcy [FINS_VKCUR12]
FCSL, -- Amount in FunctCrcy [FINS_VFCCUR12]
OSL, -- Amount in Currency 1 [FINS_VOCUR12]
VSL, -- Amount in Currency 2 [FINS_VVCUR12]
BSL, -- Amount in Currency 3 [FINS_VBCUR12]
CSL, -- Amount in Currency 4 [FINS_VCCUR12]
DSL, -- Amount in Currency 5 [FINS_VDCUR12]
ESL, -- Amount in Currency 6 [FINS_VECUR12]
FSL, -- Amount in Currency 7 [FINS_VFCUR12]
GSL, -- Amount in Currency 8 [FINS_VGCUR12]
KFSL, -- Fixed Amnt in GC [FINS_VGCUR12_FIX]
KFSL2, -- GV Fixd Amt Glb Crcy [FINS_VGCUR12_FIX2]
KFSL3, -- PCV FixdAmt Glb Crcy [FINS_VGCUR12_FIX3]
PSL, -- Price Variance [FINS_VPCUR12]
PSL2, -- GVal TPrice Varc GC [FINS_VPCUR12_2]
PSL3, -- PCVal TPrice Varc GC [FINS_VPCUR12_3]
PFSL, -- Price Var. Fxd [FINS_VPFCUR12]
PFSL2, -- GVal FPrice Varc GC [FINS_VPFCUR12_2]
PFSL3, -- PCVal FPrice Varc GC [FINS_VPFCUR12_3]
CO_OSL, -- Amount in Obj Crcy [FINS_VCO_OCUR12]
GM_OSL, -- Amount in Grant Crcy [GM_GRANT_AMOUNT]
HSLALT, -- AltValue LC [MLHSLALT]
KSLALT, -- AltValue GC [MLKSLALT]
OSLALT, -- AltValue in Crcy 1 [MLOSLALT]
VSLALT, -- AltValue in Crcy 2 [ML4SLALT]
BSLALT, -- AltValue in Crcy 3 [MLBSLALT]
CSLALT, -- AltValue in Crcy 4 [MLCSLALT]
DSLALT, -- AltValue in Crcy 5 [MLDSLALT]
ESLALT, -- AltValue in Crcy 6 [MLESLALT]
FSLALT, -- AltValue in Crcy 7 [MLFSLALT]
GSLALT, -- AltValue in Crcy 8 [MLGSLALT]
HSLEXT, -- ExtValue LC [MLHSLEXT]
KSLEXT, -- ExtValue GC [MLKSLEXT]
OSLEXT, -- ExtValue in Crcy 1 [MLOSLEXT]
VSLEXT, -- ExtValue in Crcy 2 [ML4SLEXT]
BSLEXT, -- ExtValue in Crcy 3 [MLBSLEXT]
CSLEXT, -- ExtValue in Crcy 4 [MLCSLEXT]
DSLEXT, -- ExtValue in Crcy 5 [MLDSLEXT]
ESLEXT, -- ExtValue in Crcy 6 [MLESLEXT]
FSLEXT, -- ExtValue in Crcy 7 [MLFSLEXT]
GSLEXT, -- ExtValue in Crcy 8 [MLGSLEXT]
HVKWRT, -- Value SP LCrcy [MLHVKWRT]
MSL, -- Quantity [QUAN1_12]
MFSL, -- Fixed quantity [QUAN1_12_FIX]
VMSL, -- Val. quantity [VQUAN1_12]
VMFSL, -- Fixed val. qty [VQUAN1_12_FIX]
RMSL, -- Ref. quantity [RQUAN1_12]
QUANT1, -- Add. Quantity 1 [FCO_QUAN1_L]
QUANT2, -- Add. Quantity 2 [FCO_QUAN2_L]
QUANT3, -- Add. Quantity 3 [FCO_QUAN3_L]
CO_MEGBTR, -- COValQty [FCO_MEGBTR]
CO_MEFBTR, -- COValQtyFix [FCO_MEFBTR]
HSALK3, -- InvValue LCrcy [MLHSALK3]
KSALK3, -- InvValue GCrcy [MLKSALK3]
OSALK3, -- InvValue FDC 1 [MLOSALK3]
VSALK3, -- InvValue FDC 2 [ML4SALK3]
HSALKV, -- AltInvValue LC [MLHSALKV]
KSALKV, -- AltInvValue GC [MLKSALKV]
OSALKV, -- AltInvV FDC 1 [MLOSALKV]
VSALKV, -- AltInvV FDC 2 [ML4SALKV]
HPVPRS, -- MAP LCrcy [MLHPVPRS]
KPVPRS, -- MAP GCrcy [MLKPVPRS]
OPVPRS, -- MAP ACrcy [MLOPVPRS]
VPVPRS, -- MAP 4Crcy [ML4PVPRS]
HSTPRS, -- StdPrice LCrcy [MLHSTPRS]
KSTPRS, -- StdPrice GCrcy [MLKSTPRS]
OSTPRS, -- StdPrice ACrcy [MLOSTPRS]
VSTPRS, -- StdPrice 4Crcy [ML4STPRS]
HVKSAL, -- InvVal SP LCrcy [MLHVKSAL]
LBKUM, -- Inv. Quantity [MLLBKUM]
DRCRK, -- Debit/Credit [SHKZG]
POPER, -- Posting Period [POPER]
PERIV, -- FY Variant [PERIV]
FISCYEARPER, -- Period/Year [JAHRPER]
BUDAT, -- Posting Date [BUDAT]
BLDAT, -- Document Date [BLDAT]
BLART, -- Document Type [BLART]
BUZEI, -- Item [BUZEI]
ZUONR, -- Assignment [DZUONR]
BSCHL, -- Posting Key [BSCHL]
BSTAT, -- Document Status [BSTAT_D]
BUS_TRANS_ITEM_CATEGORY, -- Business Transaction Item Category [FINS_BUS_TRANS_ITEM_CATEGORY]
LINETYPE, -- Item Category [LINETYPE]
KTOSL, -- Transaction [KTOSL]
SLALITTYPE, -- SLALineItemType [SLALITTYPE]
XSPLITMOD, -- Changed [XSPLITMOD]
USNAM, -- User Name [USNAM]
TIMESTAMP, -- Creation Time [FIS_CREA_TSTAMP]
LAST_CHANGE_DATETIME, -- Last Changed At [FIS_CHNG_TSTAMP]
EPRCTR, -- Elimination PrCtr [EPRCTR]
RHOART, -- Origin object [HOART]
GLACCOUNT_TYPE, -- G/L Account Type [GLACCOUNT_TYPE]
KTOPL, -- Chart of Accts [KTOPL]
LOKKT, -- Altern. Account [ALTKT_SKB1]
KTOP2, -- Alternative COA [KTOP2]
RBUNIT, -- Consolidation Unit [FINCS_MD_BUNIT]
RBUPTR, -- Partner Unit [FINCS_MD_BUPTR]
RCOMP, -- Company [RCOMP_D]
RITCLG, -- Cons. COA [FC_ITCLG]
RITEM, -- FS Item [FINCS_FSI_ITEM]
SITYP, -- Subitem Category [FC_SITYP]
SUBIT, -- Subitem [FC_SITEM]
REBZG, -- Invoice Ref. [REBZG]
REBZJ, -- Fiscal Year [REBZJ]
REBZZ, -- Item [REBZZ]
REBZT, -- Follow-On Doc. Type [REBZT]
RBEST, -- PO Category [CO_RBEST]
EBELN_LOGSYS, -- LogSys of PurchDoc [EBELN_LOGSYS]
EBELN, -- Purchasing Doc. [EBELN]
EBELP, -- Item [EBELP]
ZEKKN, -- Account Assgmt No. [DZEKKN]
SGTXT, -- Text [SGTXT]
KDAUF, -- Sales Order [KDAUF]
KDPOS, -- Sales Ord. Item [KDPOS]
MATNR, -- Material [MATNR]
WERKS, -- Plant [WERKS_D]
LIFNR, -- Supplier [LIFNR]
KUNNR, -- Customer [KUNNR]
FBUDA, -- Serv. Rend. Dte [FBUDA]
PEROP_BEG, -- Per. of Perf. Start [FM_PEROP_FI_LOW]
PEROP_END, -- Per. of Perf. End [FM_PEROP_FI_HIGH]
COCO_NUM, -- Condition Contract [WCB_COCO_NUM]
WWERT, -- Translatn Date [WWERT_D]
PRCTR_DRVTN_SOURCE_TYPE, -- Profit Center Source [FINOC_PRCTR_DRVTN_SOURCE_TYPE]
UCB_ID, -- Breakdown ID [FUCB_ID]
UCB_SCALE_NUMERATOR, -- Scale Numerator [FUCB_SCALE_NUMERATOR]
KOART, -- Account type [KOART]
UMSKZ, -- Special G/L Ind [UMSKZ]
TAX_COUNTRY, -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
MWSKZ, -- Tax Code [MWSKZ]
HBKID, -- House Bank [HBKID]
HKTID, -- Account ID [HKTID]
VALUT, -- Value date [VALUT]
XOPVW, -- OI Management [XOPVW]
AUGDT, -- Clearing [AUGDT]
AUGBL, -- Clrng doc. [AUGBL]
AUGGJ, -- Clrg Fiscal Yr [AUGGJ]
OI_REF_TYPE, -- Open Item Ref Type [FINS_OI_REF_TYPE]
OI_REF_ID, -- Open Item Ref ID [FINS_OI_REF_ID]
AGING, -- Aging [FINS_AGING]
AGING_INCRMNT, -- Increment [FINS_INCRMNT]
AFABE, -- Deprec. Area [AFABER]
ANLN1, -- Asset [ANLN1]
ANLN2, -- Sub-number [ANLN2]
BZDAT, -- Asset Val. Date [BZDAT]
ANBWA, -- Ast Transaction Type [ANBWA]
MOVCAT, -- Trans.Type Cat. [FAA_MOVCAT]
DEPR_PERIOD, -- Deprec. Period [PERAF]
ANLGR, -- Group Asset [ANLGR]
ANLGR2, -- Subnumber [ANLGR2]
SETTLEMENT_RULE, -- Distr. Rule Grp [BUREG]
ANLKL, -- Asset Class [ANLKL]
KTOGR, -- Account Determ. [KTOGR]
PANL1, -- Partner Asset [PANL1]
PANL2, -- Partner Sub-No. [PANL2]
ANLN2_PN, -- Asset Subnumber [ANLN2_PN]
BWASL_PN, -- Trans. Type [BWASL]
BZDAT_PN, -- Asset Val. Date [BZDAT_PN]
UBZDT_PN, -- Orig. Val. Dat [UBZDT]
XVABG_PN, -- Compl.Retiremnt [XVABG]
ANBTR_PN, -- Amount Posted [ANBTR]
PROZS_PN, -- Percentage Rate [PROZS]
XMANPROPVAL_PN, -- Man. Proport. Values [XMANPROPVAL]
KALNR, -- Cost EstimateNo [CK_KALNR]
VPRSV, -- Price control [VPRSV]
MLAST, -- Price Determ. [CK_ML_ABST]
KZBWS, -- Valuation [MLKZBWS]
XOBEW, -- Vendor stk val. [MLXOBEW]
SOBKZ, -- Special Stock [SOBKZ]
VTSTAMP, -- Valu. TimeStamp [VTIMESTAMPL]
MAT_KDAUF, -- SD Doc of Inv. [MLMAT_KDAUF]
MAT_KDPOS, -- SD Item of Inv. [MLMAT_KDPOS]
MAT_PSPNR, -- WBSElem of Inv. [MLMAT_PSPNR]
MAT_PS_POSID, -- WBSElem of Inv. [MLMAT_PS_POSID]
MAT_LIFNR, -- Vendor of Inv. [MLMAT_LIFNR]
BWTAR, -- Valuation Type [BWTAR_D]
BWKEY, -- Valuation Area [BWKEY]
HPEINH, -- Price Unit LC [MLHPEINH]
KPEINH, -- Price Unit GC [MLKPEINH]
OPEINH, -- Price Unit AC [MLOPEINH]
VPEINH, -- Price Unit 4C [ML4PEINH]
MLPTYP, -- Orig. proc.cat. [ML_PTYP_ORG]
MLCATEG, -- Category [ML_KATEGORIE]
QSBVALT, -- PrcrmntAlt/proc [ML_QSBVALT]
QSPROCESS, -- Prod. Proc. No. [ML_QSPROCESS]
PERART, -- Period Type [ML_PER_ART]
MLPOSNR, -- Item [ML_MLPOS]
INV_MOV_CATEG, -- Inv Movement Categ [FBV_INV_MOV_CATEG]
BUKRS_SENDER, -- Sender CoCode [BUKRS_SENDER]
RACCT_SENDER, -- Sender GL Account [RACCT_SENDER]
ACCAS_SENDER, -- Sender Acct Assgmt [ACCAS_SENDER]
ACCASTY_SENDER, -- Sndr AcctAssgmt Type [ACCASTY_SENDER]
OBJNR, -- Object number [J_OBJNR]
HRKFT, -- CO subkey [CO_SUBKEY]
HKGRP, -- Origin Group [HRKFT]
PAROB1, -- Partner Object [PAROB1]
PAROBSRC, -- ParObj Source [FINS_PAROB_SRC]
USPOB, -- Source Object [USPOB]
CO_BELKZ, -- Dr/Cr ind. CO [FINS_CO_BELKZ]
CO_BEKNZ, -- Dr/Cr (Origin) [FINS_CO_BEKNZ]
BELTP, -- Debit Type [BP_INOUT]
MUVFLG, -- Qty Is Incomplete [FCO_MUV_CODE]
GKONT, -- Offsetting Acct [GKONT]
GKOAR, -- Offst.Acct Type [GKOAR]
ERLKZ, -- Item Completed [KBLERLKZ]
PERNR, -- Personnel No. [PERNR_D]
PAOBJNR, -- Profit. segment [RKEOBJNR]
PROF_SEG_TYPE, -- Prof. Segment Type [FINS_PROF_SEG_TYPE]
XPAOBJNR_CO_REL, -- PAObj is CO relevant [FINS_XPAOBJNR_CO_REL]
SCOPE, -- Object Class [SCOPE_CV]
LOGSYSO, -- Logical System [LOGSYSO]
PBUKRS, -- Partner CoCode [PBUKRS]
PSCOPE, -- PartnerObjClass [PSCOPE_CV]
LOGSYSP, -- Logical system [LOGSYSP]
BWSTRAT, -- Val.strategy [BWSTRAT]
OBJNR_HK, -- Origin object [OBJNR_HK]
AUFNR_ORG, -- Origin Order [AUFNR_HK]
UKOSTL, -- OrigCCtr [USP_KOSTL]
ULSTAR, -- OrigAct. [USP_LSTAR]
UPRZNR, -- Sce: BProc. [USP_PRZNR]
UPRCTR, -- Origin Profit Center [FINS_ORIGIN_PRCTR]
UMATNR, -- Origin Material [FINS_ORIGIN_MATNR]
VARC_UACCT, -- Varc. Origin Account [FINS_VARC_ORIGIN_ACCT]
VARC_HKGRP, -- Varc. Origin Group [FINS_VARC_ORIGIN_GROUP]
ACCAS, -- Account Assignment [ACCAS]
ACCASTY, -- Object Type [J_OBART]
LSTAR, -- Activity Type [LSTAR]
AUFNR, -- Order [AUFNR]
AUTYP, -- Order category [AUFTYP]
PS_PSP_PNR, -- WBS Element [PS_PSP_PNR]
PS_POSID, -- WBS Element [PS_POSID]
PS_PRJ_PNR, -- Project def. [PS_INTNR]
PS_PSPID, -- Project def. [PS_PSPID]
NPLNR, -- Network [NPLNR]
NPLNR_VORGN, -- Netwk activity [NPVRG]
PRZNR, -- Business Process [CO_PRZNR]
KSTRG, -- Cost Object [KSTRG]
BEMOT, -- AcctIndicator [BEMOT]
RSRCE, -- Resource [CO_RESSOURCE]
QMNUM, -- Notification [QMNUM]
SERVICE_DOC_TYPE, -- Service Doc. Type [FCO_SRVDOC_TYPE]
SERVICE_DOC_ID, -- Service Document [FCO_SRVDOC_ID]
SERVICE_DOC_ITEM_ID, -- Service Doc. Item [FCO_SRVDOC_ITEM_ID]
SERVICE_CONTRACT_TYPE, -- Serv. Contract Type [FCO_SRVCONTRACT_TYPE]
SERVICE_CONTRACT_ID, -- Service Contract [FCO_SRVCONTRACT_ID]
SERVICE_CONTRACT_ITEM_ID, -- Srv Contract Item [FCO_SRVCONTRACT_ITEM_ID]
SOLUTION_ORDER_ID, -- Solution Order [FCO_SOLUTION_ORDER_ID]
SOLUTION_ORDER_ITEM_ID, -- Solution Order Item [FCO_SOLUTION_ORDER_ITEM_ID]
VTKEY, -- Contract [VTKEY_KK]
VTPOS, -- Contract Item [VTPOS_KK]
RA_CONTRACT_ID, -- Contract [FARR_CONTRACT_ID]
RA_POB_ID, -- POB [FARR_POB_ID]
ERKRS, -- Operating concern [ERKRS]
PACCAS, -- Part. Acct Assgmt [PACCAS]
PACCASTY, -- Prt.object type [CO_POBART]
PLSTAR, -- ParActvy [PAR_LSTAR]
PAUFNR, -- Partner order [PAR_AUFNR]
PAUTYP, -- Prtnr Ord. Cat. [FCO_PAR_AUFTYP]
PPS_PSP_PNR, -- Partner WBS Element [FCO_PAR_PSP_PNR]
PPS_POSID, -- Partner WBS Element [FCO_PAR_POSID]
PPS_PRJ_PNR, -- Partner Project Def. [FCO_PAR_PRJ_PNR]
PPS_PSPID, -- Part. Proj. Def [FCO_PAR_PSPID]
PKDAUF, -- Partner SalOrd [PAR_KDAUF]
PKDPOS, -- Part. SlsOrd Item [PAR_KDPOS]
PPAOBJNR, -- PartnerPrf.Seg. [RKEPOBJ]
PNPLNR, -- Part. Proj. Network [PAR_NPLN]
PNPLNR_VORGN, -- Part.Proj.Ntwk.Acty [PAR_VORNR_AUF]
PPRZNR, -- Part. Bus. Process [PAR_PRZNR]
PKSTRG, -- Partner Cost Object [PAR_KSTRG]
PSERVICE_DOC_TYPE, -- Par. Service DocType [FCO_PSRVDOC_TYPE]
PSERVICE_DOC_ID, -- Partner Service Doc. [FCO_PSRVDOC_ID]
PSERVICE_DOC_ITEM_ID, -- Par. Service DocItem [FCO_PSRVDOC_ITEM_ID]
CO_ACCASTY_N1, -- Stat. AcctAss.Type 1 [FINS_ACCASTY_N1]
CO_ACCASTY_N2, -- Stat. AcctAss.Type 2 [FINS_ACCASTY_N2]
CO_ACCASTY_N3, -- Stat. AcctAss.Type 3 [FINS_ACCASTY_N3]
CO_ZLENR, -- Item [DZLENR]
CO_BELNR, -- Document Number [CO_BELNR]
CO_BUZEI, -- Posting Row [CO_BUZEI]
CO_BUZEI1, -- CO PostingRow 1 [FCO_BUZEI1]
CO_BUZEI2, -- CO PostingRow 2 [FCO_BUZEI2]
CO_BUZEI5, -- CO PostingRow 5 [FCO_BUZEI5]
CO_BUZEI6, -- CO PostingRow 6 [FCO_BUZEI6]
CO_BUZEI7, -- CO PostingRow 7 [FCO_BUZEI7]
CO_REFBZ, -- Posting Row [CO_REFBZ]
CO_REFBZ1, -- RefPostRow 1 [FCO_REFBZ1]
CO_REFBZ2, -- RefPostRow 2 [FCO_REFBZ2]
CO_REFBZ5, -- RefPostRow 5 [FCO_REFBZ5]
CO_REFBZ6, -- RefPostRow 6 [FCO_REFBZ6]
CO_REFBZ7, -- RefPostRow 7 [FCO_REFBZ7]
OVERTIMECAT, -- Overtime Category [CATS_OVERTIME_CATEGORY]
WORK_ITEM_ID, -- Work Item ID [/CPD/PFP_WORKITEM_ID]
ARBID, -- Object ID [CR_OBJID]
VORNR, -- Activity [VORNR]
AUFPS, -- Item Number [CO_POSNR]
UVORN, -- Suboperation [UVORN]
EQUNR, -- Equipment [EQUNR]
TPLNR, -- Functional loc. [TPLNR]
ISTRU, -- Assembly [ISTRU]
ILART, -- MaintActivType [ILA]
PLKNZ, -- OrderPlanInd. [AUF_PLKNZ]
ARTPR, -- PriorityType [ARTPR]
PRIOK, -- Priority [PRIOK]
MAUFNR, -- Superior Order [MAUFNR]
MATKL_MM, -- Material Group [FINS_MATKL_MM]
PAUFPS, -- Partner Order item [FCO_PAR_AUFPS]
VORNR_ORG, -- Origin Operation [FINS_ORIGIN_OPERATION]
PLANNED_PARTS_WORK, -- Planned Parts/Work [FINS_PLANNED_PARTS_WORK]
FKART, -- Billing Type [FKART]
VKORG, -- Sales Org. [VKORG]
VTWEG, -- Distr. Channel [VTWEG]
SPART, -- Division [SPART]
MATNR_COPA, -- Product Sold [FINS_MATNR_PA]
MATKL, -- Product Sold Group [FINS_MATKL_PA]
KDGRP, -- Customer Group [KDGRP]
LAND1, -- Country/Region [COBL_LAND1_GP]
BRSCH, -- Industry [BRSCH]
BZIRK, -- Sales District [BZIRK]
KUNRE, -- Bill-to Party [KUNRE]
KUNWE, -- Ship-to Party [KUNWE]
KONZS, -- Group [KONZS]
ACDOC_COPA_EEW_DUMMY_PA, -- Dummy function in length 1 [DUMMY]
DUMMY_MRKT_SGMNT_EEW_PS, -- Dummy [CFD_DUMMY]
RE_BUKRS, -- Cash Origin CoCode [FIS_RE_BUKRS]
RE_ACCOUNT, -- Cash Origin Account [FIS_RE_ACCOUNT]
FIKRS, -- FM Area [FIKRS]
FIPEX, -- Commitment Item [FM_FIPEX]
FISTL, -- Funds Center [FISTL]
MEASURE, -- Funded Program [FM_MEASURE]
RFUND, -- Fund [BP_GEBER]
RGRANT_NBR, -- Grant [GM_GRANT_NBR]
RBUDGET_PD, -- Budget Period [FM_BUDGET_PERIOD]
SFUND, -- Partner Fund [BP_P_GEBER]
SGRANT_NBR, -- Partner Grant [GM_GRANT_PARTNER]
SBUDGET_PD, -- Par. BudPer [FM_PBUDGET_PERIOD]
BDGT_ACCOUNT, -- Budget Account [PSM_BDGT_ACCOUNT]
BDGT_ACCOUNT_COCODE, -- Company Code for Budget Account [PSM_BDGT_ACCOUNT_COCODE]
BDGT_CNSMPN_DATE, -- Budget Consumption Date [PSM_BDGT_CNSMPN_DATE]
BDGT_CNSMPN_PERIOD, -- Posting Period for Budget Consumption [PSM_BDGT_CNSMPN_PERIOD]
BDGT_CNSMPN_YEAR, -- Year of Budget Consumption [PSM_BDGT_CNSMPN_YEAR]
BDGT_RELEVANT, -- Budget-Relevant [PSM_BDGT_RELEVANT]
BDGT_CNSMPN_TYPE, -- Budget Consumption Type [PSM_BDGT_CNSMPN_TYPE]
BDGT_CNSMPN_AMOUNT_TYPE, -- Amount Type for Budget Consumption [PSM_BDGT_CNSMPN_AMOUNT_TYPE]
RSPONSORED_PROG, -- Sponsored Program [GM_SPONSORED_PROG]
RSPONSORED_CLASS, -- Sponsored Class [GM_SPONSORED_CLASS]
RBDGT_VLDTY_NBR, -- Bdgt Validty No. [GM_BDGT_VLDTY_NBR]
KBLNR, -- Earmarked funds [KBLNR_FI]
KBLPOS, -- Document Item [KBLPOS]
FS_PRODUCT_GROUP, -- Product Group (FS) [FFS_PRODUCT_GROUP]
BRANCH_ID, -- Branch (FS) [FFS_BRANCH_ID]
DATASOURCE_ID, -- Data Source [FFS_DATASOURCE_ID]
VNAME, -- Joint venture [JV_NAME]
EGRUP, -- Equity group [JV_EGROUP]
RECID, -- Recovery Ind. [JV_RECIND]
VPTNR, -- Partner [JV_PART]
BTYPE, -- Billing ind. [JV_BILIND]
ETYPE, -- Equity Type [JV_ETYPE]
PRODPER, -- Prod.Month [JV_PRODPER]
BILLM, -- Billing Month [JV_BILLM]
POM, -- Proc.Oper.Month [JV_POM]
CBRUNID, -- Cutback Run ID (JVA) [JV_CBRUNID]
JVACTIVITY, -- JVA Activity [JV_ACTIVITY]
PVNAME, -- Partner Venture JVA [JV_PVNAME]
PEGRUP, -- Partner EG (JVA) [JV_PEGRUP]
S_RECIND, -- Sender Rec. Ind [JV_SRECIND]
CBRACCT, -- Cutback Account JVA [JV_CBRACCT]
CBOBJNR, -- Cutback CO (JVA) [JV_CBOBJNR]
SWENR, -- Business Entity [REBDBENO]
SGENR, -- Building [REBDBUNO]
SGRNR, -- Land [REBDPRNO]
SMENR, -- Rental Object [REBDRONO]
RECNNR, -- Contract [RECNNUMBER]
SNKSL, -- Srv. Charge Key [RESCSCKEY]
SEMPSL, -- Settlement Unit [RESCSUID]
DABRZ, -- Reference date [DABRBEZ]
PSWENR, -- Ptnr. Bus. Entity [FINS_PAR_SWENR]
PSGENR, -- Ptnr. Building [FINS_PAR_SGENR]
PSGRNR, -- Partner Land [FINS_PAR_SGRNR]
PSMENR, -- Ptnr. Rent. Unit [FINS_PAR_SMENR]
PRECNNR, -- Ptnr. Contract No. [FINS_PAR_RECNNR]
PSNKSL, -- Ptnr. Srv. Chrg. Key [FINS_PAR_SNKSL]
PSEMPSL, -- Ptnr. Sett. Unit [FINS_PAR_SEMPSL]
PDABRZ, -- Ptnr. Reference Date [FINS_PAR_DABRBEZ]
ACROBJTYPE, -- Accrual Object Type [ACR_OBJ_TYPE]
ACRLOGSYS, -- Logical Syst. AcrObj [ACR_LOGSYS]
ACROBJ_ID, -- Accrual Object [ACR_OBJ_ID]
ACRSOBJ_ID, -- Accrual Subobject [ACR_SUBOBJ_ID]
ACRITMTYPE, -- Accrual Item Type [ACR_ITEM_TYPE]
ACRREFOBJ_ID, -- Acr. Reference ID [ACR_REFOBJ_ID]
ACRVALDAT, -- Accrual Value Date [ACR_VALUE_DATE]
VALOBJTYPE, -- Type of Fin.Val.Obj. [VAL_OBJ_TYPE]
VALOBJ_ID, -- Fin Valuation Object [VAL_OBJ_ID]
VALSOBJ_ID, -- Fin.Val.Sub.Object [VAL_SUBOBJ_ID]
NETDT, -- Due On [NETDT]
RISK_CLASS, -- Risk Class [UKM_RISK_CLASS]
ACDOC_EEW_DUMMY, -- Dummy [CFD_DUMMY]
DUMMY_INCL_EEW_COBL, -- Dummy [CFD_DUMMY]
FUP_ACTION, -- Follow-up action [FINS_ACDOC_FOLLOW_UP_ACTION]
SDM_VERSION, -- SDM Versioning [FINS_SDM_VERSION_ACDOCA]
MIG_SOURCE, -- Migr. Source [FINS_ACDOC_MIG_SOURCE]
MIG_DOCLN, -- Migr. Line Item ID [FINS_MIG_DOCLN]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
PRIMARY KEY (RCLNT, TEMP_APPL, TEMP_ID, RLDNR, RBUKRS, GJAHR, BELNR, DOCLN)
);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