C_Purchaseorderitemacctmntr

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_Purchaseorderitemacctmntr.
-- 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: CPOMNTRACCASSIGN

CREATE VIEW C_Purchaseorderitemacctmntr AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  AccountAssignmentCategory,
  AccountAssignmentNumber,
  _AccountAssignmentCategory._Text [1: Language = $session.system_language ].AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  FormattedPurchaseOrderItem,
  CompanyCode,
  CompanyCodeName,
  MultipleAcctAssgmtDistrPercent,
  Quantity,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  PurchaseOrderQuantityUnit,
  OrderQuantity,
  DocumentCurrency,
  PurgDocNetAmount,
  NetPriceAmount,
  DisplayCurrency,
  PurchaseOrderItemNetAmount,
  Plant,
  PlantName,
  CostCenter,
  _CostCenter._Text[1: Language = $session.system_language ].CostCenterName AS CostCenterName,
  _WBSElementVH.WBSElement AS WBSElement,
  _WBSElementVH.WBSDescription AS WBSDescription,
  GLAccount,
  _GLAccountText[1: Language = $session.system_language].GLAccountName AS GLAccountName,
  ChartOfAccounts,
  SupplyingPlant,
  SupplyingPlantName,
  ScheduleLineDeliveryDate,
  PurchasingCategory,
  PurgCatName,
  PurgCatUUID,
  WBSElementInternalID,
  MasterFixedAsset,
  MasterFixedAssetDescription,
  Supplier,
  SupplierName,
  SupplierSubrange,
  PurchasingDocumentType,
  _PurchaseOrder._PurchaseOrderType._Text[1:Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  PurchasingOrganization,
  PurchasingOrganizationName,
  PurchasingGroup,
  PurchasingGroupName,
  ProjectNetwork,
  _ProjectNetworkVH.ProjectNetworkDescription AS ProjectNetworkDescription,
  SalesOrder,
  SalesOrderScheduleLine,
  PurchaseOrderItemCategory,
  _PurchaseOrderItem._PurgDocumentItemCategory._Text[1: Language = $session.system_language ].PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  _PurchaseOrderItem._PurgDocumentItemCategory._Text[1: Language = $session.system_language ].PurgDocItemCategoryName AS PurgDocItemCategoryName,
  Material,
  case when _PurchaseOrderItem._Material._Text[1: Language = $session.system_language].MaterialName is null then '' else _PurchaseOrderItem._Material._Text[1: Language = $session.system_language].MaterialName end as MaterialName AS MaterialNameendasMaterialName,
  MaterialGroup,
  _PurchaseOrderItem._MaterialGroup._Text[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  PurchasingDocumentOrderDate,
  StorageLocation,
  StorageLocationName,
  AcctAsgtDistrdStillToInvcAmt,
  StillToBeDeliveredQuantity,
  StillToBeDeliveredValue,
  StillToInvoiceQuantity,
  StillToInvoiceValue,
  PurchasingDocumentStatus,
  PurchasingDocumentStatusName,
  PurchasingInfoRecord,
  TaxCode,
  ControllingArea,
  ControllingAreaName,
  SalesOrderItem,
  FixedAsset,
  FixedAssetDescription,
  BusinessArea,
  _BusinessAreaText[1: Language = $session.system_language].BusinessAreaName AS BusinessAreaName
FROM P_PurchaseOrderItemAcctMntr AS PurOrdAccAssign
LEFT OUTER JOIN I_MM_WBSElementValueHelp AS _WBSElementVH ON PurOrdAccAssign.WBSElementInternalID = _WBSElementVH.WBSElementInternalID  -- 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_CompanyCode AS _CompanyCode ON companycode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount AND ChartOfAccounts = _GLAccountText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN C_OrderMasterVH AS _OrderVH ON OrderID = _OrderVH.OrderID  -- association [0..1]
LEFT OUTER JOIN I_MM_ProfitCenterValueHelp AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter AND ValidityDate <= _ProfitCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND ValidityDate <= _ProfitCenterText.ValidityEndDate AND ValidityDate >= _ProfitCenterText.ValidityStartDate  -- association [0..1]
LEFT OUTER JOIN I_MM_ProjectNetworkVH AS _ProjectNetworkVH ON _ProjectNetworkVH.ProjectNetwork = ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _FundText ON Fund = _FundText.Fund AND _FundText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod AND _BudgetPeriodText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID AND _GrantText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_AccountAssignmentCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
;