C_Purctraccassign

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_Purctraccassign.
-- 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: CPURCTRACTASSIGN

CREATE VIEW C_Purctraccassign AS
SELECT
  Document.PurchaseContractItem AS PurchaseContractItem,
  Document.AccountAssignment AS AccountAssignment,
  Document.PurchaseContract AS PurchaseContract,
  Document.PurchaseContractForEdit AS PurchaseContractForEdit,
  Document.PurchaseContractItemForEdit AS PurchaseContractItemForEdit,
  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 AS ProfitabilitySegment,
  Document.ProfitCenter AS ProfitCenter,
  Document.WBSElementInternalID AS WBSElementInternalID,
  Document.WBSElementExternalID AS WBSElement,
  Document.WBSDescription AS WBSDescription,
  Document.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  Document.CommitmentItem AS CommitmentItem,
  Document.Fund AS Fund,
  Document.FunctionalArea AS FunctionalArea,
  Document.GoodsRecipientName AS GoodsRecipientName,
  Document.IsFinallyInvoiced AS IsFinallyInvoiced,
  Document.RealEstateObject AS RealEstateObject,
  Document.NetworkActivityInternalID AS NetworkActivityInternalID,
  Document.PartnerAccountNumber AS PartnerAccountNumber,
  Document.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  Document.SettlementReferenceDate AS SettlementReferenceDate,
  Document.OrderInternalID AS OrderInternalID,
  cast (Document.OrderIntBillOfOperationsItem as mm_oa_co_aplzl) AS OrderIntBillOfOperationsItem,
  Document.TaxCode AS TaxCode,
  Document.TaxJurisdiction AS TaxJurisdiction,
  Document.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  Document.CostCtrActivityType AS CostCtrActivityType,
  Document.GrantID AS GrantID,
  Document.BudgetPeriod AS BudgetPeriod,
  Document.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  Document.ValidityDate AS ValidityDate,
  _PurchaseContractWD.CompanyCode AS CompanyCode,
  Document.DocumentCurrency AS DocumentCurrency,
  Document.OrderQuantityUnit AS OrderQuantityUnit
FROM I_PurCtrAccountWD AS Document
LEFT OUTER JOIN C_ContractMaintain AS _PurchaseContractWD ON PurchaseContract = _PurchaseContractWD.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_ContractMaintainItem AS _PurchaseContractItemWD ON PurchaseContractItem = _PurchaseContractItemWD.PurchaseContractItem AND PurchaseContract = _PurchaseContractItemWD.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON companycode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_MM_InternalOrderVH AS _MM_InternalOrderVH ON OrderID = _MM_InternalOrderVH.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_MM_ProfitCenterValueHelp AS _MM_ProfitCenterValueHelp ON ControllingArea = _MM_ProfitCenterValueHelp.ControllingArea AND ProfitCenter = _MM_ProfitCenterValueHelp.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_MM_ProjectNetworkVH AS _MM_ProjectNetworkVH ON ProjectNetwork = _MM_ProjectNetworkVH.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_MM_WBSElementValueHelp AS _MM_WBSElementValueHelp ON WBSElementInternalID = _MM_WBSElementValueHelp.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementByInternalKeyVH ON WBSElementInternalID = _WBSElementByInternalKeyVH.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_MM_CommitmentItemVH AS _MM_CommitmentItemVH ON CommitmentItem = _MM_CommitmentItemVH.CommitmentItem  -- association [0..*]
LEFT OUTER JOIN I_FundStdVH AS _FundStdVH ON Fund = _FundStdVH.Fund  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodStdVH AS _BudgetPeriodStdVH ON _BudgetPeriodStdVH.BudgetPeriod = BudgetPeriod  -- association [0..1]
;