C_PurOrdItm

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_PurOrdItm.
-- 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: CPURGDOCITEMSPO

CREATE VIEW C_PurOrdItm AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  AccountAssignmentNumber,
  PurgDocMigrtnIsCmpltdForAnlyts,
  FormattedPurchaseOrderItem,
  PurchaseOrderItemText AS MaterialDocumentItemText,
  PurchaseOrderType,
  AccountAssignmentCategory,
  _AccAssignCatVH.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  SupplyingPlant,
  SupplyingPlantName,
  DeliveryDate,
  PurchasingDocumentType,
  PurchasingDocumentTypeName,
  PurgDocExternalItemCategory AS PurchasingDocumentItemCategory,
  PurgDocItemCategoryName,
  PurchaseOrder AS PurchasingDocument,
  MaterialGroup,
  _MaterialGroupVH.MaterialGroupName AS MaterialGroupName,
  Material,
  _MaterialVH.MaterialName AS MaterialName,
  PurchasingOrganization,
  _PurchasingOrganizationVH.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  PurchasingGroupName,
  CompanyCode,
  CompanyCodeName,
  Plant,
  PlantName,
  StorageLocation,
  StorageLocationName,
  Supplier,
  SupplierName,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName AS PurgCatName,
  ServicePerformer,
  _ServicePerformerVH.ServicePerformerName AS ServicePerformerName,
  ProductType,
  _ProductType._Text[1: Language = $session.system_language ].Name AS ProductTypeName,
  IsReturnsItem,
  PurchaseOrderDate,
  CreatedByUser,
  _UserContactCard.FullName AS FullName,
  CreationDate,
  Status,
  PurchasingDocumentStatusName,
  ObjectType,
  CostCenter,
  CostCenterName,
  SalesOrder,
  DeliveryDate AS ScheduleLineDeliveryDate,
  ScheduleLineOpenQty,
  NetPriceAmount,
  NetPriceQuantity,
  NetAmount,
  GoodsReceiptQuantity,
  GoodsReceiptAmount,
  InvoiceReceiptQty,
  InvoiceRcptAmtInCoCodeCrcy,
  StillToBeDeliveredQuantity,
  StillToBeDeliveredValue,
  StillToInvoiceQuantity,
  StillToInvoiceValue,
  OrderPriceUnit,
  PurchaseOrderQuantityUnit,
  DocumentCurrency,
  CompanyCodeCurrency,
  IsBusinessPurposeCompleted,
  WorkItem,
  WBSElementExternalID,
  WBSElementObject,
  _CustProjectWorkPackage.CustProjWorkPackageFullName AS CustProjWorkPackageFullName
FROM P_PurOrdItm
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON CreatedByUser = _UserContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_CustomerProjectWorkPackage AS _CustProjectWorkPackage ON WBSElementObject = _CustProjectWorkPackage.WBSElementObject  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _MaterialVH ON _MaterialVH.Material = Material AND _MaterialVH.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN C_MM_AccountAssignCatValueHelp AS _AccAssignCatVH ON AccountAssignmentCategory = _AccAssignCatVH.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN C_MassUpdtPurOrdVH AS _PurchaseOrderVH ON PurchaseOrder = _PurchaseOrderVH.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderVH.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupVH ON MaterialGroup = _MaterialGroupVH.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrganizationVH ON PurchasingOrganization = _PurchasingOrganizationVH.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_MM_ServicePerformerValueHelp AS _ServicePerformerVH ON ServicePerformer = _ServicePerformerVH.ServicePerformer AND Supplier = _ServicePerformerVH.Supplier  -- association [0..1]
;