R_SourcingSupplierListDraft

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_SourcingSupplierListDraft.
-- 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_SourcingSupplierListDraft AS
SELECT
  SourcingSupplierListUUID,
  SourcingSupplierList,
  SourcingSupplierListName,
  SrcgSuplrListLifecycleStatus,
  SrcgSuplrListHasPurgCategory,
  SuplrListReferenceObjectUUID,
  SupplierListReferenceObject,
  SuplrListReferenceObjectType,
  SourceSupplierListUUID,
  SupplierListUpdateType,
  SrcgSuplrListChgIsInWorkflow,
  SrcgSuplrListApprvlDueDateTime,
  IsDeleted,
  IsEndOfPurposeBlocked,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  SourcingSupplierListVersion,
  SrcgSuplrListVersionIsLatest,
  SupplierListUUID,
  SupplierListName,
  SourcingSupplierListActionCode,
  SrcgSuplrListSrcgProjHasError,
  PurchasingOrganization,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM mmsrcslist2_d AS _SourcingSupplierListDraft
LEFT OUTER JOIN R_SrcgSuplrListCompanyCode AS _SrcgSuplrListCompanyCode ON SourcingSupplierListUUID = _SrcgSuplrListCompanyCode.SourcingSupplierListUUID  -- association [1..*]
LEFT OUTER JOIN R_SrcgSuplrListMaterialGroup AS _SrcgSuplrListMaterialGroup ON SourcingSupplierListUUID = _SrcgSuplrListMaterialGroup.SourcingSupplierListUUID  -- association [1..*]
LEFT OUTER JOIN R_SrcgSuplrListPurgCategory AS _SrcgSuplrListPurgCategory ON SourcingSupplierListUUID = _SrcgSuplrListPurgCategory.SourcingSupplierListUUID  -- association [1..*]
LEFT OUTER JOIN R_SrcgSuplrListCompanyCodeDrft AS _SrcgSuplrListCompanyCodeDraft ON SourcingSupplierListUUID = _SrcgSuplrListCompanyCodeDraft.SourcingSupplierListUUID  -- association [1..*]
LEFT OUTER JOIN R_SrcgSuplrListMatlGroupDraft AS _SrcgSuplrListMatlGroupDraft ON SourcingSupplierListUUID = _SrcgSuplrListMatlGroupDraft.SourcingSupplierListUUID  -- association [1..*]
LEFT OUTER JOIN R_SrcgSuplrListPurgCatDraft AS _SrcgSuplrListPurgCatDraft ON SourcingSupplierListUUID = _SrcgSuplrListPurgCatDraft.SourcingSupplierListUUID  -- association [1..*]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN E_SourcingSupplierListDraft AS _Extension ON SourcingSupplierListUUID = _Extension.SourcingSupplierListUUID  -- association [1..1]
;