P_PurchaseReqnCommitment

DDL: P_PURCHASEREQNCOMMITMENT SQL: PPURREQNCOMMIT Type: view COMPOSITE Package: VDM_MM_PUR_PR
33 Fields 2 Data Sources

Purchase Requisition Basic View for Commitments

P_PurchaseReqnCommitment is a Composite CDS View that provides data about "Purchase Requisition Basic View for Commitments" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountLineItem, I_PurchaseReqn) and exposes 33 fields with key fields PurchaseRequisition, PurchaseRequisitionItem, AccountAssignmentNumber, SourceReferenceDocSubitem, GLAccount. Part of development package VDM_MM_PUR_PR.

Data Sources (2)

SourceAliasJoin Type
I_GLAccountLineItem I_GLAccountLineItem from
I_PurchaseReqn PurchaseReqn inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPURREQNCOMMIT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition SourceReferenceDocument Reference Doc.
KEY PurchaseRequisitionItem
KEY AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
KEY SourceReferenceDocSubitem SourceReferenceDocSubitem
KEY GLAccount GLAccount General Ledger
KEY ControllingArea ControllingArea Controlling Area
KEY FunctionalArea FunctionalArea Sendr Fctl Area
KEY PostingDate PostingDate Posting Date for GR
KEY CompanyCode I_GLAccountLineItem CompanyCode Receiver Company Code
KEY CashLedgerAccount CashLedgerAccount Cash Origin Account
KEY Fund Fund Sender Fund
KEY GrantID GrantID Sender Grant
KEY BudgetPeriod BudgetPeriod Budget Period
KEY PubSecBudgetAccount PubSecBudgetAccount Budget Account
KEY PubSecBudgetAccountCoCode PubSecBudgetAccountCoCode Company Code for Budget Account
KEY PubSecBudgetIsRelevant PubSecBudgetIsRelevant
KEY PubSecBudgetCnsmpnType PubSecBudgetCnsmpnType Budget Consumption Type
KEY CostCenter CostCenter Cost Center
KEY ProfitCenter ProfitCenter Profit Center
KEY Segment Segment Segment number
KEY WBSElementInternalID WBSElementInternalID WBS Internal ID
KEY AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
KEY AccountAssignment AccountAssignment Sender Acct Assgmt
Ledger Ledger Ledger
IsCommitment IsCommitment
TransactionCurrency TransactionCurrency Transaction Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
CashLedgerCompanyCode CashLedgerCompanyCode Cash Origin CoCode
_FunctionalArea _FunctionalArea
_CashLedgerAccount _CashLedgerAccount
_PubSecBudgetAccount _PubSecBudgetAccount
_PubSecBudgetCnsmpnType _PubSecBudgetCnsmpnType

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_PurchaseReqnCommitment.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PPURREQNCOMMIT

CREATE VIEW P_PurchaseReqnCommitment AS
SELECT
  SourceReferenceDocument AS PurchaseRequisition,
  right(SourceReferenceDocumentItem, 5 ) AS PurchaseRequisitionItem,
  AccountAssignmentNumber,
  SourceReferenceDocSubitem,
  GLAccount,
  ControllingArea,
  FunctionalArea,
  PostingDate,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  CashLedgerAccount,
  Fund,
  GrantID,
  BudgetPeriod,
  PubSecBudgetAccount,
  PubSecBudgetAccountCoCode,
  PubSecBudgetIsRelevant,
  PubSecBudgetCnsmpnType,
  CostCenter,
  ProfitCenter,
  Segment,
  WBSElementInternalID,
  AccountAssignmentType,
  AccountAssignment,
  Ledger,
  IsCommitment,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  CashLedgerCompanyCode
FROM I_GLAccountLineItem
INNER JOIN I_PurchaseReqn AS PurchaseReqn ON /* join condition not captured in parsed metadata */
;

Learn More