C_PurDocListPODtl

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_PurDocListPODtl.
-- 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: CDOCLPODTL

CREATE VIEW C_PurDocListPODtl AS
SELECT
  poall.PurchaseOrderItem AS PurchaseOrderItem,
  poall.AccountAssignmentNumber AS AccountAssignmentNumber,
  _Sup_addr.SupplierAddressCity AS SupplierAddressCity,
  poall.PurchaseOrderItemText AS PurchaseOrderItemText,
  poall.Material AS Material,
  poall.MaterialGroup AS MaterialGroup,
  poall.Plant AS Plant,
  poall.BaseUnit AS BaseUnit,
  poall.StorageLocation AS StorageLocation,
  poall.CompanyCode AS CompanyCode,
  poall.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  poall.PurchaseOrderPriceUnit AS PurchaseOrderPriceUnit,
  poall.AcctAssignmentCategory AS AcctAssignmentCategory,
  poall.IsDeletedItem AS IsDeletedItem,
  poall.ManufacturerMaterial AS ManufacturerMaterial,
  poall.MfrPartNumber AS MfrPartNumber,
  poall.PurchaseOrderQty AS PurchaseOrderQty,
  poall.PurchaseOrderNetPriceQuantity AS PurchaseOrderNetPriceQuantity,
  poall.PurchaseOrderNetPriceAmount AS PurchaseOrderNetPriceAmount,
  poall.PurchaseOrderNetAmount AS PurchaseOrderNetAmount,
  poall.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  poall.ItemIsStatistical AS ItemIsStatistical,
  poall.IsReturnsItem AS IsReturnsItem,
  poall.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  poall.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  poall.IsCompletelyDelivered AS IsCompletelyDelivered,
  poall.IsFinallyInvoiced AS IsFinallyInvoiced,
  poall.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  poall.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  poall.InvoiceIsExpected AS InvoiceIsExpected,
  poall.ServicePerformer AS ServicePerformer,
  _ServicePerformer.BusinessPartnerName AS ServicePerformerName,
  cast('' as abap.char(10)) AS WorkItem,
  COALESCE( poall.WBSElementExternalID, '') AS WBSElementExternalID,
  poall.SalesOrder AS SalesOrder,
  poall.SalesOrderItem AS SalesOrderItem,
  COALESCE( poall.WorkPackageFullName, '') AS WorkPackageFullName,
  poall.WBSDescription AS WBSDescription,
  poall.CostCenter AS CostCenter,
  _CCText.CostCenterName AS CostCenterName,
  poall.ControllingArea AS ControllingArea,
  cast ('F' as abap.char( 1 )) AS PurchasingDocumentCategory,
  poall.purchasingDocumentType AS purchasingDocumentType,
  poall.LastChangeDate AS LastChangeDate,
  poall.CreatedByUser AS CreatedByUser,
  poall.PaymentTerms AS PaymentTerms,
  poall.PurchasingOrganization AS PurchasingOrganization,
  poall.PurchasingGroup AS PurchasingGroup,
  poall.Currency AS Currency,
  poall.PurchaseOrderDate AS PurchaseOrderDate,
  poall.DeliveryDate AS DeliveryDate,
  poall.SupplyingPlant AS SupplyingPlant,
  _SupplyingPlant.PlantName AS SupplyingPlantName,
  poall.IsDeletedHeader AS IsDeletedHeader,
  poall.SupplyingVendorName AS SupplyingVendorName,
  poall.PurchasingGroupName AS PurchasingGroupName,
  poall.PurchasingOrganizationName AS PurchasingOrganizationName,
  poall.CompanyCodeName AS CompanyCodeName,
  poall.PlantName AS PlantName,
  poall.GoodsReceiptQuantity AS GoodsReceiptQuantity,
  poall.GoodsReceiptValue AS GoodsReceiptValue,
  poall.InvoiceReceiptQuantity AS InvoiceReceiptQuantity,
  poall.InvoiceReceiptValue AS InvoiceReceiptValue,
  poall.DocumentCurrency AS DocumentCurrency,
  poall.qtymismatch AS qtymismatch,
  poall.confmiss AS confmiss,
  poall.wesbs AS wesbs,
  poall.GoodsReceiptIsExpected AS postgr,
  cast(0 as abap.int4) AS cntk,
  cast(0 as abap.int4) AS cntl,
  cast(0 as abap.curr(19,2)) AS releasevalue,
  poall.sosname AS SupplierName,
  poall.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
LEFT OUTER JOIN I_CountryText AS _CountryName ON SupplierAddressCountry = _CountryName.Country  -- association [0..*]
LEFT OUTER JOIN C_Purdoclistsuppaddr AS _Sup_addr ON supplier = _Sup_addr.Supplier  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MatText ON Material = _MatText.Material  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _ServicePerformer ON ServicePerformer = _ServicePerformer.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MatGroupText ON MaterialGroup = _MatGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN dd07t AS _StatusText ON status = _StatusText.domvalue_l AND _StatusText.domname = 'MMPUR_DOC_STATUS' AND _StatusText.as4local = 'A'  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocument AS _HeaderExtension ON PurchaseOrder = _HeaderExtension.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _Extension ON PurchaseOrder = _Extension.PurchasingDocument AND PurchaseOrderItem = _Extension.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItemRelevance AS _OvdPoAvgRel ON PurchaseOrder = _OvdPoAvgRel.PurchaseOrder AND PurchaseOrderItem = _OvdPoAvgRel.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SupplyingPlant ON SupplyingPlant = _SupplyingPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_PurgDocumentItemCategoryText AS _ItemCategoryText ON PurchaseOrderItemCategory = _ItemCategoryText.PurchasingDocumentItemCategory  -- association [0..*]
LEFT OUTER JOIN I_AcctAssignmentCategoryText AS _AcctAssignmentCategoryText ON AcctAssignmentCategory = _AcctAssignmentCategoryText.AccountAssignmentCategory  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON purchasingDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType AND PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CCText ON _CCText.CostCenter = CostCenter AND _CCText.ControllingArea = ControllingArea AND _CCText.Language = $session.system_language AND _CCText.ValidityStartDate <= $session.system_date AND _CCText.ValidityEndDate >= $session.system_date  -- association [1..1]
;