I_PurCtrAccountWD

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 I_PurCtrAccountWD.
-- 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: IPURCTRACCNTWD

CREATE VIEW I_PurCtrAccountWD AS
SELECT
  Document.AccountAssignment AS AccountAssignment,
  Document.PurchaseContractItem AS PurchaseContractItem,
  Document.PurchaseContract AS PurchaseContract,
  Document.PurchaseContract AS PurchaseContractForEdit,
  Document.PurchaseContractItem AS PurchaseContractItemForEdit,
  Document.AccountAssignment AS AccountAssignmentForEdit,
  Document.CostCenter AS CostCenter,
  Document.MasterFixedAsset AS MasterFixedAsset,
  Document.ProjectNetwork AS ProjectNetwork,
  Document.Quantity AS Quantity,
  Document.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  Document.PurgDocNetAmount AS PurgDocNetAmount,
  Document.IsDeleted AS IsDeleted,
  Document.GLAccount AS GLAccount,
  Document.BusinessArea AS BusinessArea,
  Document.SalesOrder AS SalesOrder,
  Document.SalesOrderItem AS SalesOrderItem,
  Document.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  Document.FixedAsset AS FixedAsset,
  Document.OrderID AS OrderID,
  Document.UnloadingPointName AS UnloadingPointName,
  Document.ControllingArea AS ControllingArea,
  Document.CostObject AS CostObject,
  Document.ProfitabilitySegment_2 AS ProfitabilitySegment,
  Document.ProfitCenter AS ProfitCenter,
  cast( Document.WBSElementInternalID_2 as ps_psp_pnr ) AS WBSElementInternalID,
  Document.WBSElement AS WBSElement,
  Document.WBSElementExternalID AS WBSElementExternalID,
  Document.WBSDescription AS WBSDescription,
  Document.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  cast(Document.CommitmentItemShortID as fipos ) AS CommitmentItem,
  Document.FundsCenter AS FundsCenter,
  Document.Fund AS Fund,
  Document.FunctionalArea AS FunctionalArea,
  Document.LastChangedDate AS LastChangedDate,
  Document.GoodsRecipientName AS GoodsRecipientName,
  Document.IsFinallyInvoiced AS IsFinallyInvoiced,
  cast( Document.REInternalFinNumber as imkey ) AS RealEstateObject,
  Document.NetworkActivityInternalID AS NetworkActivityInternalID,
  Document.PartnerAccountNumber AS PartnerAccountNumber,
  Document.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  Document.SettlementReferenceDate AS SettlementReferenceDate,
  Document.OrderInternalID AS OrderInternalID,
  Document.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  Document.TaxCode AS TaxCode,
  Document.TaxJurisdiction AS TaxJurisdiction,
  Document.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  Document.CostCtrActivityType AS CostCtrActivityType,
  Document.BusinessProcess AS BusinessProcess,
  Document.GrantID AS GrantID,
  Document.BudgetPeriod AS BudgetPeriod,
  Document.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  Document.ValidityDate AS ValidityDate,
  Document.DocumentCurrency AS DocumentCurrency,
  Document.OrderQuantityUnit AS OrderQuantityUnit
FROM I_PurCtrAccount AS Document
LEFT OUTER JOIN I_PurchaseContractWD AS _PurchaseContractWD ON _PurchaseContractWD.PurchaseContract = PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_PurchaseContractItemWD AS _PurchaseContractItemWD ON _PurchaseContractItemWD.PurchaseContractItem = PurchaseContractItem AND _PurchaseContractItemWD.PurchaseContract = PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON _CostCenter.ControllingArea = ControllingArea AND _CostCenter.CostCenter = CostCenter AND _CostCenter.ValidityEndDate >= ValidityDate AND _CostCenter.ValidityStartDate <= ValidityDate  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON _CostCenterText.ControllingArea = ControllingArea AND _CostCenterText.CostCenter = CostCenter AND _CostCenterText.ValidityEndDate >= ValidityDate  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON _BusinessArea.BusinessArea = BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON _BusinessAreaText.BusinessArea = BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON _ProfitCenter.ControllingArea = ControllingArea AND _ProfitCenter.ProfitCenter = ProfitCenter AND _ProfitCenter.ValidityEndDate >= ValidityDate AND _ProfitCenter.ValidityStartDate <= ValidityDate  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON _ProfitCenterText.ControllingArea = ControllingArea AND _ProfitCenterText.ProfitCenter = ProfitCenter AND _ProfitCenterText.ValidityEndDate >= ValidityDate  -- association [0..*]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON _SalesOrder.SalesOrder = SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON _SalesOrderItem.SalesOrder = SalesOrderItem AND _SalesOrderItem.SalesOrderItem = SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON _ControllingArea.ControllingArea = ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentScheduleLine AS _SalesDocumentScheduleLine ON _SalesDocumentScheduleLine.SalesDocument = SalesOrder AND _SalesDocumentScheduleLine.SalesDocumentItem = SalesOrderItem AND _SalesDocumentScheduleLine.ScheduleLine = SalesOrderScheduleLine  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementByInternalKey ON _WBSElementByInternalKey.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON _FunctionalArea.FunctionalArea = FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON _FunctionalAreaText.FunctionalArea = FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCenterActivityType ON _CostCenterActivityType.ControllingArea = ControllingArea AND _CostCenterActivityType.CostCtrActivityType = CostCtrActivityType AND _CostCenterActivityType.ValidityEndDate >= ValidityDate AND _CostCenterActivityType.ValidityStartDate <= ValidityDate  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _CostCenterActivityTypeText ON _CostCenterActivityTypeText.ControllingArea = ControllingArea AND _CostCenterActivityTypeText.CostCtrActivityType = CostCtrActivityType AND _CostCenterActivityTypeText.ValidityEndDate >= ValidityDate  -- association [0..*]
LEFT OUTER JOIN I_BusinessProcess AS _BusinessProcess ON _BusinessProcess.BusinessProcess = BusinessProcess AND _BusinessProcess.ControllingArea = ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcessText AS _BusinessProcessText ON _BusinessProcessText.BusinessProcess = BusinessProcess AND _BusinessProcessText.ControllingArea = ControllingArea AND _BusinessProcessText.ValidityEndDate >= ValidityDate  -- association [0..*]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..*]
;