I_PurOrdAccountAssignment

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_PurOrdAccountAssignment.
-- 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: IMMPUROACCASS

CREATE VIEW I_PurOrdAccountAssignment AS
SELECT
  AccAss.PurchasingDocument AS PurchaseOrder,
  AccAss.PurchasingDocumentItem AS PurchaseOrderItem,
  AccAss.AccountAssignmentNumber AS AccountAssignmentNumber,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccAss.CostCenter AS CostCenter,
  AccAss.MasterFixedAsset AS MasterFixedAsset,
  AccAss.ProjectNetwork AS ProjectNetwork,
  cast( _NetworkActivity_2.NetworkActivity as ps_s4_vornr preserving type ) AS NetworkActivity,
  AccAss.OrderQuantityUnit AS OrderQuantityUnit,
  AccAss.Quantity AS Quantity,
  AccAss.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  AccAss.DocumentCurrency AS DocumentCurrency,
  AccAss.PurgDocNetAmount AS PurgDocNetAmount,
  AccAss.IsDeleted AS IsDeleted,
  AccAss.GLAccount AS GLAccount,
  AccAss.BusinessArea AS BusinessArea,
  AccAss.SalesOrder AS SalesOrder,
  AccAss.SalesOrderItem AS SalesOrderItem,
  AccAss.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  AccAss.FixedAsset AS FixedAsset,
  AccAss.OrderID AS OrderID,
  cast ('' as vdm_vornr ) AS OrderOperation,
  AccAss.UnloadingPointName AS UnloadingPointName,
  AccAss.ControllingArea AS ControllingArea,
  AccAss.CostObject AS CostObject,
  AccAss.ProfitabilitySegment_2 AS ProfitabilitySegment,
  AccAss.ProfitabilitySegment_2 AS ProfitabilitySegment_2,
  AccAss.ProfitCenter AS ProfitCenter,
  AccAss.WBSElementInternalID AS WBSElementInternalID,
  cast (AccAss.WBSElementInternalID as ps_s4_pspnr preserving type ) AS WBSElementInternalID_2,
  AccAss._WBSElement.WBSElementExternalID AS WBSElementExternalID,
  AccAss.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  AccAss.CommitmentItem AS CommitmentItem,
  AccAss.CommitmentItemShortID AS CommitmentItemShortID,
  AccAss.FundsCenter AS FundsCenter,
  AccAss.Fund AS Fund,
  AccAss.FunctionalArea AS FunctionalArea,
  AccAss.LastChangedDate AS LastChangedDate,
  AccAss.GoodsRecepientName AS GoodsRecipientName,
  AccAss.IsFinallyInvoiced AS IsFinallyInvoiced,
  cast ( AccAss.REInternalFinNumber as imkey preserving type ) AS RealEstateObject,
  AccAss.REInternalFinNumber AS REInternalFinNumber,
  AccAss.NetworkActivityInternalID AS NetworkActivityInternalID,
  AccAss.PartnerAccountNumber AS PartnerAccountNumber,
  AccAss.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  AccAss.SettlementReferenceDate AS SettlementReferenceDate,
  AccAss.OrderInternalID AS OrderInternalID,
  AccAss.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  AccAss.TaxCode AS TaxCode,
  AccAss.TaxJurisdiction AS TaxJurisdiction,
  AccAss.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  AccAss.CostCtrActivityType AS CostCtrActivityType,
  AccAss.BusinessProcess AS BusinessProcess,
  AccAss.GrantID AS GrantID,
  AccAss.BudgetPeriod AS BudgetPeriod,
  AccAss.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  AccAss.EarmarkedFundsItem AS EarmarkedFundsItem,
  AccAss.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  AccAss.ValidityDate AS ValidityDate,
  AccAss.ChartOfAccounts AS ChartOfAccounts,
  AccAss.ServiceDocumentType AS ServiceDocumentType,
  AccAss.ServiceDocument AS ServiceDocument,
  AccAss.ServiceDocumentItem AS ServiceDocumentItem,
  AccAss.PubSecSplitBatchNumberID AS PubSecSplitBatchNumberID,
  AccAss.PubSecSplitAuthznGroup AS PubSecSplitAuthznGroup,
  AccAss.CreationDate AS CreationDate,
  AccAss.IsAcctLineFinal AS IsAcctLineFinal,
  AccAss.AcctLineFinalReason AS AcctLineFinalReason,
  _PurchaseOrder.CompanyCode AS CompanyCode
FROM I_PurgDocAccountAssignment AS AccAss
INNER JOIN I_PurchaseOrderItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_NetworkActivity AS _NetworkActivity ON ProjectNetwork = _NetworkActivity.ProjectNetwork AND ProjectNetworkInternalID = _NetworkActivity.ProjectNetworkInternalID AND NetworkActivityInternalID = _NetworkActivity.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN I_NetworkActivityByInternalKey AS _NetworkActivity_2 ON ProjectNetworkInternalID = _NetworkActivity_2.ProjectNetworkInternalID AND NetworkActivityInternalID = _NetworkActivity_2.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN E_PurgDocAccountAssignment AS _PurOrdAcctAssgmtExtension ON PurchaseOrder = _PurOrdAcctAssgmtExtension.PurchasingDocument AND PurchaseOrderItem = _PurOrdAcctAssgmtExtension.PurchasingDocumentItem AND AccountAssignmentNumber = _PurOrdAcctAssgmtExtension.AccountAssignmentNumber  -- association [0..1]
;