R_SOURCINGPROJECTQUOTATION

CDS View
38 Fields 11 CDS Views

Quotation for Sourcing Project

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

CDS Views using this table (11)

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_SrcgProjQuotationCompare view_entity from CONSUMPTION Sourcing Project Quotation
C_SrcgProjQuotationFacet view_entity from CONSUMPTION Quotation for Sourcing Project
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_SPAwdQtnItemAggr view from CONSUMPTION
R_SourcingProjectQuotationTP view_entity from TRANSACTIONAL Quotation for Sourcing Project - TP

Fields (38)

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

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,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    QTNLATESTSUBMISSIONDATETIME,
    SOURCINGORIGIN,
    SOURCINGPROJECTNEGOTIATIONUUID,
    SOURCINGPROJECTQUOTATION,
    SOURCINGPROJECTQUOTATIONNAME,
    SOURCINGPROJECTQUOTATIONTYPE,
    SOURCINGPROJECTUUID,
    SRCGPROJATTCHSAREFORBIDDEN,
    SRCGPROJNOTESAREFORBIDDEN,
    SRCGPROJQTNACTVTNSTS,
    SRCGPROJQTNAWARDINGSTATUS,
    SRCGPROJQTNLIFECYCLESTATUS,
    SRCGPROJQTNOFFERCURRENCY,
    SRCGPROJQTNREVISIONSTS,
    SRCGPROJQTNSUBMSNSTS,
    SRCGPROJQTNTOTNETAMT,
    SRCGPROJQUOTATIONISSIMULATED,
    SRCGPROJQUOTATIONVERSION,
    PRIMARY KEY (SOURCINGPROJECTQUOTATIONUUID)
);

Learn More