P_GLItemPurchasingByCostCenter

GL line items including reference to Purchasing Document | view: PGLITMPURCC | Extraction: Not supported | Component: Fiori FXU Cost Controlling CO-FIO
Column Name Description
ControllingArea FK Controlling Area
CompanyCode FK Company Code
FiscalYear Fiscal Year
FiscalYearVariant FK Fiscal Year Variant
FiscalPeriod Fiscal Period
CostCenter FK Cost Center
CostElement FK G/L Account
ValidityEndDate Valid To Date
ValidityStartDate Valid-From Date
LedgerGLLineItem Ledger Journal Entry Item
SourceLedger FK Source Ledger
AccountingDocument Journal Entry
Ledger FK Ledger in General Ledger Accounting
PurchasingDocument FK Purchasing Document
Column Name Description
CmtmtAmtInCompanyCodeCurrency null
ActAmtInCompanyCodeCurrency null
Column Name Description
Column Name Description
ValidityEndDate Valid To Date
ValidityStartDate Valid-From Date
PostingDate Posting Date
StartDate null
EndDate null
Column Name Description
IsCommitment Indicator: Is Commitment Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_GLITEMPURCHASINGBYCOSTCENTER.MANDT == T001.MANDT
  • P_GLITEMPURCHASINGBYCOSTCENTER.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_GLITEMPURCHASINGBYCOSTCENTER.MANDT == TCURC.MANDT
  • P_GLITEMPURCHASINGBYCOSTCENTER.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • P_GLITEMPURCHASINGBYCOSTCENTER.MANDT == TKA01.MANDT
  • P_GLITEMPURCHASINGBYCOSTCENTER.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Cost Center
  • Client
  • ?
  • Controlling Area
  • P_GLITEMPURCHASINGBYCOSTCENTER.COSTCENTER == CSKS.KOSTL
  • P_GLITEMPURCHASINGBYCOSTCENTER.MANDT == CSKS.MANDT
  • P_GLITEMPURCHASINGBYCOSTCENTER.[column in domain "DATBI"] == CSKS.DATBI
  • P_GLITEMPURCHASINGBYCOSTCENTER.CONTROLLINGAREA == CSKS.KOKRS
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_GLITEMPURCHASINGBYCOSTCENTER.COSTELEMENT == SKB1.SAKNR
  • P_GLITEMPURCHASINGBYCOSTCENTER.MANDT == SKB1.MANDT
  • P_GLITEMPURCHASINGBYCOSTCENTER.COMPANYCODE == SKB1.BUKRS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_GLITEMPURCHASINGBYCOSTCENTER.FISCALYEARVARIANT == T009.PERIV
  • P_GLITEMPURCHASINGBYCOSTCENTER.MANDT == T009.MANDT
Ledger in General Ledger Accounting
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
  • P_GLITEMPURCHASINGBYCOSTCENTER.MANDT == FINSC_LEDGER.MANDT
  • P_GLITEMPURCHASINGBYCOSTCENTER.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • P_GLITEMPURCHASINGBYCOSTCENTER.LEDGER == FINSC_LEDGER.RLDNR
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
  • P_GLITEMPURCHASINGBYCOSTCENTER.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • P_GLITEMPURCHASINGBYCOSTCENTER.LEDGER == FINSC_LEDGER.RLDNR
  • P_GLITEMPURCHASINGBYCOSTCENTER.MANDT == FINSC_LEDGER.MANDT