I_PurgDocAccountAssignment

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_PurgDocAccountAssignment.
-- 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: IPDACCTASSGMT

CREATE VIEW I_PurgDocAccountAssignment AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  MasterFixedAsset,
  ProjectNetwork,
  _PurchasingDocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  Quantity,
  MultipleAcctAssgmtDistrPercent,
  _PurchasingDocumentItem.DocumentCurrency AS DocumentCurrency,
  PurgDocNetAmount,
  IsDeleted,
  GLAccount,
  BusinessArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  FixedAsset,
  OrderID,
  UnloadingPointName,
  ControllingArea,
  CostObject,
  cast( ProfitabilitySegment as rkeobjnr ) AS ProfitabilitySegment,
  ProfitabilitySegment AS ProfitabilitySegment_2,
  ProfitCenter,
  cast( WBSElementInternalID as ps_psp_pnr ) AS WBSElementInternalID,
  WBSElementInternalID AS WBSElementInternalID_2,
  ProjectNetworkInternalID,
  cast( CommitmentItemShortID as fipos ) AS CommitmentItem,
  CommitmentItemShortID,
  FundsCenter,
  Fund,
  FunctionalArea,
  LastChangedDate,
  CreationDate,
  GoodsRecepientName,
  GoodsRecipientName,
  IsFinallyInvoiced,
  cast( REInternalFinNumber as imkey ) AS RealEstateObject,
  REInternalFinNumber,
  NetworkActivityInternalID,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  OrderInternalID,
  OrderIntBillOfOperationsItem,
  TaxCode,
  TaxJurisdiction,
  NonDeductibleInputTaxAmount,
  CostCtrActivityType,
  BusinessProcess,
  GrantID,
  BudgetPeriod,
  EarmarkedFundsDocument,
  $session.system_date AS ValidityDate,
  _ControllingArea.ChartOfAccounts AS ChartOfAccounts,
  cast( EarmarkedFundsDocumentItem as kblpos) AS EarmarkedFundsItem,
  EarmarkedFundsDocumentItem,
  PubSecSplitBatchNumberID,
  PubSecSplitAuthznGroup,
  IsAcctLineFinal,
  AcctLineFinalReason,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem
FROM I_PurgDocAccountAssignmentBsc
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND ValidityDate <= _CostCenter.ValidityEndDate AND ValidityDate >= _CostCenter.ValidityStartDate  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON CostCenter = _CostCenterText.CostCenter AND ControllingArea = _CostCenterText.ControllingArea AND ValidityDate <= _CostCenterText.ValidityEndDate AND ValidityDate >= _CostCenterText.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount AND ChartOfAccounts = _GLAccountText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter AND ValidityDate <= _ProfitCenter.ValidityEndDate AND ValidityDate >= _ProfitCenter.ValidityStartDate  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND ValidityDate <= _ProfitCenterText.ValidityEndDate  -- 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 = _SalesOrderItem.SalesOrderItem AND SalesOrder = _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 SalesOrder = _SalesDocumentScheduleLine.SalesDocument AND SalesOrderItem = _SalesDocumentScheduleLine.SalesDocumentItem AND SalesOrderScheduleLine = _SalesDocumentScheduleLine.ScheduleLine  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementByInternalKey ON WBSElementInternalID = _WBSElementByInternalKey.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItemShortID AS _CommitmentItemShortID ON CommitmentItemShortID = _CommitmentItemShortID.CommitmentItemShortID  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCenterActivityType ON ControllingArea = _CostCenterActivityType.ControllingArea AND CostCtrActivityType = _CostCenterActivityType.CostCtrActivityType AND ValidityDate <= _CostCenterActivityType.ValidityEndDate AND ValidityDate >= _CostCenterActivityType.ValidityStartDate  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _CostCenterActivityTypeText ON ControllingArea = _CostCenterActivityTypeText.ControllingArea AND CostCtrActivityType = _CostCenterActivityTypeText.CostCtrActivityType AND ValidityDate <= _CostCenterActivityTypeText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_BusinessProcess AS _BusinessProcess ON ControllingArea = _BusinessProcess.ControllingArea AND BusinessProcess = _BusinessProcess.BusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcessText AS _BusinessProcessText ON ControllingArea = _BusinessProcessText.ControllingArea AND BusinessProcess = _BusinessProcessText.BusinessProcess AND ValidityDate <= _BusinessProcessText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON TaxCode = _TaxCode.TaxCode  -- association [0..*]
LEFT OUTER JOIN I_TaxCodeText AS _TaxCodeText ON TaxCode = _TaxCodeText.TaxCode  -- association [0..*]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction  -- association [0..*]
LEFT OUTER JOIN I_TaxJurisdictionText AS _TaxJurisdictionText ON TaxJurisdiction = _TaxJurisdictionText.TaxJurisdiction  -- association [0..*]
LEFT OUTER JOIN I_FixedAsset AS _FixedAssetWorklist ON MasterFixedAsset = _FixedAssetWorklist.MasterFixedAsset AND FixedAsset = _FixedAssetWorklist.FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_FundStdVH AS _FundStdVH ON _FundStdVH.Fund = Fund  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodStdVH AS _BudgetPeriodStdVH ON _BudgetPeriodStdVH.BudgetPeriod = BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsCenterStdVH AS _FundsCenterStdVH ON _FundsCenterStdVH.FundsCenter = FundsCenter association[0..*] to I_CommitmentItemStdVH as _CommitmentItemStdVH on _CommitmentItemStdVH.CommitmentItem = CommitmentItem association[0..*] to I_EmrkdFndsDocumentItemStdVH as _EarmarkedFundsStdVH on _EarmarkedFundsStdVH.EarmarkedFundsDocument = EarmarkedFundsDocument association[0..1] to I_FndsMgmtFuncnlAreaStdVH as _FndsMgmtFuncnlAreaStdVH on _FndsMgmtFuncnlAreaStdVH.FunctionalArea = FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_MM_CostCenterValueHelp AS _MM_CostCenterValueHelp ON CostCenter = _MM_CostCenterValueHelp.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementByInternalKeyVH ON WBSElementInternalID = _WBSElementByInternalKeyVH.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_MM_GLAccountVH AS _MM_GLAccountVH ON GLAccount = _MM_GLAccountVH.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_AcctgServiceDocumentTypeVH AS _AcctgServiceDocumentTypeVH ON ServiceDocumentType = _AcctgServiceDocumentTypeVH.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_AcctgServiceDocumentVH AS _AcctgServiceDocumentVH ON ServiceDocument = _AcctgServiceDocumentVH.ServiceDocument  -- association [0..*]
LEFT OUTER JOIN I_AcctgServiceDocumentItemVH AS _AcctgServiceDocumentItemVH ON ServiceDocumentItem = _AcctgServiceDocumentItemVH.ServiceDocumentItem AND ServiceDocument = _AcctgServiceDocumentItemVH.ServiceDocument  -- association [0..*]
;