R_SourcingProjectDraft

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_SourcingProjectDraft.
-- 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_SourcingProjectDraft AS
SELECT
  SourcingProjectUUID,
  SourcingProject,
  SourcingProjectVersion,
  SourcingProjectType,
  SourcingProjectName,
  cast( bintohex(sourcingprojectuuid) as vdm_srcgprojuuidascharacter ) AS SourcingProjectUUIDAsCharacter,
  cast( concat( bintohex(sourcingprojectuuid), '01' ) as vdm_srcgprojattachmentuuid ) AS SourcingProjectAttachmentKey,
  cast( 'SourcingProject' as sap_object_node_type_raw ) AS SAPObjectNodeType,
  SrcgProjLifecycleStatus,
  SrcgProjTemplateLfcycSts,
  SrcgProjApprovalStatus,
  SourcingProjectPhase,
  SrcgProjRevisionSts,
  SrcgProjActvtnSts,
  SrcgProjPubgSts,
  SourcingSupplierListUUID,
  CompanyCode,
  PurchasingGroup,
  PurchasingOrganization,
  MaterialGroup,
  PurchasingCategory,
  DocumentCurrency,
  SrcgProjTotalTargetAmount,
  PurchaserRespWorkAgreement,
  PurchaserResponsiblePerson,
  SrcgProjTmplResponsiblePerson,
  QtnLatestSubmissionDateTime,
  LastChangedByUser,
  CreatedByUser,
  LastChangeDateTime,
  CreationDateTime,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  CashDiscount1Percent,
  CashDiscount2Percent,
  NetPaymentDays,
  SrcgProjPubgDteTme,
  SrcgProjCancDteTme,
  SrcgProjAttchsAreForbidden,
  SrcgProjNotesAreForbidden,
  SourcingProjectIsTemplate,
  SrcgProjFollowOnDocumentCat,
  SrcgProjFollowOnDocumentType,
  PurContrValidityStartDate,
  PurContrValidityEndDate,
  ExchangeRateType,
  SourcingOrigin,
  SourcingScenario,
  ExternalSourcingProjectRef,
  LogicalSystem,
  ShippingInstruction,
  SourceSourcingProjectUUID,
  ProcurementPlanningBundleUUID,
  CentralPurchaseContract,
  SourcingProjectVersioningRsn,
  SrcgProjPaymentTermIsManual,
  SrcgProjEarliestCndnSelDate,
  SrcgProjCancellationRsn,
  SrcPrjTotTgtAmtHasOverflowErr,
  SrcgProjPurgCategoryIsUsed,
  SourcingProjectUniqueID,
  SrcgProjHasBeenActivated,
  SourcingProjectTypeForEdit,
  PurchasingOrganizationForEdit,
  PurchasingGroupForEdit,
  CompanyCodeForEdit,
  MaterialGroupForEdit,
  PurchasingCategoryForEdit,
  SrcgProjActiveBackgroundJob,
  LogNumber,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM mmsrcgproj_d AS SourcingProjectDraft
LEFT OUTER JOIN E_SourcingProjectD AS _Extension ON SourcingProjectUUID = _Extension.SourcingProjectUUID  -- association [1..1]
LEFT OUTER JOIN R_SrcgProjContributionForUser AS _ContributionForUser ON SourcingProjectUUID = _ContributionForUser.SourcingProjectUUID  -- association [0..1]
;