P_Materialledger_CurTP

P_MATERIALLEDGER_CURTP | view: PMATLEDGERCURTP | Extraction: Not supported | Component: Information System
Tables used: ACDOCA, FINSC_LEDGER, FINSC_CURTYPE, FINSC_CURTYPET, FINSC_LEDGER, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FMLC_TOGGLE, FMLT_CURTP_ML, FINSC_LD_CMP
Column Name Description
rbukrs FK Company Code
rldnr FK Ledger
racct FK G/L Account
gjahr Fiscal Year
belnr Journal Entry
docln Ledger Journal Entry Item
matnr FK Material Number
Column Name Description
💲 Company Code Currency (rhcur):
hsl Amount in Company Code Currency
💲 Global Currency (rkcur):
ksl Amount in Global Currency
💲 Freely Defined Currency 1 (rocur):
osl Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (rvcur):
vsl Amount in Freely Defined Currency 2
Column Name Description
📏 Cost Source Unit (rvunit):
vmsl Valuation quantity
Column Name Description
budat Posting Date
bldat Journal Entry Date
Column Name Description
mlcateg Category in Material Update Structure Show values
bstat Journal Entry Category Show values
xobew Vendor Stock Valuation Indicator Show values
kzbws Inventory Special Stock Valuation Type Show values
Column Name Description Domain name
poper Fiscal Period POPER
ryear Ledger Fiscal Year GJAHR
awref Reference document number AWREF
timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
fiscyearper Fiscal Year Period FIS_JAHRPER_CONV
ktosl Transaction Key CHAR3
kalnr Cost Estimate CK_KALNR
sobkz Inventory Special Stock Type SOBKZ
CurtpH External Currency Type and Valuation View FINS_CURTYPE
rldnrh Ledger in General Ledger Accounting FINS_LEDGER
ext_CurtpH External Currency Type and Valuation View FINS_CURTYPE
CurtpK External Currency Type and Valuation View FINS_CURTYPE
rldnrk Ledger in General Ledger Accounting FINS_LEDGER
ext_CurtpK External Currency Type and Valuation View FINS_CURTYPE
CurtpO External Currency Type and Valuation View FINS_CURTYPE
rldnro Ledger in General Ledger Accounting FINS_LEDGER
ext_CurtpO External Currency Type and Valuation View FINS_CURTYPE
CurtpV External Currency Type and Valuation View FINS_CURTYPE
rldnrv Ledger in General Ledger Accounting FINS_LEDGER
ext_CurtpV External Currency Type and Valuation View FINS_CURTYPE
mat_kdauf Sales Document Number of Valuated Special Inventory VBELN
mat_kdpos Sales Document Item Number of Valuated Special Inventory POSNR
mat_pspnr WBS Element (internal) of Valuated Special Inventory PS_POSNR
mat_lifnr Supplier of Inventory Special Stock LIFNR
Master Data Relations Join Conditions
Order ID
  • Order ID
  • Client
  • P_MATERIALLEDGER_CURTP.AUFNR == AUFK.AUFNR
  • P_MATERIALLEDGER_CURTP.MANDT == AUFK.MANDT
Reference Document Type P_MATERIALLEDGER_CURTP.AWTYP == TTYP.AWTYP
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_MATERIALLEDGER_CURTP.MANDT == T003.MANDT
  • P_MATERIALLEDGER_CURTP.BLART == T003.BLART
Business Transaction Category
  • Client
  • Business Transaction Category
Valuation area
  • Client
  • Valuation area
  • P_MATERIALLEDGER_CURTP.MANDT == T001K.MANDT
  • P_MATERIALLEDGER_CURTP.BWKEY == T001K.BWKEY
Valuation Type
  • Client
  • Valuation Type
  • P_MATERIALLEDGER_CURTP.MANDT == T149D.MANDT
  • P_MATERIALLEDGER_CURTP.BWTAR == T149D.BWTAR
Controlling Area
  • Client
  • Controlling Area
  • P_MATERIALLEDGER_CURTP.MANDT == TKA01.MANDT
  • P_MATERIALLEDGER_CURTP.KOKRS == TKA01.KOKRS
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_MATERIALLEDGER_CURTP.KTOPL == T004.KTOPL
  • P_MATERIALLEDGER_CURTP.MANDT == T004.MANDT
Material Number
  • Material Number
  • Client
  • P_MATERIALLEDGER_CURTP.MATNR == MARA.MATNR
  • P_MATERIALLEDGER_CURTP.MANDT == MARA.MANDT
Original Process Category P_MATERIALLEDGER_CURTP.MLPTYP == CKMLMV009.PTYP
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • P_MATERIALLEDGER_CURTP.MANDT == T009.MANDT
  • P_MATERIALLEDGER_CURTP.PERIV == T009.PERIV
Profit Center
  • Client
  • Controlling Area
  • ?
  • Profit Center
  • P_MATERIALLEDGER_CURTP.MANDT == CEPC.MANDT
  • P_MATERIALLEDGER_CURTP.KOKRS == CEPC.KOKRS
  • P_MATERIALLEDGER_CURTP.[column in domain "DATBI"] == CEPC.DATBI
  • P_MATERIALLEDGER_CURTP.PRCTR == CEPC.PRCTR
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_MATERIALLEDGER_CURTP.RACCT == SKB1.SAKNR
  • P_MATERIALLEDGER_CURTP.RBUKRS == SKB1.BUKRS
  • P_MATERIALLEDGER_CURTP.MANDT == SKB1.MANDT
Company Code
  • Company Code
  • Client
  • P_MATERIALLEDGER_CURTP.RBUKRS == T001.BUKRS
  • P_MATERIALLEDGER_CURTP.MANDT == T001.MANDT
Cost Center
  • Client
  • Controlling Area
  • ?
  • Cost Center
  • P_MATERIALLEDGER_CURTP.MANDT == CSKS.MANDT
  • P_MATERIALLEDGER_CURTP.KOKRS == CSKS.KOKRS
  • P_MATERIALLEDGER_CURTP.[column in domain "DATBI"] == CSKS.DATBI
  • P_MATERIALLEDGER_CURTP.RCNTR == CSKS.KOSTL
Company Code Currency
  • Client
  • Company Code Currency
  • P_MATERIALLEDGER_CURTP.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CURTP.RHCUR == TCURC.WAERS
Global Currency
  • Client
  • Global Currency
  • P_MATERIALLEDGER_CURTP.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CURTP.RKCUR == TCURC.WAERS
Ledger
  • Ledger
  • Client
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_MATERIALLEDGER_CURTP.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CURTP.ROCUR == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_MATERIALLEDGER_CURTP.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CURTP.RVCUR == TCURC.WAERS
Cost Source Unit
  • Client
  • Cost Source Unit
  • P_MATERIALLEDGER_CURTP.MANDT == T006.MANDT
  • P_MATERIALLEDGER_CURTP.RVUNIT == T006.MSEHI
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_MATERIALLEDGER_CURTP.MANDT == FAGL_SEGM.MANDT
  • P_MATERIALLEDGER_CURTP.SEGMENT == FAGL_SEGM.SEGMENT
Plant
  • Client
  • Plant
  • P_MATERIALLEDGER_CURTP.MANDT == T001W.MANDT
  • P_MATERIALLEDGER_CURTP.WERKS == T001W.WERKS