P_PurchaseReqnCommitment

Purchase Requisition Basic View for Commitments | view: PPURREQNCOMMIT | TRAN | Extraction: Not supported | Component: Purchase Requisitions
Tables used: SCAL_TT_DATE, MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, ACDOCA, FM01, T001W, T001K, MMPUR_C_BE_SYREG, FINSC_LEDGER_REP, FINSC_PRED_RLDNR, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition FK Purchasing Document
PurchaseRequisitionItem FK Purchasing Document Item
AccountAssignmentNumber Account Assignment Number
SourceReferenceDocSubitem Source Reference Document Subitem
GLAccount FK G/L Account
ControllingArea FK Controlling Area
FunctionalArea FK Functional Area
PostingDate Posting Date
CompanyCode FK Company Code
CashLedgerAccount FK Cash Origin Account
Fund FK Fund
GrantID Grant
BudgetPeriod FK Budget Period
PubSecBudgetAccount FK Budget Account
PubSecBudgetAccountCoCode FK Budget Account Company Code
PubSecBudgetIsRelevant Budget-Relevant Indicator Show values
PubSecBudgetCnsmpnType FK Budget Consumption Type
CostCenter FK Cost Center
ProfitCenter FK Profit Center
Segment FK Segment for Segmental Reporting
WBSElementInternalID WBS Element Internal ID
AccountAssignmentType FK Account Assignment Type
AccountAssignment Account Assignment
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency null
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency null
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency null
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
PubSecBudgetIsRelevant Budget-Relevant Indicator Show values
IsCommitment Indicator: Is Commitment Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Budget Period
  • Client
  • Fund
  • ?
  • Budget Period
  • P_PURCHASEREQNCOMMITMENT.MANDT == FMFUNDBPD.MANDT
  • P_PURCHASEREQNCOMMITMENT.FUND == FMFUNDBPD.FINCODE
  • P_PURCHASEREQNCOMMITMENT.[column in domain "FIKRS"] == FMFUNDBPD.FIKRS
  • P_PURCHASEREQNCOMMITMENT.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
Cash Origin Account
  • Client
  • ?
  • Cash Origin Account
  • P_PURCHASEREQNCOMMITMENT.MANDT == SKA1.MANDT
  • P_PURCHASEREQNCOMMITMENT.[column in domain "KTOPL"] == SKA1.KTOPL
  • P_PURCHASEREQNCOMMITMENT.CASHLEDGERACCOUNT == SKA1.SAKNR
Company Code
  • Client
  • Company Code
  • P_PURCHASEREQNCOMMITMENT.MANDT == T001.MANDT
  • P_PURCHASEREQNCOMMITMENT.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_PURCHASEREQNCOMMITMENT.MANDT == TCURC.MANDT
  • P_PURCHASEREQNCOMMITMENT.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • P_PURCHASEREQNCOMMITMENT.MANDT == TKA01.MANDT
  • P_PURCHASEREQNCOMMITMENT.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Cost Center
  • Client
  • Controlling Area
  • P_PURCHASEREQNCOMMITMENT.[column in domain "DATBI"] == CSKS.DATBI
  • P_PURCHASEREQNCOMMITMENT.COSTCENTER == CSKS.KOSTL
  • P_PURCHASEREQNCOMMITMENT.MANDT == CSKS.MANDT
  • P_PURCHASEREQNCOMMITMENT.CONTROLLINGAREA == CSKS.KOKRS
Functional Area
  • Client
  • Functional Area
  • P_PURCHASEREQNCOMMITMENT.MANDT == TFKB.MANDT
  • P_PURCHASEREQNCOMMITMENT.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Client
  • Fund
  • ?
  • P_PURCHASEREQNCOMMITMENT.MANDT == FMFINCODE.MANDT
  • P_PURCHASEREQNCOMMITMENT.FUND == FMFINCODE.FINCODE
  • P_PURCHASEREQNCOMMITMENT.[column in domain "FIKRS"] == FMFINCODE.FIKRS
G/L Account
  • Client
  • Company Code
  • G/L Account
  • P_PURCHASEREQNCOMMITMENT.MANDT == SKB1.MANDT
  • P_PURCHASEREQNCOMMITMENT.COMPANYCODE == SKB1.BUKRS
  • P_PURCHASEREQNCOMMITMENT.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • P_PURCHASEREQNCOMMITMENT.MANDT == TCURC.MANDT
  • P_PURCHASEREQNCOMMITMENT.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Profit Center
  • ?
  • Profit Center
  • Client
  • Controlling Area
  • P_PURCHASEREQNCOMMITMENT.[column in domain "DATBI"] == CEPC.DATBI
  • P_PURCHASEREQNCOMMITMENT.PROFITCENTER == CEPC.PRCTR
  • P_PURCHASEREQNCOMMITMENT.MANDT == CEPC.MANDT
  • P_PURCHASEREQNCOMMITMENT.CONTROLLINGAREA == CEPC.KOKRS
Budget Account
  • Budget Account
  • Client
  • ?
  • P_PURCHASEREQNCOMMITMENT.PUBSECBUDGETACCOUNT == SKA1.SAKNR
  • P_PURCHASEREQNCOMMITMENT.MANDT == SKA1.MANDT
  • P_PURCHASEREQNCOMMITMENT.[column in domain "KTOPL"] == SKA1.KTOPL
Budget Account Company Code
  • Client
  • Budget Account Company Code
  • P_PURCHASEREQNCOMMITMENT.MANDT == T001.MANDT
  • P_PURCHASEREQNCOMMITMENT.PUBSECBUDGETACCOUNTCOCODE == T001.BUKRS
Budget Consumption Type
  • Client
  • Budget Consumption Type
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_PURCHASEREQNCOMMITMENT.MANDT == FAGL_SEGM.MANDT
  • P_PURCHASEREQNCOMMITMENT.SEGMENT == FAGL_SEGM.SEGMENT
Transaction Currency
  • Client
  • Transaction Currency
  • P_PURCHASEREQNCOMMITMENT.MANDT == TCURC.MANDT
  • P_PURCHASEREQNCOMMITMENT.TRANSACTIONCURRENCY == TCURC.WAERS