C_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 C_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: CPOACCTASSTP

CREATE VIEW C_PurOrdAcctAssignmentTP AS
SELECT
  PurOrdAcctAssignmentTP.PurchaseOrderItem AS PurchaseOrderItem,
  PurOrdAcctAssignmentTP.PurchaseOrder AS PurchaseOrder,
  PurOrdAcctAssignmentTP.AccountAssignmentNumber AS AccountAssignmentNumber,
  PurOrdAcctAssignmentTP.AccountAssignmentCategory AS AccountAssignmentCategory,
  PurOrdAcctAssignmentTP.CompanyCode AS CompanyCode,
  PurOrdAcctAssignmentTP.CostCenter AS CostCenter,
  PurOrdAcctAssignmentTP.MasterFixedAsset AS MasterFixedAsset,
  PurOrdAcctAssignmentTP.FixedAsset AS FixedAsset,
  PurOrdAcctAssignmentTP.ProjectNetwork AS ProjectNetwork,
  PurOrdAcctAssignmentTP.NetworkActivity AS NetworkActivity,
  PurOrdAcctAssignmentTP.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  PurOrdAcctAssignmentTP.IsDeleted AS IsDeleted,
  PurOrdAcctAssignmentTP.GLAccount AS GLAccount,
  PurOrdAcctAssignmentTP.BusinessArea AS BusinessArea,
  PurOrdAcctAssignmentTP.SalesOrder AS SalesOrder,
  PurOrdAcctAssignmentTP.SalesOrderItem AS SalesOrderItem,
  PurOrdAcctAssignmentTP.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  PurOrdAcctAssignmentTP.OrderID AS OrderID,
  PurOrdAcctAssignmentTP.OrderOperation AS OrderOperation,
  PurOrdAcctAssignmentTP.UnloadingPointName AS UnloadingPointName,
  PurOrdAcctAssignmentTP.ControllingArea AS ControllingArea,
  PurOrdAcctAssignmentTP.CostObject AS CostObject,
  PurOrdAcctAssignmentTP.ProfitabilitySegment AS ProfitabilitySegment,
  PurOrdAcctAssignmentTP.ProfitCenter AS ProfitCenter,
  PurOrdAcctAssignmentTP.WBSElementExternalID AS WBSElementExternalID,
  PurOrdAcctAssignmentTP.WBSElementInternalID AS WBSElementInternalID,
  PurOrdAcctAssignmentTP.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  PurOrdAcctAssignmentTP.CommitmentItem AS CommitmentItem,
  PurOrdAcctAssignmentTP.FundsCenter AS FundsCenter,
  PurOrdAcctAssignmentTP.Fund AS Fund,
  PurOrdAcctAssignmentTP.FunctionalArea AS FunctionalArea,
  PurOrdAcctAssignmentTP.FundedProgram AS FundedProgram,
  PurOrdAcctAssignmentTP.LastChangedDate AS LastChangedDate,
  PurOrdAcctAssignmentTP.GoodsRecipientName AS GoodsRecipientName,
  PurOrdAcctAssignmentTP.IsFinallyInvoiced AS IsFinallyInvoiced,
  PurOrdAcctAssignmentTP.RealEstateObject AS RealEstateObject,
  PurOrdAcctAssignmentTP.NetworkActivityInternalID AS NetworkActivityInternalID,
  PurOrdAcctAssignmentTP.PartnerAccountNumber AS PartnerAccountNumber,
  PurOrdAcctAssignmentTP.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  PurOrdAcctAssignmentTP.SettlementReferenceDate AS SettlementReferenceDate,
  PurOrdAcctAssignmentTP.OrderInternalID AS OrderInternalID,
  PurOrdAcctAssignmentTP.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  PurOrdAcctAssignmentTP.TaxCode AS TaxCode,
  PurOrdAcctAssignmentTP.TaxJurisdiction AS TaxJurisdiction,
  PurOrdAcctAssignmentTP.CostCtrActivityType AS CostCtrActivityType,
  PurOrdAcctAssignmentTP.BusinessProcess AS BusinessProcess,
  PurOrdAcctAssignmentTP.GrantID AS GrantID,
  PurOrdAcctAssignmentTP.BudgetPeriod AS BudgetPeriod,
  PurOrdAcctAssignmentTP.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  PurOrdAcctAssignmentTP.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  PurOrdAcctAssignmentTP.FinancialManagementArea AS FinancialManagementArea,
  PurOrdAcctAssignmentTP.ServiceDocumentType AS ServiceDocumentType,
  PurOrdAcctAssignmentTP.ServiceDocument AS ServiceDocument,
  PurOrdAcctAssignmentTP.ServiceDocumentItem AS ServiceDocumentItem,
  PurOrdAcctAssignmentTP.ValidityDate AS ValidityDate,
  PurOrdAcctAssignmentTP.ChartOfAccounts AS ChartOfAccounts,
  PurOrdAcctAssignmentTP.HighestMessageSeverityLevel AS HighestMessageSeverityLevel,
  _PurOrdCustProj.CustomerProjectName AS ProjectName,
  _PurOrdCustProj.CustProjWorkPackageName AS WorkPackageName,
  _FundStdVH.FundName AS FundName,
  _GrantStdVH.GrantName AS GrantName,
  _BudgetPeriodStdVH.BudgetPeriodName AS BudgetPeriodName,
  PurOrdAcctAssignmentTP._BusinessArea AS _BusinessArea,
  PurOrdAcctAssignmentTP._ProfitCenterText AS _ProfitCenterText,
  PurOrdAcctAssignmentTP._CostCenterText AS _CostCenterText,
  PurOrdAcctAssignmentTP._FunctionalArea AS _FunctionalArea,
  PurOrdAcctAssignmentTP._FunctionalAreaText AS _FunctionalAreaText,
  PurOrdAcctAssignmentTP._BusinessProcess AS _BusinessProcess,
  PurOrdAcctAssignmentTP._TaxCode AS _TaxCode,
  PurOrdAcctAssignmentTP._TaxJurisdiction AS _TaxJurisdiction
FROM I_PurOrdAcctAssignmentTP AS PurOrdAcctAssignmentTP
LEFT OUTER JOIN C_PurchaseOrderTP AS _PurchaseOrderTP ON PurchaseOrder = _PurchaseOrderTP.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderItemTP AS _PurchaseOrderItemTP ON PurchaseOrder = _PurchaseOrderItemTP.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItemTP.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN P_Purordmaintaincustproj AS _PurOrdCustProj ON WBSElementInternalID = _PurOrdCustProj.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN C_PurOrdWBSValHelp AS _WBSElementVH ON WBSElementExternalID = _WBSElementVH.WBSElementExternalID AND WorkPackageName = _WBSElementVH.WorkPackageName AND ProjectName = _WBSElementVH.ProjectName AND CompanyCode = _WBSElementVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MM_ProjectNetworkVH AS _ProjectNetworkVH ON ProjectNetwork = _ProjectNetworkVH.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_MM_NetworkActivityVH AS _NetworkActivityVH ON NetworkActivity = _NetworkActivityVH.NetworkActivity AND ProjectNetwork = _NetworkActivityVH.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_MM_FixedAssetValueHelp AS _FixedAssetValueHelp ON MasterFixedAsset = _FixedAssetValueHelp.MasterFixedAsset AND FixedAsset = _FixedAssetValueHelp.FixedAsset AND CompanyCode = _FixedAssetValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MM_CostCenterValueHelp AS _CostCenterValueHelp ON CostCenter = _CostCenterValueHelp.CostCenter AND ControllingArea = _CostCenterValueHelp.ControllingArea AND ValidityDate <= _CostCenterValueHelp.ValidityEndDate AND ValidityDate >= _CostCenterValueHelp.ValidityStartDate  -- association [0..1]
LEFT OUTER JOIN I_MM_SalesOrderItemVH AS _SalesOrderItemValueHelp ON SalesOrderItem = _SalesOrderItemValueHelp.SalesOrderItem AND SalesOrder = _SalesOrderItemValueHelp.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_MM_GLAccountVH AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_PurOrdActACatValHelp AS _PurOrdActACatValHelp ON AccountAssignmentCategory = _PurOrdActACatValHelp.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN C_MM_CompanyCodeValueHelp AS _CompanyCodeValueHelp ON CompanyCode = _CompanyCodeValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FundStdVH AS _FundStdVH ON Fund = _FundStdVH.Fund AND FinancialManagementArea = _FundStdVH.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_GrantStdVH AS _GrantStdVH ON GrantID = _GrantStdVH.GrantID  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodStdVH AS _BudgetPeriodStdVH ON BudgetPeriod = _BudgetPeriodStdVH.BudgetPeriod  -- association [0..1]
;