I_PurOrdAcctAssignmentTP

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_PurOrdAcctAssignmentTP.
-- 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: IPOACCTASSTP

CREATE VIEW I_PurOrdAcctAssignmentTP AS
SELECT
  Document.PurchaseOrder AS PurchaseOrder,
  Document.PurchaseOrderItem AS PurchaseOrderItem,
  Document.AccountAssignmentNumber AS AccountAssignmentNumber,
  _PurchaseOrderItemTP.AccountAssignmentCategory AS AccountAssignmentCategory,
  Document.CostCenter AS CostCenter,
  Document.MasterFixedAsset AS MasterFixedAsset,
  Document.ProjectNetwork AS ProjectNetwork,
  cast (Document.NetworkActivity as vornr ) AS NetworkActivity,
  Document.OrderQuantityUnit AS OrderQuantityUnit,
  Document.Quantity AS Quantity,
  Document.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  Document.PurgDocNetAmount AS PurgDocNetAmount,
  Document.DocumentCurrency AS DocumentCurrency,
  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,
  cast( Document.OrderOperation as vornr_auf ) AS OrderOperation,
  Document.UnloadingPointName AS UnloadingPointName,
  Document.ControllingArea AS ControllingArea,
  Document.CostObject AS CostObject,
  Document.ProfitabilitySegment AS ProfitabilitySegment,
  Document.ProfitCenter AS ProfitCenter,
  Document.WBSElementInternalID AS WBSElementInternalID,
  _WBSElement.WBSElement AS WBSElement,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  _WBSElement.WBSDescription AS WBSDescription,
  Document.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  Document.CommitmentItem 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.EarmarkedFundsItem AS EarmarkedFundsItem,
  Document.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  cast (_FundedProgram.FundedProgram as fm_measure) AS FundedProgram,
  Document.ValidityDate AS ValidityDate,
  Document.ChartOfAccounts AS ChartOfAccounts,
  Document.CompanyCode AS CompanyCode,
  Document.ServiceDocumentType AS ServiceDocumentType,
  Document.ServiceDocument AS ServiceDocument,
  Document.ServiceDocumentItem AS ServiceDocumentItem,
  Document.PubSecSplitBatchNumberID AS PubSecSplitBatchNumberID,
  Document.PubSecSplitAuthznGroup AS PubSecSplitAuthznGroup,
  cast ('' as hghstmsgsvrtylvl) AS HighestMessageSeverityLevel,
  cast (' ' as char1 ) AS IsMultipleAccountAssignment,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea
FROM I_PurOrdAccountAssignment AS Document
LEFT OUTER JOIN I_PurchaseOrderTP AS _PurchaseOrderTP ON _PurchaseOrderTP.PurchaseOrder = PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderItemTP AS _PurchaseOrderItemTP ON _PurchaseOrderItemTP.PurchaseOrder = PurchaseOrder AND _PurchaseOrderItemTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementByInternalKey ON _WBSElementByInternalKey.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON _CostCenter.ControllingArea = ControllingArea AND _CostCenter.CostCenter = CostCenter AND _CostCenter.CompanyCode = CompanyCode AND _CostCenter.ValidityEndDate >= ValidityDate AND _CostCenter.ValidityStartDate <= ValidityDate  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode association[0..1] to I_CompanyCode as _CompanyCode on CompanyCode = _CompanyCode.CompanyCode association[0..1] to I_FundedPgmByAcctAssgmtNmbr as _FundedProgram on PurchaseOrder = _FundedProgram.PurchasingDocument AND PurchaseOrderItem = _FundedProgram.PurchasingDocumentItem AND AccountAssignmentNumber = _FundedProgram.AccountAssignmentNumber  -- association [0..1]
;