P_Materialledgercurtp_Bal

Curtps , distinct years for balance Summary | view: PMLCUTPBA | Extraction: Not supported | Component: Information System
Tables used: ACDOCA, FINSC_LEDGER, FINSC_LEDGER_T, EBEW, MBEW, OBEW, QBEW, FINSC_CURTYPE, FINSC_CURTYPET, FINSC_LEDGER, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_LD_CMP, FMLC_TOGGLE, FMLT_CURTP_ML, TCURM
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):
hvkwrt Value at Sales Price in Local Currency
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
💲 Freely Defined Currency 3 (rbcur):
bsl Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (rccur):
csl Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (rdcur):
dsl Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (recur):
esl Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (rfcur):
fsl Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (rgcur):
gsl Amount in Freely Defined Currency 8
Column Name Description
📏 Cost Source Unit (rvunit):
vmsl Valuation quantity
Column Name Description
budat Posting Date
bldat Journal Entry Date
Column Name Description
bwkrs_cus Valuation area setting Show values
mlcateg Category in Material Update Structure 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
werks Plant WERKS
kalnr Cost Estimate CK_KALNR
sobkz Inventory Special Stock Type SOBKZ
CurtpH Currency Type of Currency 1 FINS_CURTYPE
CurtpK Currency Type of Currency 2 FINS_CURTYPE
CurtpO Currency Type of Freely Defined Currency 1 FINS_CURTYPE
CurtpV Currency Type of Freely Defined Currency 2 FINS_CURTYPE
CurtpB Currency Type of Third Freely Defined Currency FINS_CURTYPE
CurtpC Currency Type of Freely Defined Currency 4 FINS_CURTYPE
CurtpD Currency Type of Freely Defined Currency 5 FINS_CURTYPE
CurtpE Currency Type of Freely Defined Currency 6 FINS_CURTYPE
CurtpF Currency Type of Freely Defined Currency 7 FINS_CURTYPE
CurtpG Currency Type of Freely Defined Currency 8 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_MATERIALLEDGERCURTP_BAL.AUFNR == AUFK.AUFNR
  • P_MATERIALLEDGERCURTP_BAL.MANDT == AUFK.MANDT
Reference Document Type P_MATERIALLEDGERCURTP_BAL.AWTYP == TTYP.AWTYP
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_MATERIALLEDGERCURTP_BAL.MANDT == T003.MANDT
  • P_MATERIALLEDGERCURTP_BAL.BLART == T003.BLART
Business Transaction Category
  • Client
  • Business Transaction Category
Valuation area
  • Client
  • Valuation area
  • P_MATERIALLEDGERCURTP_BAL.MANDT == T001K.MANDT
  • P_MATERIALLEDGERCURTP_BAL.BWKEY == T001K.BWKEY
Valuation Type
  • Client
  • Valuation Type
  • P_MATERIALLEDGERCURTP_BAL.MANDT == T149D.MANDT
  • P_MATERIALLEDGERCURTP_BAL.BWTAR == T149D.BWTAR
Controlling Area
  • Client
  • Controlling Area
  • P_MATERIALLEDGERCURTP_BAL.MANDT == TKA01.MANDT
  • P_MATERIALLEDGERCURTP_BAL.KOKRS == TKA01.KOKRS
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_MATERIALLEDGERCURTP_BAL.MANDT == T004.MANDT
  • P_MATERIALLEDGERCURTP_BAL.KTOPL == T004.KTOPL
Material Number
  • Material Number
  • Client
  • P_MATERIALLEDGERCURTP_BAL.MATNR == MARA.MATNR
  • P_MATERIALLEDGERCURTP_BAL.MANDT == MARA.MANDT
Original Process Category P_MATERIALLEDGERCURTP_BAL.MLPTYP == CKMLMV009.PTYP
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_MATERIALLEDGERCURTP_BAL.PERIV == T009.PERIV
  • P_MATERIALLEDGERCURTP_BAL.MANDT == T009.MANDT
Profit Center
  • Client
  • ?
  • Profit Center
  • Controlling Area
  • P_MATERIALLEDGERCURTP_BAL.MANDT == CEPC.MANDT
  • P_MATERIALLEDGERCURTP_BAL.[column in domain "DATBI"] == CEPC.DATBI
  • P_MATERIALLEDGERCURTP_BAL.PRCTR == CEPC.PRCTR
  • P_MATERIALLEDGERCURTP_BAL.KOKRS == CEPC.KOKRS
G/L Account
  • Client
  • Company Code
  • G/L Account
  • P_MATERIALLEDGERCURTP_BAL.MANDT == SKB1.MANDT
  • P_MATERIALLEDGERCURTP_BAL.RBUKRS == SKB1.BUKRS
  • P_MATERIALLEDGERCURTP_BAL.RACCT == SKB1.SAKNR
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • P_MATERIALLEDGERCURTP_BAL.MANDT == TCURC.MANDT
  • P_MATERIALLEDGERCURTP_BAL.RBCUR == TCURC.WAERS
Company Code
  • Client
  • Company Code
  • P_MATERIALLEDGERCURTP_BAL.MANDT == T001.MANDT
  • P_MATERIALLEDGERCURTP_BAL.RBUKRS == T001.BUKRS
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • P_MATERIALLEDGERCURTP_BAL.MANDT == TCURC.MANDT
  • P_MATERIALLEDGERCURTP_BAL.RCCUR == TCURC.WAERS
Cost Center
  • Client
  • ?
  • Controlling Area
  • Cost Center
  • P_MATERIALLEDGERCURTP_BAL.MANDT == CSKS.MANDT
  • P_MATERIALLEDGERCURTP_BAL.[column in domain "DATBI"] == CSKS.DATBI
  • P_MATERIALLEDGERCURTP_BAL.KOKRS == CSKS.KOKRS
  • P_MATERIALLEDGERCURTP_BAL.RCNTR == CSKS.KOSTL
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_MATERIALLEDGERCURTP_BAL.MANDT == TCURC.MANDT
  • P_MATERIALLEDGERCURTP_BAL.RDCUR == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_MATERIALLEDGERCURTP_BAL.MANDT == TCURC.MANDT
  • P_MATERIALLEDGERCURTP_BAL.RECUR == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_MATERIALLEDGERCURTP_BAL.MANDT == TCURC.MANDT
  • P_MATERIALLEDGERCURTP_BAL.RFCUR == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_MATERIALLEDGERCURTP_BAL.MANDT == TCURC.MANDT
  • P_MATERIALLEDGERCURTP_BAL.RGCUR == TCURC.WAERS
Company Code Currency
  • Client
  • Company Code Currency
  • P_MATERIALLEDGERCURTP_BAL.MANDT == TCURC.MANDT
  • P_MATERIALLEDGERCURTP_BAL.RHCUR == TCURC.WAERS
Global Currency
  • Client
  • Global Currency
  • P_MATERIALLEDGERCURTP_BAL.MANDT == TCURC.MANDT
  • P_MATERIALLEDGERCURTP_BAL.RKCUR == TCURC.WAERS
Ledger
  • Ledger
  • Client
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_MATERIALLEDGERCURTP_BAL.MANDT == TCURC.MANDT
  • P_MATERIALLEDGERCURTP_BAL.ROCUR == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_MATERIALLEDGERCURTP_BAL.MANDT == TCURC.MANDT
  • P_MATERIALLEDGERCURTP_BAL.RVCUR == TCURC.WAERS
Cost Source Unit
  • Client
  • Cost Source Unit
  • P_MATERIALLEDGERCURTP_BAL.MANDT == T006.MANDT
  • P_MATERIALLEDGERCURTP_BAL.RVUNIT == T006.MSEHI
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_MATERIALLEDGERCURTP_BAL.MANDT == FAGL_SEGM.MANDT
  • P_MATERIALLEDGERCURTP_BAL.SEGMENT == FAGL_SEGM.SEGMENT