Transcript
Field name RCLNT RLDNR RBUKRS GJAHR BELNR DOCLN RYEAR RRCTY RMVCT VORGN VRGNG BTTYPE AWTYP AWSYS AWORG AWREF AWITEM AWITGRP SUBTA XREVERSING XREVERSED XTRUEREV AWTYP_REV AWORG_REV AWREF_REV SUBTA_REV XSETTLING XSETTLED PREC_AWTYP PREC_AWORG PREC_AWREF PREC_AWITEM PREC_SUBTA RTCUR RWCUR RHCUR RKCUR ROCUR RVCUR RCO_OCUR RUNIT RVUNIT RRUNIT QUNIT1 QUNIT2 QUNIT3 RACCT RCNTR PRCTR RFAREA RBUSA KOKRS SEGMENT SCNTR PPRCTR SFAREA SBUSA RASSC PSEGMENT TSL WSL HSL KSL OSL VSL KFSL PSL PFSL CO_OSL HSALK3 KSALK3 OSALK3 VSALK3 HSALKV KSALKV OSALKV VSALKV HPVPRS KPVPRS OPVPRS
Description Client Ledger in General Ledger Accounting Company Code Fiscal Year Accounting Document Number Six-Character Posting Item for Ledger General Ledger Fiscal Year Record Type Transaction Type Transaction Type for General Ledger CO Business Transaction Business Transaction Type Reference Transaction Logical system of source document Reference Organizational Units Reference Document Number Reference Document Line Item Group of Reference Document Line Items Partial Document to be balanced to zero Indicator: Item is reversing another item Indicator: Item is reversed Indicator: True reversal (i.e. cancellation) Reversal: Reference Transaction of Document To Be Reversed Reversal: Reverse Document Reference Organization Reversal: Reverse Document Reference Document Number Reversal: Partial Document to be balanced to zero Indicator: Item is settling or transferring another item Indicator: Line item is settled or transferred Preceding Document Reference Transaction Preceding Document Reference Organizational Units Preceding Document Reference Document Number Preceding Reference Document Line Item Preceding Partial Document to be balanced to zero Currency Key Currency key of the original transaction currency Local Currency Controlling area currency Currency Key of Third Currency Currency Key of Fourth Currency Currency Key Base Unit of Measure Unit of Measure for Valuation Quantity Unit of Measure for Reference Quantity Additional Unit of Measure 1 Additional Unit of Measure 2 Additional Unit of Measure 3 Account Number Cost Center Profit Center Functional Area Business Area Controlling Area Segment for Segmental Reporting Sender cost center Partner Profit Center Partner Functional Area Trading Partner's Business Area Company ID of Trading Partner Partner Segment for Segmental Reporting Value in Transaction Currency Value in Original Transaction Currency (Document Currency) Value in Local Currency Value in Group Currency Value in Another Currency Amount in Fourth Currency Fixed Value in Group Currency Total Price Variance in Group Currency Fixed Price Variance in Group Currency Value in CO Object Currency Inventory Value in Local Currency Inventory Value in Group Currency Inventory Value in Another Currency Inventory Value in Fourth Currency Alternative Inventory Value in Local Currency Alternative Inventory Value in Group Currency Alternative Inventory Value in Another Currency Alternative Inventory Value in Fourth Currency Moving Average Price in Local Currency Moving Average Price in Group Currency Moving Average Price in Another Currency
FAGLFLEXA RCLNT RLDNR RBUKRS GJAHR BELNR DOCLN RYEAR RRCTY RMVCT VORGN ACTIV AWTYP LOGSYS
COEP MANDT
BSEG / BKPF MANDT
BUKRS GJAHR
BUKRS GJAHR BELNR
BEWAR VORGN VRGNG VRGNG AWTYP AWSYS AWKEY AWKEY REFBZ ZLENR STFLG STOKZ
VORGN AWTYP AWSYS AWKEY AWKEY
BKPF-XREVERSAL=2 BKPF-XREVERSAL=1
AWORG_REV AWREF_REV
RTCUR RWCUR
RUNIT
RACCT, COST_ELEM RCNTR PRCTR RFAREA RBUSA KOKRS SEGMENT SCNTR PPRCTR SFAREA SBUSA RASSC PSEGMENT TSL WSL HSL KSL OSL
TWAER
PSWSL
OWAER KWAER
H_HWAER / BKPF-HWAER H_HWAE2 / BKPF-HWAE2 H_HWAE3 / BKPF-HWAE3
OWAER MEINB MEINH QUNIT1 QUNIT2 QUNIT3 KSTAR KOSTL PRCTR FKBER KOKRS SEGMENT PKOSTL PPRCT PFKBER VBUND PSEGMENT WTGBTR WTGBTR WOGBTR WKGBTR
WKFBTR PAGBTR PAFBTR WOGBTR
MEINS
HKONT, KSTAR KOSTL PRCTR FKBER_LONG GSBER KOKRS SEGMENT PPRCT PFKBER PARGB VBUND PSEGMENT PSWBT WRBTR DMBTR DMBE2 DMBE3
Field name VPVPRS HSTPRS KSTPRS OSTPRS VSTPRS HSLALT KSLALT OSLALT VSLALT HSLEXT KSLEXT OSLEXT VSLEXT HVKWRT HVKSAL MSL MFSL VMSL VMFSL RMSL QUANT1 QUANT2 QUANT3 LBKUM DRCRK POPER PERIV FISCYEARPER BUDAT BLDAT BLART BUZEI ZUONR BSCHL BSTAT LINETYPE KTOSL SLALITTYPE XSPLITMOD USNAM TIMESTAMP EPRCTR RHOART GLACCOUNT_TYPE KTOPL LOKKT KTOP2 REBZG REBZJ REBZZ REBZT RBEST EBELN EBELP ZEKKN SGTXT KDAUF KDPOS MATNR WERKS LIFNR KUNNR KOART UMSKZ MWSKZ HBKID HKTID XOPVW AUGDT AUGBL AUGGJ AFABE ANLN1 ANLN2 BZDAT ANBWA MOVCAT DEPR_PERIOD ANLGR ANLGR2
Description Moving Average Price in Fourth Currency Standard Price in Local Currency Standard Price in Group Currency Standard Price in Another Currency Standard Price in Fourth Currency Alternative Value in Local Currency Alternative Value in Group Currency Alternative Value in Another Currency Alternative Value in Another Currency External Value in Local Currency External Value in Group Currency External Value in Another Currency External Value in Fourth Currency Value at Sales Price in Local Currency Inventory Value at Sales Price in Local Currency Quantity Fixed quantity Valuation quantity Fixed valuation quantity Reference quantity Additional Quantity 1 Additional Quantity 2 Additional Quantity 3 Inventory Quantity Debit/Credit Indicator Posting period Fiscal Year Variant Period/year Posting Date in the Document Document Date in Document Document Type Number of Line Item Within Accounting Document Assignment Number Posting Key Document Status Item category Transaction Key Subledger Account Line Item Type Code Item changed by document splitting User name UTC Time Stamp in Short Form (YYYYMMDDhhmmss) Partner profit center for elimination of internal business Type of origin object (EC-PCA) Type of a general ledger account Chart of Accounts Alternative Account Number in Company Code Chart of Accounts According to Country Legislation Number of the Invoice the Transaction Belongs to Fiscal Year of the Relevant Invoice (for Credit Memo) Line Item in the Relevant Invoice Follow-On Document Type Category of Reference Purchase Order Purchasing Document Number Item Number of Purchasing Document Sequential Number of Account Assignment Item Text Sales Order Number Item Number in Sales Order Material Number Plant Account Number of Vendor or Creditor Customer Number Account Type Special G/L Indicator Tax on sales/purchases code Short Key for a House Bank ID for Account Details Indicator: Open Item Management? Clearing Date Document Number of the Clearing Document Fiscal Year of Clearing Document Real depreciation area Main Asset Number Asset Subnumber Asset Value Date Asset Transaction Type Classification of Transaction Type Posting Period of Depreciation Group asset Subnumber of group asset
FAGLFLEXA
COEP
BSEG / BKPF
MSL
MBGBTR MBFBTR MEGBTR MEFBTR
MENGE
QUANT1 QUANT2 QUANT3 DRCRK POPER
PERIO
BUDAT
SHKZG H_MONAT / BKPF-MONAT
H_BUDAT / BKPF-BUDAT H_BLDAT / BKPF-BLDAT H_BLART / BKPF-BLART BUZEI ZUONR BSCHL H_BSTAT / BKPF-BSCHL
BUZEI BSCHL BSTAT LINETYPE
KTOSL XSPLITMOD USNAM TIMESTAMP
BKPF-CPUDT & CPUTM
LOKKT REBZG REBZJ REBZZ REBZT RBEST EBELN EBELP ZEKKN SGTXT VBELN VBPOSNR MATNR WERKS
EBELN EBELP ZEKKN SGTXT VBEL2 POSN2 MATNR WERKS LIFNR KUNNR KOART UMSKZ MWSKZ HBKID HKTID XOPVW AUGDT AUGBL AUGGJ ANLN1 ANLN2 BZDAT ANBWA
Field name SETTLEMENT_RULE KALNR VPRSV MLAST KZBWS XOBEW SOBKZ VTSTAMP MAT_KDAUF MAT_KDPOS MAT_PSPNR MAT_PS_POSID MAT_LIFNR BWTAR BWKEY HPEINH KPEINH OPEINH VPEINH MLPTYP MLCATEG QSBVALT QSPROCESS PERART RACCT_SENDER ACCAS_SENDER ACCASTY_SENDER OBJNR HRKFT HKGRP PAROB1 PAROBSRC USPOB CO_BELKZ CO_BEKNZ BELTP MUVFLG GKONT GKOAR ERLKZ PERNR PAOBJNR XPAOBJNR_CO_REL SCOPE LOGSYSO PBUKRS PSCOPE LOGSYSP BWSTRAT OBJNR_HK AUFNR_ORG UKOSTL ULSTAR UPRZNR ACCAS ACCASTY LSTAR AUFNR AUTYP PS_POSID PS_PSPID NPLNR NPLNR_VORGN PRZNR KSTRG BEMOT QMNUM ERKRS PACCAS PACCASTY PLSTAR PAUFNR PAUTYP PPS_POSID PPS_PSPID PKDAUF PKDPOS PPAOBJNR PNPLNR PNPLNR_VORGN PPRZNR
Description Distribution rule group Cost Estimate Number for Cost Est. w/o Qty Structure Price Control Indicator Material Price Determination: Control Valuation of Special Stock Vendor Stock Valuation Indicator Special Stock Indicator Valuation Time Stamp Sales Document Number of Valuated Special Inventory Sales Document Item Number of Valuated Special Inventory WBS Element (internal) of Valuated Special Inventory WBS Element (external) of Valuated Special Inventory Vendor of Valuated Special Inventory Valuation Type Valuation Area Price Unit in Local Currency Price Unit in Group Currency Price Unit in Another Currency Price Unit in Fourth Currency Original process category Category in Material Update Structure Procurement alternative/process Production Process Type of period G/L Account Number in Sender System Account Assignment in Sender System Object Type in Sender System Object number CO key subnumber Origin Group as Subdivision of Cost Element Partner object (always filled) Source of PAROB: PAROB1 or type of partner object Source Object (Cost Center/Activity Type) CO Debit/Credit Indicator Debit/Credit Indicator (Origin) Debit type Quantity Complete / Incomplete Offsetting Account Number Offsetting Account Type Completion indicator for line item Personnel Number Profitability Segment Number (CO-PA) Indicator: Profitability segm. relevant for CO compatibility Object Class Logical system of object Company code of partner Partner object class Logical system of partner object Strategy for Determining an Allocation Price Object Number of Origin Object Origin Order Number Origin cost center Origin activity Source: Business Process Account Assignment Object Type Activity Type Order Number Order category Work Breakdown Structure Element (WBS Element) Project Definition Network Number for Account Assignment Operation/Activity Number Business Process Cost Object Accounting Indicator Notification No Operating concern Partner Account Assignment Partner object type Partner activity Partner order number Partner Order Category Partner Work Breakdown Structure Element Partner Project Number of Partner Sales Order Partner Sales Order Item Partner profitability segment number (CO-PA) Partner Network Partner operation number Partner business process
FAGLFLEXA
COEP
BSEG / BKPF
BWTAR BWKEY PEINH
OBJNR HRKFT HRKFT-HKGRP PAROB1
HRKFT
USPOB BEKNZ BELTP MVFLG GKONT GKOAR ERLKZ PERNR PAOBJNR
PERNR PAOBJNR
SCOPE LOGSYSO PBUKRS PSCOPE LOGSYSP BWSTRAT OBJNR_HK OBJNR_HK USPOB USPOB ACCAS ACCASTY LSTAR AUFNR AUTYP PSPNR PSPID
ERKRS PACCAS PACCASTY PLSTAR PAUFNR PAUTYP PPSPNR PPSPID PVBELN PVBPOSNR
LSTAR AUFNR PROJK
Field name PKSTRG CO_ACCASTY_N1 CO_ACCASTY_N2 CO_ACCASTY_N3 CO_ZLENR CO_BELNR CO_BUZEI CO_REFBZ FKART VKORG VTWEG SPART MATNR_COPA MATKL KDGRP .INCLUDE INCL_EEW_ACDOC_COPA RE_BUKRS RE_ACCOUNT FIKRS FISTL MEASURE RFUND RGRANT_NBR RBUDGET_PD SFUND SGRANT_NBR SBUDGET_PD VNAME EGRUP RECID VPTNR BTYPE ETYPE PRODPER SWENR SGENR SGRNR SMENR RECNNR SNKSL SEMPSL DABRZ PSWENR PSGENR PSGRNR PSMENR PRECNNR PSNKSL PSEMPSL PDABRZ .INCLUDE CI_COBL .INCLUDE CI_PRS_CPILS_2 MIG_SOURCE MIG_DOCLN _DATAAGING
Description Partner cost object Type of first statistical account assignment Type of second statistical account assignment Type of third statistical account assignment Document Item Number Document Number Posting row Posting row of reference document Billing Type Sales Organization Distribution Channel Division Product for profitability analysis Material Group Customer group Extension include for CO-PA fields in Unified Journal Entry Cash Ledger: Company Code for Expense/Revenue Cash Ledger: Expense or Revenue Account Financial Management Area Funds Center Funded Program Fund Grant FM: Budget Period Partner Fund Partner Grant FM: Partner Budget Period Joint Venture Equity Group Recovery Indicator Partner Account Number Payroll Type Equity Type Production Month (Date to find period and year) Business Entity Number Building Number Land Number for BE Number of Rental Unit Real Estate Contract Number Service Charge Key Settlement Unit Reference Date for Settlement Business Entity Number Partner Building Number Partner Land Number for BE Partner Number of Rental Unit Partner Real Estate Contract Number Partner Service Charge Key Partner Settlement Unit Partner Reference Date for Settlement Customer include for Coding Block Customer include for Service Industry Source of a migrated journal entry item Item ID of migrated G/L line item Data Filter Value for Data Aging
FAGLFLEXA
COEP
BSEG / BKPF
ZLENR BELNR BUZEI REFBZ
BKPF-FIKRS FISTL MEASURE GEBER GRANT_NBR BUDGET_PD PGEBER PGRANT_NBR PBUDGET_PD
_DATAAGING
Comments Field AWKEY in BSEG/COEP is the concatenation of ACDOCA-AWREF and ACDOCA-AWORG If the CO area is using a 10/70 currency setting, i.e. object currencies are used, COEP-WOGBTR and OWAER map to ACDOCA-CO_OSL and RCO_OCUR. Otherwise, CO stores the company code currency in COEP-WOGBTR and OWAER, so they map to ACDOCA-HSL and RHCUR. Depending on the old currency settings, ACDOCA-KSL maps to FAGLFLEXA-KSL and BSEG-DMBE2, or to FAGLFLEXA-OSL and BSEG-DMBE3. You can check these settings in table FINSC_LD_CMP, field CURPOSK Vice versa, ACDOCA-OSL maps to FAGLFLEXA-OSL and BSEG-DMBE3, or to FAGLFLEXA-KSL and BSEG-DMBE2, see FINSC_LD_CMP-CURPOSO. It is also possible that old KSL/OSL are mapped to ACDOCA-VSL, see FINSC_LD_CMP-CURPOSV G/L account and cost element have been merged into single field ACDOCA-RACCT. This maps to COEP-KSTAR, BSEG-KSTAR and FAGLFLEXA-COST_ELEM
GRANT_NBR BUDGET_PD PGRANT_NBR PBUDGET_PD VNAME EGRUP RECID VPTNR BTYPE ETYPE PRODPER
_DATAAGING
