R_SRCGPROJQTNITEM

CDS View
14 Fields 9 CDS Views

Item in Sourcing Project Quotation

R_SRCGPROJQTNITEM is a CDS View in S/4HANA. Item in Sourcing Project Quotation. It contains 14 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_SrcgProjectItemProcessFlow view_entity inner CONSUMPTION Sourcing Project Item Process Flow
C_SrcgProjQtnCompareBestBidder view_entity inner CONSUMPTION Compare Best Bidder Calculation
C_SrcgProjQtnDelivAddrDocVar view inner CONSUMPTION Doc Varbl for Delivery Address in SPQtn
C_SrcgProjQtnItemCompare view_entity from CONSUMPTION Sourcing Project Quotation Item
I_SrcgProjQtnItem view from BASIC Item in Sourcing Project Quotation
P_SrcgProjQuotationItemAmount view_entity from CONSUMPTION
R_SrcgProjQtnItemCondition view_entity inner BASIC Sourcing Project Qtn Item Condition
R_SrcgProjQtnItemTP view_entity from TRANSACTIONAL Item in Sourcing Project Quotation - TP
R_SrcgProjQtnItmCndnValidity view inner BASIC Cndn Validity for Item in Srcg Proj Qtn

Fields (14)

KeyField CDS FieldsUsed in Views
KEY FormattedItemID SrcgProjItemProcessFlowItem 1
KEY SrcgProjQtnItemUUID SrcgProjQtnItemUUID 5
CompanyCode CompanyCode 2
MaterialGroup MaterialGroup 1
NetPriceAmount NetPriceAmount 1
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 1
SourcingProjectItemStableUUID SourcingProjectItemStableUUID 1
SourcingProjectItemUUID SourcingProjectItemUUID 1
SourcingProjectQuotationItem SourcingProjectQuotationItem 2
SourcingProjectQuotationUUID SourcingProjectQuotationUUID 4
SrcgProjQtnItemOfferingCode SrcgProjQtnItemOfferingCode 1
SrcgProjQtnOfferCurrency SrcgProjQtnOfferCurrency 1
SrcgProjQuotationItemType SrcgProjQuotationItemType 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.

-- Item in Sourcing Project Quotation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_SRCGPROJQTNITEM (
    FORMATTEDITEMID,
    SRCGPROJQTNITEMUUID,
    COMPANYCODE,
    MATERIALGROUP,
    NETPRICEAMOUNT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SOURCINGPROJECTITEMSTABLEUUID,
    SOURCINGPROJECTITEMUUID,
    SOURCINGPROJECTQUOTATIONITEM,
    SOURCINGPROJECTQUOTATIONUUID,
    SRCGPROJQTNITEMOFFERINGCODE,
    SRCGPROJQTNOFFERCURRENCY,
    SRCGPROJQUOTATIONITEMTYPE,
    PRIMARY KEY (FORMATTEDITEMID, SRCGPROJQTNITEMUUID)
);

Learn More