C_CentralRequestForQuotationTP

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_CentralRequestForQuotationTP.
-- 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: CCNTRLRFQHDRTP

CREATE VIEW C_CentralRequestForQuotationTP AS
SELECT
  _CentralRequestForQuotationTP.CentralRequestForQuotation AS CentralRequestForQuotation,
  _CentralRequestForQuotationTP.CompanyCode AS CompanyCode,
  _CentralRequestForQuotationTP.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _CentralRequestForQuotationTP.PurchasingDocumentType AS PurchasingDocumentType,
  _CentralRequestForQuotationTP.CreationDate AS CreationDate,
  _CentralRequestForQuotationTP.LastChangeDateTime AS LastChangeDateTime,
  _CentralRequestForQuotationTP.CreatedByUser AS CreatedByUser,
  cast( _CreatedByUser.UserDescription as vdm_created_by preserving type ) AS FullName,
  _CentralRequestForQuotationTP.Language AS Language,
  _CentralRequestForQuotationTP.DocumentCurrency AS DocumentCurrency,
  _CentralRequestForQuotationTP.PurchasingOrganization AS PurchasingOrganization,
  _CentralRequestForQuotationTP.PurchasingGroup AS PurchasingGroup,
  _CentralRequestForQuotationTP.IncotermsVersion AS IncotermsVersion,
  _CentralRequestForQuotationTP.IncotermsClassification AS IncotermsClassification,
  _CentralRequestForQuotationTP.IncotermsTransferLocation AS IncotermsTransferLocation,
  _CentralRequestForQuotationTP.IncotermsLocation1 AS IncotermsLocation1,
  _CentralRequestForQuotationTP.IncotermsLocation2 AS IncotermsLocation2,
  _CentralRequestForQuotationTP.PaymentTerms AS PaymentTerms,
  _CentralRequestForQuotationTP.CashDiscount1Days AS CashDiscount1Days,
  _CentralRequestForQuotationTP.CashDiscount2Days AS CashDiscount2Days,
  _CentralRequestForQuotationTP.CashDiscount1Percent AS CashDiscount1Percent,
  _CentralRequestForQuotationTP.CashDiscount2Percent AS CashDiscount2Percent,
  _CentralRequestForQuotationTP.NetPaymentDays AS NetPaymentDays,
  _CentralRequestForQuotationTP.RFQPublishingDate AS RFQPublishingDate,
  _CentralRequestForQuotationTP.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  _CentralRequestForQuotationTP.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  _CentralRequestForQuotationTP.TargetAmount AS TargetAmount,
  _CentralRequestForQuotationTP.CorrespncInternalReference AS CorrespncInternalReference,
  _CentralRequestForQuotationTP.RFQLifecycleStatus AS RFQLifecycleStatus,
  _CentralRequestForQuotationTP.RequestForQuotationName AS RequestForQuotationName,
  _CentralRequestForQuotationTP.QuotationEarliestSubmsnDate AS QuotationEarliestSubmsnDate,
  _CentralRequestForQuotationTP.LatestRegistrationDate AS LatestRegistrationDate,
  _CentralRequestForQuotationTP.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  _CentralRequestForQuotationTP.FollowOnDocumentType AS FollowOnDocumentType,
  _CentralRequestForQuotationTP.PurContrValidityStartDate AS PurContrValidityStartDate,
  _CentralRequestForQuotationTP.PurContrValidityEndDate AS PurContrValidityEndDate,
  cast( '' as mm_approver_name ) AS ApproverName,
  cast( '' as mm_approver_id ) AS ApproverUser,
  _CentralRequestForQuotationTP.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  _CRFQCustomizing.RFQAwardingType AS RFQAwardingType,
  _CRFQCustomizing.RFQExternalProcessingType AS RFQExternalProcessingType,
  _CentralRequestForQuotationTP._CompanyCode AS _CompanyCode,
  _CentralRequestForQuotationTP._DocumentCurrency AS _DocumentCurrency,
  _CentralRequestForQuotationTP._IncotermsClassification AS _IncotermsClassification,
  _CentralRequestForQuotationTP._IncotermsVersion AS _IncotermsVersion,
  _CentralRequestForQuotationTP._PaymentTerms AS _PaymentTerms,
  _CentralRequestForQuotationTP._Language AS _Language,
  _CentralRequestForQuotationTP._PurchasingDocumentType AS _PurchasingDocumentType,
  _CentralRequestForQuotationTP._PurchasingGroup AS _PurchasingGroup,
  _CentralRequestForQuotationTP._PurchasingOrganization AS _PurchasingOrganization,
  _CentralRequestForQuotationTP._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  _CentralRequestForQuotationTP._FollowOnDocumentType AS _FollowOnDocumentType,
  _CentralRequestForQuotationTP._FollowOnDocumentCategory AS _FollowOnDocumentCategory,
  _CentralRequestForQuotationTP._RFQLifecycleStatus AS _RFQLifecycleStatus
FROM I_CentralRequestForQuotationTP AS _CentralRequestForQuotationTP
LEFT OUTER JOIN C_CentralReqForQuotationItemTP AS _CentralReqForQuotationItemTP ON CentralRequestForQuotation = _CentralReqForQuotationItemTP.CentralRequestForQuotation  -- association [1..*]
LEFT OUTER JOIN C_CntrlReqForQuotationBidderTP AS _CntrlReqForQuotationBidderTP ON CentralRequestForQuotation = _CntrlReqForQuotationBidderTP.CentralRequestForQuotation  -- association [0..*]
LEFT OUTER JOIN C_CntrlSupplierQuotationInfo AS _CntrlSupplierQuotationInfo ON CentralRequestForQuotation = _CntrlSupplierQuotationInfo.CentralRequestForQuotation AND CentralRequestForQuotation <> ''  -- association [0..*]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroupValueHelp ON _PurchasingGroupValueHelp.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrgValueHelp ON _PurchasingOrgValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_MM_CompanyCodeValueHelp AS _CompanyCodeValueHelp ON _CompanyCodeValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_MM_PaymentTermValueHelp AS _PaymentTermsValueHelp ON _PaymentTermsValueHelp.PaymentTerms = PaymentTerms  -- association [0..*]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms  -- association [0..*]
LEFT OUTER JOIN C_MM_IncotermValueHelp AS _IncotermsValueHelp ON _IncotermsValueHelp.IncotermsClassification = IncotermsClassification AND _IncotermsValueHelp.IncotermsVersion = IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON IncotermsClassification = _IncotermsClassificationText.IncotermsClassification  -- association [0..*]
LEFT OUTER JOIN I_IncotermsVersionText AS _IncotermsVersionText ON IncotermsVersion = _IncotermsVersionText.IncotermsVersion  -- association [0..*]
LEFT OUTER JOIN C_CentralReqForQuotationTypeVH AS _CentralReqForQuotationTypeVH ON _CentralReqForQuotationTypeVH.RFQType = PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN C_CentralSourcingFollowOnDocVH AS _FollowOnDocVH ON _FollowOnDocVH.SupplierQuotationType = PurchasingDocumentType AND _FollowOnDocVH.FollowOnDocumentType = FollowOnDocumentType AND _FollowOnDocVH.FollowOnDocumentCategory = FollowOnDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ContactCard ON _ContactCard.ContactCardType = 'User' AND _ContactCard.ContactCardID = CreatedByUser AND _ContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN P_CRFQCustomizing AS _CRFQCustomizing ON PurchasingDocumentType = _CRFQCustomizing.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory AND PurchasingDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType  -- association [0..*]
;