P_Materialledger_Curtp_Lit

Belnr | view: PMALCURTPLIT | Extraction: Not supported | Component: Information System
Tables used: ACDOCA, ACDOCD, FINSC_LEDGER, FINSC_LEDGER_T, FINSC_CURTYPE, FINSC_CURTYPET, FINSC_LEDGER, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_LEDGER_REP, FINSC_LD_CMP, FINSC_FISC_DATE, FINSC_PERIOD, FMLC_TOGGLE, FMLT_CURTP_ML
Column Name Description
SourceLedger FK Source Ledger
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
mlcateg Category in Material Update Structure Show values
bstat Journal Entry Category Show values
MaterialPriceControl Price control indicator 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 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_MATERIALLEDGER_CURTP_LIT.AUFNR == AUFK.AUFNR
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == AUFK.MANDT
Reference Document Type P_MATERIALLEDGER_CURTP_LIT.AWTYP == TTYP.AWTYP
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_MATERIALLEDGER_CURTP_LIT.BLART == T003.BLART
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == T003.MANDT
Business Transaction Category
  • Business Transaction Category
  • Client
Valuation area
  • Valuation area
  • Client
  • P_MATERIALLEDGER_CURTP_LIT.BWKEY == T001K.BWKEY
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == T001K.MANDT
Valuation Type
  • Valuation Type
  • Client
  • P_MATERIALLEDGER_CURTP_LIT.BWTAR == T149D.BWTAR
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == T149D.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == TKA01.MANDT
  • P_MATERIALLEDGER_CURTP_LIT.KOKRS == TKA01.KOKRS
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_MATERIALLEDGER_CURTP_LIT.KTOPL == T004.KTOPL
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == T004.MANDT
Material Number
  • Material Number
  • Client
  • P_MATERIALLEDGER_CURTP_LIT.MATNR == MARA.MATNR
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == MARA.MANDT
Original Process Category P_MATERIALLEDGER_CURTP_LIT.MLPTYP == CKMLMV009.PTYP
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_MATERIALLEDGER_CURTP_LIT.PERIV == T009.PERIV
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == T009.MANDT
Profit Center
  • Client
  • ?
  • Controlling Area
  • Profit Center
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == CEPC.MANDT
  • P_MATERIALLEDGER_CURTP_LIT.[column in domain "DATBI"] == CEPC.DATBI
  • P_MATERIALLEDGER_CURTP_LIT.KOKRS == CEPC.KOKRS
  • P_MATERIALLEDGER_CURTP_LIT.PRCTR == CEPC.PRCTR
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_MATERIALLEDGER_CURTP_LIT.RACCT == SKB1.SAKNR
  • P_MATERIALLEDGER_CURTP_LIT.RBUKRS == SKB1.BUKRS
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == SKB1.MANDT
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CURTP_LIT.RBCUR == TCURC.WAERS
Company Code
  • Company Code
  • Client
  • P_MATERIALLEDGER_CURTP_LIT.RBUKRS == T001.BUKRS
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == T001.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • P_MATERIALLEDGER_CURTP_LIT.RCCUR == TCURC.WAERS
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == TCURC.MANDT
Cost Center
  • Cost Center
  • Client
  • ?
  • Controlling Area
  • P_MATERIALLEDGER_CURTP_LIT.RCNTR == CSKS.KOSTL
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == CSKS.MANDT
  • P_MATERIALLEDGER_CURTP_LIT.[column in domain "DATBI"] == CSKS.DATBI
  • P_MATERIALLEDGER_CURTP_LIT.KOKRS == CSKS.KOKRS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CURTP_LIT.RDCUR == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CURTP_LIT.RECUR == TCURC.WAERS
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • P_MATERIALLEDGER_CURTP_LIT.RFCUR == TCURC.WAERS
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CURTP_LIT.RGCUR == TCURC.WAERS
Company Code Currency
  • Client
  • Company Code Currency
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CURTP_LIT.RHCUR == TCURC.WAERS
Global Currency
  • Client
  • Global Currency
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CURTP_LIT.RKCUR == TCURC.WAERS
Ledger
  • Ledger
  • Source Ledger
  • Client
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CURTP_LIT.ROCUR == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CURTP_LIT.RVCUR == TCURC.WAERS
Cost Source Unit
  • Cost Source Unit
  • Client
  • P_MATERIALLEDGER_CURTP_LIT.RVUNIT == T006.MSEHI
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == T006.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == FAGL_SEGM.MANDT
  • P_MATERIALLEDGER_CURTP_LIT.SEGMENT == FAGL_SEGM.SEGMENT
Source Ledger
  • Client
  • Ledger
  • Source Ledger
Plant
  • Client
  • Plant
  • P_MATERIALLEDGER_CURTP_LIT.MANDT == T001W.MANDT
  • P_MATERIALLEDGER_CURTP_LIT.WERKS == T001W.WERKS