R_CustomerMaterialDraft

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 R_CustomerMaterialDraft.
-- 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.

CREATE VIEW R_CustomerMaterialDraft AS
SELECT
  CustomerMaterialDraft.salesorganization AS SalesOrganization,
  CustomerMaterialDraft.distributionchannel AS DistributionChannel,
  CustomerMaterialDraft.product AS Product,
  CustomerMaterialDraft.customer AS Customer,
  CustomerMaterialDraft.draftuuid AS DraftUUID,
  CustomerMaterialDraft.salesorganizationforedit AS SalesOrganizationForEdit,
  CustomerMaterialDraft.distributionchannelforedit AS DistributionChannelForEdit,
  CustomerMaterialDraft.customerforedit AS CustomerForEdit,
  CustomerMaterialDraft.productforedit AS ProductForEdit,
  CustomerMaterialDraft.materialbycustomer AS MaterialByCustomer,
  CustomerMaterialDraft.materialdescriptionbycustomer AS MaterialDescriptionByCustomer,
  CustomerMaterialDraft.customermaterialsearchterm AS CustomerMaterialSearchTerm,
  CustomerMaterialDraft.roundingprofile AS RoundingProfile,
  CustomerMaterialDraft.plant AS Plant,
  CustomerMaterialDraft.deliverypriority AS DeliveryPriority,
  CustomerMaterialDraft.mindeliveryqtyinbaseunit AS MinDeliveryQtyInBaseUnit,
  CustomerMaterialDraft.baseunit AS BaseUnit,
  CustomerMaterialDraft.partialdeliveryisallowed AS PartialDeliveryIsAllowed,
  CustomerMaterialDraft.maxnmbrofpartialdelivery AS MaxNmbrOfPartialDelivery,
  CustomerMaterialDraft.underdelivtolrtdlmtratioinpct AS UnderdelivTolrtdLmtRatioInPct,
  CustomerMaterialDraft.overdelivtolrtdlmtratioinpct AS OverdelivTolrtdLmtRatioInPct,
  CustomerMaterialDraft.unlimitedoverdeliveryisallowed AS UnlimitedOverdeliveryIsAllowed,
  CustomerMaterialDraft.customermaterialitemusage AS CustomerMaterialItemUsage,
  CustomerMaterialDraft.salesunit AS SalesUnit,
  CustomerMaterialDraft.salesqtytobaseqtydnmntr AS SalesQtyToBaseQtyDnmntr,
  CustomerMaterialDraft.salesqtytobaseqtynmrtr AS SalesQtyToBaseQtyNmrtr,
  CustomerMaterialDraft.lastchangedbyuser AS LastChangedByUser,
  CustomerMaterialDraft.lastchangedatetime AS LastChangeDateTime,
  CustomerMaterialDraft.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  CustomerMaterialDraft.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  CustomerMaterialDraft.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  CustomerMaterialDraft.draftentityoperationcode AS DraftEntityOperationCode,
  CustomerMaterialDraft.hasactiveentity AS HasActiveEntity,
  CustomerMaterialDraft.draftfieldchanges AS DraftFieldChanges
FROM sdcustmat_d AS CustomerMaterialDraft
INNER JOIN sdraft_admin ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN E_CustomerMaterialDraft AS _Extension ON Product = _Extension.Material AND Customer = _Extension.Customer AND SalesOrganization = _Extension.SalesOrganization AND DistributionChannel = _Extension.DistributionChannel AND DraftUUID = _Extension.DraftUUID  -- association [0..1]
;