C_PurDocListGRDetails

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_PurDocListGRDetails.
-- 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: CDOCLGRDTL

CREATE VIEW C_PurDocListGRDetails AS
SELECT
  C_PurDocListPOHistoryGR.MaterialDocument AS PurchasingDocument,
  C_PurDocListPOHistoryGR.MaterialDocumentItem AS PurchasingDocumentItem,
  C_PurDocListPOHistoryGR.GoodsMovementType AS GoodsMovementType,
  C_PurDocListPOHistoryGR.PurchaseOrder AS PurchaseOrder,
  C_PurDocListPOHistoryGR.MaterialGroup AS MaterialGroup,
  C_PurDocListPOHistoryGR.PurchaseOrderQty AS PurchaseOrderQty,
  C_PurDocListPOHistoryGR.SupplyingPlant AS SupplyingPlant,
  _SupplyingPlant.PlantName AS SupplyingPlantName,
  C_PurDocListPOHistoryGR.Supplier AS Supplier,
  lfa1.name1 AS SupplierName,
  _Sup_addr.SupplierAddressCountry AS SupplierAddressCountry,
  _Sup_addr.SupplierAddressCity AS SupplierAddressCity,
  C_PurDocListPOHistoryGR.PurchasingOrganization AS PurchasingOrganization,
  t024e.PurchasingOrganizationName AS PurchasingOrganizationName,
  C_PurDocListPOHistoryGR.Plant AS Plant,
  t001w.PlantName AS PlantName,
  C_PurDocListPOHistoryGR.PurchaseOrderItemText AS PurchasingDocumentItemText,
  C_PurDocListPOHistoryGR.PurchaseOrderType AS PurchasingDocumentType,
  t024.PurchasingGroupName AS PurchasingGroupName,
  C_PurDocListPOHistoryGR.PurchasingDocumentCategory AS PurchasingDocumentCategory1,
  'G' AS PurchasingDocumentCategory,
  cast('' as abap.char(1)) AS PurchaseOrderItemCategory,
  cast('' as abap.char(1)) AS AccountAssignmentCategory,
  cast('' as abap.char(8)) AS WBSElementInternalID,
  cast('' as ps_posid_edit) AS WBSElementExternalID,
  cast('' as abap.char(110)) AS WorkPackageFullName,
  cast('' as vbeln) AS SalesOrder,
  cast('' as kostl) AS CostCenter,
  cast('' as fis_kostl_name) AS CostCenterName,
  cast('' as fis_kokrs) AS ControllingArea,
  cast(1 as abap.int4) AS cntg,
  C_PurDocListPOHistoryGR.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _MaterialDocumentItem._WorkItem.WorkItem AS WorkItem,
  _MaterialDocumentItem._WorkItem._Text AS _Text,
  _MaterialDocumentItem.ServicePerformer AS ServicePerformer,
  _MaterialDocumentItem._BusinessPartner.BusinessPartnerName AS ServicePerformerName
LEFT OUTER JOIN P_PurOrdSingleScheduleLine AS eket ON PurchaseOrder = eket.PurchasingDocument AND PurchaseOrderItem = eket.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS t024e ON PurchasingOrganization = t024e.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS t024 ON PurchasingGroup = t024.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_Plant AS t001w ON Plant = t001w.Plant  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchasingDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType AND PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MatText ON Material = _MatText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MatGroupText ON MaterialGroup = _MatGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN dd07t AS _StatusText ON GoodsMovementType1 = _StatusText.domvalue_l AND _StatusText.domname = 'MMPUR_DOC_STATUS' AND _StatusText.as4local = 'A'  -- 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 AccountAssignmentCategory = _AcctAssignmentCategoryText.AccountAssignmentCategory  -- association [0..*]
LEFT OUTER JOIN I_MaterialDocumentItem AS _MaterialDocumentItem ON PurchasingDocument = _MaterialDocumentItem.MaterialDocument AND MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear AND PurchasingDocumentItem = _MaterialDocumentItem.MaterialDocumentItem  -- association [1..1]
LEFT OUTER JOIN C_Purdoclistsuppaddr AS _Sup_addr ON Supplier = _Sup_addr.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryName ON SupplierAddressCountry = _CountryName.Country  -- association [0..*]
;