C_PurchaseOrderCommitment

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 C_PurchaseOrderCommitment.
-- 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: CPURORDCOMMIT

CREATE VIEW C_PurchaseOrderCommitment AS
SELECT
  cast (PurchasingDocument as vdm_purchaseorder preserving type) AS PurchaseOrder,
  PurchasingDocumentItem AS PurchaseOrderItem,
  cast(AccountAssignmentNumber as dzekkn_ll preserving type ) AS AccountAssignmentNumber,
  SourceReferenceDocSubitem,
  Segment,
  PurchaseOrderCommitment.GLAccount AS GLAccount,
  ControllingArea,
  PurchaseOrderCommitment.FunctionalArea AS FunctionalArea,
  PurchaseOrderCommitment.CompanyCode AS CompanyCode,
  PurchaseOrderCommitment.CashLedgerAccount AS CashLedgerAccount,
  PurchaseOrderCommitment.Fund AS Fund,
  PurchaseOrderCommitment.GrantID AS GrantID,
  PurchaseOrderCommitment.BudgetPeriod AS BudgetPeriod,
  PurchaseOrderCommitment.FiscalYearPeriod AS FiscalYearPeriod,
  PurchaseOrderCommitment.PubSecBudgetAccount AS PubSecBudgetAccount,
  PurchaseOrderCommitment.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  PurchaseOrderCommitment.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  PurchaseOrderCommitment.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  PurchaseOrderCommitment.CostCenter AS CostCenter,
  PurchaseOrderCommitment.ProfitCenter AS ProfitCenter,
  PurchaseOrderCommitment.WBSElementInternalID AS WBSElementInternalID,
  PurchaseOrderCommitment.WBSElement AS WBSElement,
  PurchaseOrderCommitment.AccountAssignmentType AS AccountAssignmentType,
  PurchaseOrderCommitment.AccountAssignment AS AccountAssignment,
  PurchaseOrderCommitment.SponsoredProgram AS SponsoredProgram,
  PurchaseOrderCommitment.SponsoredClass AS SponsoredClass,
  PurchaseOrderItemText AS DocumentItemText,
  cast (AmountInTransactionCurrency as fis_wsl_ll preserving type ) AS AmountInTransactionCurrency,
  cast(AmountInCompanyCodeCurrency as fis_hsl_ll preserving type ) AS AmountInCompanyCodeCurrency,
  TransactionCurrency,
  CompanyCodeCurrency,
  cast(AmountInGlobalCurrency as fis_ksl_ll preserving type ) AS AmountInGlobalCurrency,
  GlobalCurrency,
  IsCommitment,
  PurchaseOrderCommitment._FunctionalArea AS _FunctionalArea
FROM P_PurchaseOrderCommitment AS PurchaseOrderCommitment
INNER JOIN I_PurchaseOrderItemTP AS _PurchaseOrderItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_PurchaseOrderTP AS _PurchaseOrderTP ON _PurchaseOrderTP.PurchaseOrder = PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_MM_GLAccountVH AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MM_ControllingAreaVH AS _ControllingAreaValueHelp ON ControllingArea = _ControllingAreaValueHelp.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_PubSecBudgetAccountStdVH AS _PubSecBudgetAccountStd ON _PubSecBudgetAccountStd.PubSecBudgetAccount = PubSecBudgetAccount AND _PubSecBudgetAccountStd.PubSecBudgetAccountCoCode = PubSecBudgetAccountCoCode  -- association [0..1]
LEFT OUTER JOIN I_PubSecBdgtCnsmpnType AS _PubSecBdgtCnsmpnType ON _PubSecBdgtCnsmpnType.PubSecBudgetCnsmpnType = PubSecBudgetCnsmpnType  -- association [0..1]
;