P_ConfignOvwPgSalesDocItem

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 P_ConfignOvwPgSalesDocItem.
-- 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: PCONFOVPSALESDOC

CREATE VIEW P_ConfignOvwPgSalesDocItem AS
SELECT
  cast ( I_SalesDocumentItemBasic.SalesDocument as vchclf_sim_conf_object ) AS ConfigurationObject,
  cast ( I_SalesDocumentItemBasic.SalesDocumentItem as vchclf_sim_conf_object_item ) AS ConfigurationObjectItem,
  concat_with_space( concat(ltrim (I_SalesDocumentItemBasic.SalesDocument, '0'), ' /'), ltrim(I_SalesDocumentItemBasic.SalesDocumentItem, '0'), 1) as SalesDocument AS SalesDocumentItem01asSalesDocument,
  Material AS Product,
  _Material._Text[1: Language = $session.system_language].MaterialName AS ProductName,
  _SalesDocumentBasic.SoldToParty AS SoldToParty,
  _SalesDocumentBasic.SalesOrganization AS SalesOrganization,
  _SalesDocumentBasic.RequestedDeliveryDate AS RequestedDeliveryDate,
  _SalesDocumentBasic.SalesDocumentType AS SalesDocumentType,
  _SalesDocumentBasic.OrganizationDivision AS OrganizationDivision,
  _SalesDocumentBasic.DistributionChannel AS DistributionChannel,
  _SalesDocumentBasic.SDDocumentCategory AS SDDocumentCategory,
  OrderQuantity,
  OrderQuantityUnit,
  case when I_SalesDocumentItemBasic.LastChangeDate = '00000000' then I_SalesDocumentItemBasic.CreationDate else I_SalesDocumentItemBasic.LastChangeDate end as LastChangeDate AS LastChangeDateendasLastChangeDate,
  _CreatedByUser.UserDescription AS UserDescription,
  I_SalesDocumentItemBasic.ProductConfiguration AS ProductConfiguration,
  CBase.ConfigurationProfileNumber AS ConfigurationProfileNumber,
  CBase.cstatus AS ConfigurationStatus
FROM I_SalesDocumentItemBasic
INNER JOIN P_IbinValidConfigurations AS CBase ON /* join condition not captured in parsed metadata */
INNER JOIN P_ReleasedConfigurationProfile ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON _SalesOrganizationText.Language = $session.system_language AND salesorganization = _SalesOrganizationText.SalesOrganization  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON soldtoparty = _Customer.Customer  -- association [1..1]
;