C_SourcingProjectTP_F7757

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_SourcingProjectTP_F7757.
-- 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 C_SourcingProjectTP_F7757 AS
SELECT
  SourcingProjectTP.SourcingProjectUUID AS SourcingProjectUUID,
  SourcingProjectTP.SourcingProject AS SourcingProject,
  SourcingProjectTP.SourcingProjectVersion AS SourcingProjectVersion,
  SourcingProjectTP.SourcingProjectType AS SourcingProjectType,
  SourcingProjectTP._SourcingProjectTypeText[1:Language = $session.system_language].SourcingProjectTypeText AS SourcingProjectTypeText,
  SourcingProjectTP.SourcingProjectName AS SourcingProjectName,
  SourcingProjectTP.SrcgProjApprovalStatus AS SrcgProjApprovalStatus,
  SourcingProjectTP._SrcgProjApprovalStatusText[1:Language = $session.system_language].SrcgProjApprovalStatusName AS SrcgProjApprovalStatusName,
  SourcingProjectTP.SrcgProjLifecycleStatus AS SrcgProjLifecycleStatus,
  SourcingProjectTP._SrcgProjLifecycleStatusText[1:Language = $session.system_language].SrcgProjLifecycleStatusName AS SrcgProjLifecycleStatusName,
  SourcingProjectTP.SourcingProjectPhase AS SourcingProjectPhase,
  SourcingProjectTP._SourcingProjectPhaseText[1:Language = $session.system_language].SourcingProjectPhaseText AS SourcingProjectPhaseText,
  SourcingProjectTP.SourcingSupplierListUUID AS SourcingSupplierListUUID,
  SourcingProjectTP._SourcingSupplierList.SrcgSuplrListLifecycleStatus AS SuplrListLifecycleStatus,
  SourcingProjectTP._SourcingSupplierList._SrcgSuplrListLfcycStatus._Text[1:Language = $session.system_language].SSupListLifecycleStatusName AS SSupListLifecycleStatusName,
  SourcingProjectTP._SourcingSupplierList.SourcingSupplierListVersion AS SourcingSupplierListVersion,
  SourcingProjectTP.CompanyCode AS CompanyCode,
  SourcingProjectTP._CompanyCode.CompanyCodeName AS CompanyCodeName,
  SourcingProjectTP.PurchasingGroup AS PurchasingGroup,
  SourcingProjectTP._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  SourcingProjectTP.PurchasingOrganization AS PurchasingOrganization,
  SourcingProjectTP._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  SourcingProjectTP.MaterialGroup AS MaterialGroup,
  SourcingProjectTP._MaterialGroupText[1:Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  SourcingProjectTP.DocumentCurrency AS DocumentCurrency,
  SourcingProjectTP._CurrencyText[1:Language = $session.system_language].CurrencyName AS CurrencyName,
  SourcingProjectTP.PurchaserRespWorkAgreement AS PurchaserRespWorkAgreement,
  PurchaserResponsiblePerson,
  cast( '' as bu_name1tx ) AS PersonFullName,
  SourcingProjectTP.QtnLatestSubmissionDateTime AS QtnLatestSubmissionDateTime,
  SourcingProjectTP.LastChangedByUser AS LastChangedByUser,
  SourcingProjectTP.CreatedByUser AS CreatedByUser,
  SourcingProjectTP.LastChangeDateTime AS LastChangeDateTime,
  SourcingProjectTP.CreationDateTime AS CreationDateTime,
  SourcingProjectTP.IncotermsVersion AS IncotermsVersion,
  SourcingProjectTP._IncotermsVersionText[1:Language = $session.system_language].IncotermsVersionName AS IncotermsVersionName,
  SourcingProjectTP.IncotermsClassification AS IncotermsClassification,
  SourcingProjectTP._IncotermsText[1:Language = $session.system_language].IncotermsClassificationName AS IncotermsClassificationName,
  SourcingProjectTP.IncotermsTransferLocation AS IncotermsTransferLocation,
  SourcingProjectTP.IncotermsLocation1 AS IncotermsLocation1,
  SourcingProjectTP.IncotermsLocation2 AS IncotermsLocation2,
  SourcingProjectTP.PaymentTerms AS PaymentTerms,
  SourcingProjectTP._PaymentTermsText[1:Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  SourcingProjectTP.CashDiscount1Days AS CashDiscount1Days,
  SourcingProjectTP.CashDiscount2Days AS CashDiscount2Days,
  SourcingProjectTP.CashDiscount1Percent AS CashDiscount1Percent,
  SourcingProjectTP.CashDiscount2Percent AS CashDiscount2Percent,
  SourcingProjectTP.NetPaymentDays AS NetPaymentDays,
  SourcingProjectTP.SrcgProjPubgDteTme AS SrcgProjPubgDteTme,
  SourcingProjectTP.SrcgProjCancDteTme AS SrcgProjCancDteTme,
  SourcingProjectTP.SrcgProjAttchsAreForbidden AS SrcgProjAttchsAreForbidden,
  SourcingProjectTP.SrcgProjNotesAreForbidden AS SrcgProjNotesAreForbidden,
  SourcingProjectTP.SourcingOrigin AS SourcingOrigin,
  SourcingProjectTP._SrcgProjSourcingOriginText[1:Language = $session.system_language].SrcgProjSourcingOriginText AS SrcgProjSourcingOriginText,
  SourcingProjectTP.SourcingScenario AS SourcingScenario,
  SourcingProjectTP._SrcgProjSourcingScenarioText[1:Language = $session.system_language].SrcgProjSourcingScenarioText AS SrcgProjSourcingScenarioText,
  SourcingProjectTP._SourcingProjectBiddingRatio.NumberOfBiddersWithQuotation AS NumberOfBiddersWithQuotation,
  SourcingProjectTP._SourcingProjectBiddingRatio.NumberOfBiddersWithRefusal AS NumberOfBiddersWithRefusal,
  SourcingProjectTP._SourcingProjectBiddingRatio.NumberOfBiddersWithoutRsp AS NumberOfBiddersWithoutRsp,
  SourcingProjectTP._SourcingProjectReasonText[1:Language = $session.system_language].ProductSourcingReasonText AS SourcingProjectReasonText,
  SourcingProjectTP.SourcingProjectVersioningRsn AS SourcingProjectVersioningRsn,
  _SrcgProjCancellationRsnText.ProductSourcingReasonText AS SrcgProjCancellationRsnText,
  SourcingProjectTP.SrcgProjCancellationRsn AS SrcgProjCancellationRsn,
  SourcingProjectTP.ExternalSourcingProjectRef AS ExternalSourcingProjectRef,
  SourcingProjectTP._PurgDocumentCategoryText[1:Language = $session.system_language].PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName,
  SourcingProjectTP.SrcgProjFollowOnDocumentCat AS SrcgProjFollowOnDocumentCat,
  SourcingProjectTP.SrcgProjFollowOnDocumentType AS SrcgProjFollowOnDocumentType,
  SourcingProjectTP._PurchasingDocumentTypeText[1:Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  SourcingProjectTP.PurContrValidityStartDate AS PurContrValidityStartDate,
  SourcingProjectTP.PurContrValidityEndDate AS PurContrValidityEndDate,
  SourcingProjectTP.ShippingInstruction AS ShippingInstruction,
  SourcingProjectTP._ShippingInstructionText[1:Language = $session.system_language].ShippingInstructionName AS ShippingInstructionName,
  SourcingProjectTP.SourcingProjectUniqueID AS SourcingProjectUniqueID,
  SourcingProjectTP._SourceSourcingProject.SourcingProject AS SourceSourcingProject,
  SourcingProjectTP.SourceSourcingProjectUUID AS SourceSourcingProjectUUID,
  SourcingProjectTP.CentralPurchaseContract AS CentralPurchaseContract,
  SourcingProjectTP.ProcurementPlanningBundleUUID AS ProcurementPlanningBundleUUID,
  SourcingProjectTP.SrcgProjPaymentTermIsManual AS SrcgProjPaymentTermIsManual,
  SourcingProjectTP.SrcgProjEarliestCndnSelDate AS SrcgProjEarliestCndnSelDate,
  SourcingProjectTP.SrcgProjHasBeenActivated AS SrcgProjHasBeenActivated,
  cast( 'X' as abap_boolean ) AS IsActiveEntity,
  cast( 'X' as abap_boolean ) AS HasActiveEntity,
  cast( '' as abap.char( 1 ) ) AS SourcingProjectItemIsService,
  cast( '' as abap.char( 1 ) ) AS SourcingProjectIsPublished,
  cast( '' as abap.char( 1 ) ) AS SourcingProjectIsNotPublished,
  cast( '' as abap.char( 1 ) ) AS SourcingProjectIsNotCanceled,
  cast( '' as abap.char( 1 ) ) AS IsChangeDocumentsEnabled,
  cast( '' as abap.char( 450 ) ) AS NoteTypeListText,
  cast( '' as abap.char( 1 ) ) AS UICT_SourcingProjectPhase,
  cast( '' as abap.char( 1 ) ) AS IsLglTransIntegEnabled,
  cast( '' as abap.char( 1 ) ) AS UICT_SourcingProjectIsInPrep,
  cast( '' as abap.char( 1 ) ) AS UICT_VersioningIsHidden,
  cast( '' as vdm_noteiscopyenabled ) AS NoteIsCopyEnabled,
  cast( '' as vdm_attachmentiscopyenabled ) AS AttachmentIsCopyEnabled,
  cast( '' as abap_boolean ) AS UICT_ConfirmDmndIsDisabled,
  cast( '' as abap_boolean ) AS UICT_ConfirmDmndRsnIsEnabled,
  cast( '' as abap_boolean ) AS UICT_ConfirmDmndRsnIsDsbld,
  cast( '' as abap_boolean ) AS UICT_VersioningRsnIsHidden,
  cast( '' as abap_boolean ) AS UICT_SupplDclnRsnIsHidden,
  cast( '' as abap_boolean ) AS UICT_UlckngRsnIsHidden,
  cast( '' as abap.char( 1 ) ) AS SrcgScenIsNotContractUpdate,
  cast( '' as vdm_aggregatedplant ) AS AggregatedPlant,
  cast( '' as vdm_procmtprojaggregatedname ) AS ProcmtProjAggregatedName,
  cast( '' as vdm_itemaggrgdclassfctn ) AS SrcgProjItemAggrgdClassfctn,
  cast( '' as abap_boolean ) AS UICT_IsAddSupplierFeatureEnbld,
  cast( '' as abap_boolean ) AS UICT_HCMIsDisabled,
  SourcingProjectTP._SourcingProjectType AS _SourcingProjectType,
  SourcingProjectTP._CreatedByUser AS _CreatedByUser,
  SourcingProjectTP._ChangedByUser AS _ChangedByUser,
  SourcingProjectTP._DocumentCurrency AS _DocumentCurrency
FROM R_SourcingProjectTP AS SourcingProjectTP
LEFT OUTER JOIN C_SPAllwdSuplrContactTP_F7757 AS _SrcgProjAllwdSuplrContact ON _SrcgProjAllwdSuplrContact.SourcingProjectUUID = SourcingProjectTP.SourcingProjectUUID  -- association [0..*]
LEFT OUTER JOIN C_SrcgProjectContactTP_F7757 AS _SourcingProjectContact ON _SourcingProjectContact.SourcingProjectUUID = SourcingProjectTP.SourcingProjectUUID  -- association [0..*]
LEFT OUTER JOIN C_SrcgProjProcmtProjTP_F7757 AS _SrcgProjProcurementProject ON _SrcgProjProcurementProject.SourcingProjectUUID = SourcingProjectTP.SourcingProjectUUID  -- association [0..*]
LEFT OUTER JOIN C_SrcgProjAllowedCrcyTP_F7757 AS _SrcgProjAllowedCurrency ON _SrcgProjAllowedCurrency.SourcingProjectUUID = SourcingProjectTP.SourcingProjectUUID  -- association [0..*]
LEFT OUTER JOIN C_SrcgProjectMilestoneTP_F7757 AS _SourcingProjectMilestone ON _SourcingProjectMilestone.SourcingProjectUUID = SourcingProjectTP.SourcingProjectUUID  -- association [0..*]
LEFT OUTER JOIN C_SrcPrjPubdSuplrListTP_F7757 AS _SrcgProjPubdSuplrListBP ON _SrcgProjPubdSuplrListBP.SourcingProjectUUID = SourcingProjectTP.SourcingProjectUUID  -- association [0..*]
LEFT OUTER JOIN R_SourcingProjectBiddingRatio AS _SourcingProjectBiddingRatio ON SourcingProjectUUID = _SourcingProjectBiddingRatio.SourcingProjectUUID  -- association [1..1]
LEFT OUTER JOIN C_SrcgProjImprtdSuplrListBP AS _SrcgProjImprtdSuplrListBP ON SourcingSupplierListUUID = _SrcgProjImprtdSuplrListBP.SourcingSupplierListUUID  -- association [0..*]
LEFT OUTER JOIN C_SrcgProjQuotationFacet AS _SrcgProjQuotationFacet ON SourcingProjectUUID = _SrcgProjQuotationFacet.SourcingProjectUUID  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _PurchaserResponsible ON PurchaserResponsiblePerson = _PurchaserResponsible.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN R_SrcgProjContributionForUser AS _ContributionForUser ON SourcingProjectUUID = _ContributionForUser.SourcingProjectUUID  -- association [0..1]
LEFT OUTER JOIN I_SourcingProjectTypeText AS _SourcingProjectTypeText ON SourcingProjectType = _SourcingProjectTypeText.SourcingProjectType  -- association [0..*]
LEFT OUTER JOIN C_SPPLMClbnParticipantTP_F7757 AS _SrcgProjPLMCollabnPrtcpnt ON SourcingProjectUUID = _SrcgProjPLMCollabnPrtcpnt.SourcingProjectUUID  -- association [0..*]
LEFT OUTER JOIN C_SrcgProjPLMCollabnTP_F7757 AS _SrcgProjPLMCollaboration ON SourcingProjectUUID = _SrcgProjPLMCollaboration.SourcingProjectUUID  -- association [0..*]
LEFT OUTER JOIN C_SourcingProjectItemTP_F7757 AS _SourcingProjectItem ON /* condition not available in parsed metadata */  -- association [*]
;