R_SOURCINGPROJECTQUOTATION

CDS View
41 Fields 17 CDS Views

Quotation for Sourcing Project

R_SOURCINGPROJECTQUOTATION is a CDS View in S/4HANA. Quotation for Sourcing Project. It contains 41 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
C_SourcingProjQtnDocVarbl view from CONSUMPTION Document Variable for Srcg Proj Qtn
C_SrcgProjAwdgScenQuotation view_entity from CONSUMPTION Quotations related to Awarding Scenario
C_SrcgProjQtnCompareBestBidder view_entity from CONSUMPTION Compare Best Bidder Calculation
C_SrcgProjQtnDEX view_entity from CONSUMPTION SrcgProj Quotation Extraction
C_SrcgProjQuotationCompare view_entity from CONSUMPTION Sourcing Project Quotation
C_SrcgProjQuotationCompare_2 view_entity from CONSUMPTION Sourcing Project Quotation
C_SrcgProjQuotationFacet view_entity from CONSUMPTION Quotation for Sourcing Project
I_PPS_PurchaseOrderProcessFlow view_entity inner COMPOSITE PPS Purchase Order Business Process FLow
I_PPS_PurReqnProcessFlow view_entity inner COMPOSITE Interface for PPS Process Flow
I_SourcingProjectQuotation view from BASIC Quotation for Sourcing Project
I_SrcgProjectQtnCreatedSitn view_entity from BASIC Srcg Proj Quotation Created Situation
I_SrcgProjQtnNameBySemanticKey view_entity from BASIC Srcg Proj Qtn Name by Semantic Key
I_SrcgProjQtnSubmdSitnTrggr view_entity from BASIC Srcg Proj Qtn Submitted Sitn Trigger
P_PPS_SourcingProjectQuotation view_entity from COMPOSITE
P_SPAwdQtnItemAggr view from CONSUMPTION
P_SrcgProjQtnBidderCount view_entity from COMPOSITE
R_SourcingProjectQuotationTP view_entity from TRANSACTIONAL Quotation for Sourcing Project - TP

Fields (41)

KeyField CDS FieldsUsed in Views
KEY SourcingProjectQuotationUUID SourcingProjectQuotationUUID 4
_CompanyCode _CompanyCode 1
_PurchasingGroup _PurchasingGroup 1
_PurchasingOrganization _PurchasingOrganization 1
_SrcgProjQtnOfferCurrency _SrcgProjQtnOfferCurrency 1
Bidder Bidder 2
CashDiscount1Days CashDiscount1Days 1
CashDiscount1Percent CashDiscount1Percent 1
CashDiscount2Days CashDiscount2Days 1
CashDiscount2Percent CashDiscount2Percent 1
CompanyCode CompanyCode 2
CreationDateTime CreationDateTime 1
ExternalSourcingProjectQtnRef ExternalSourcingProjectQtnRef 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 3
LastChangeDateTime LastChangeDateTime 1
LogicalSystem LogicalSystem 1
MaterialGroup MaterialGroup 3
NetPaymentDays NetPaymentDays 1
PricingProcedure PricingProcedure 1
PurchasingCategory PurchasingCategory 3
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 3
QtnLatestSubmissionDateTime QtnLatestSubmissionDateTime 2
SourcingEnvelopeOverallStatus SourcingEnvelopeOverallStatus 3
SourcingOrigin SourcingOrigin 1
SourcingProjectNegotiationUUID SourcingProjectNegotiationUUID 1
SourcingProjectQuotation SourcingProjectQuotation 2
SourcingProjectQuotationName SourcingProjectQuotationName 2
SourcingProjectQuotationType SourcingProjectQuotationType 3
SourcingProjectUUID SourcingProjectUUID 2
SrcgProjAttchsAreForbidden SrcgProjAttchsAreForbidden 1
SrcgProjNotesAreForbidden SrcgProjNotesAreForbidden 1
SrcgProjQtnActvtnSts SrcgProjQtnActvtnSts 1
SrcgProjQtnAwardingStatus SrcgProjQtnAwardingStatus 1
SrcgProjQtnLifecycleStatus SrcgProjQtnLifecycleStatus 3
SrcgProjQtnOfferCurrency SrcgProjQtnOfferCurrency 2
SrcgProjQtnRevisionSts SrcgProjQtnRevisionSts 1
SrcgProjQtnSubmsnSts SrcgProjQtnSubmsnSts 2
SrcgProjQtnTotNetAmt SrcgProjQtnTotNetAmt 1
SrcgProjQuotationIsSimulated SrcgProjQuotationIsSimulated 1
SrcgProjQuotationVersion SrcgProjQuotationVersion 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Quotation for Sourcing Project
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_SOURCINGPROJECTQUOTATION (
    SOURCINGPROJECTQUOTATIONUUID,
    _COMPANYCODE,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _SRCGPROJQTNOFFERCURRENCY,
    BIDDER,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    CREATIONDATETIME,
    EXTERNALSOURCINGPROJECTQTNREF,
    ISENDOFPURPOSEBLOCKED,
    LASTCHANGEDATETIME,
    LOGICALSYSTEM,
    MATERIALGROUP,
    NETPAYMENTDAYS,
    PRICINGPROCEDURE,
    PURCHASINGCATEGORY,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    QTNLATESTSUBMISSIONDATETIME,
    SOURCINGENVELOPEOVERALLSTATUS,
    SOURCINGORIGIN,
    SOURCINGPROJECTNEGOTIATIONUUID,
    SOURCINGPROJECTQUOTATION,
    SOURCINGPROJECTQUOTATIONNAME,
    SOURCINGPROJECTQUOTATIONTYPE,
    SOURCINGPROJECTUUID,
    SRCGPROJATTCHSAREFORBIDDEN,
    SRCGPROJNOTESAREFORBIDDEN,
    SRCGPROJQTNACTVTNSTS,
    SRCGPROJQTNAWARDINGSTATUS,
    SRCGPROJQTNLIFECYCLESTATUS,
    SRCGPROJQTNOFFERCURRENCY,
    SRCGPROJQTNREVISIONSTS,
    SRCGPROJQTNSUBMSNSTS,
    SRCGPROJQTNTOTNETAMT,
    SRCGPROJQUOTATIONISSIMULATED,
    SRCGPROJQUOTATIONVERSION,
    PRIMARY KEY (SOURCINGPROJECTQUOTATIONUUID)
);

Learn More