R_SRCGPROJQTNITEM

CDS View
14 Fields 14 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. 14 CDS views read from this table.

CDS Views using this table (14)

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
C_SrcgProjQtnItemCompare_2 view_entity from CONSUMPTION Sourcing Project Quotation Item
I_PPS_PurchaseOrderProcessFlow view_entity inner COMPOSITE PPS Purchase Order Business Process FLow
I_PPS_PurContrProcessFlow view_entity inner COMPOSITE PPS Process Flow for Purchase Contract
I_PPS_PurReqnProcessFlow view_entity inner COMPOSITE Interface for PPS Process Flow
I_PPS_SrcgProjQtnProcFlowNode view_entity from COMPOSITE Sourcing Proj Qtn for Process Flow Node
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 SourcingProjectQuotation SubsequentDocument 2
KEY SourcingProjectQuotationUUID SourcingProjectQuotationUUID 4
KEY SrcgProjQtnItemUUID SrcgProjQtnItemUUID 5
CompanyCode CompanyCode 2
MaterialGroup MaterialGroup 1
NetPriceAmount NetPriceAmount 1
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 1
SourcingProjectItemStableUUID SourcingProjectItemStableUUID 1
SourcingProjectQuotationItem SourcingProjectQuotationItem 2
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,
    SOURCINGPROJECTQUOTATION,
    SOURCINGPROJECTQUOTATIONUUID,
    SRCGPROJQTNITEMUUID,
    COMPANYCODE,
    MATERIALGROUP,
    NETPRICEAMOUNT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SOURCINGPROJECTITEMSTABLEUUID,
    SOURCINGPROJECTQUOTATIONITEM,
    SRCGPROJQTNITEMOFFERINGCODE,
    SRCGPROJQTNOFFERCURRENCY,
    SRCGPROJQUOTATIONITEMTYPE,
    PRIMARY KEY (FORMATTEDITEMID, SOURCINGPROJECTQUOTATION, SOURCINGPROJECTQUOTATIONUUID, SRCGPROJQTNITEMUUID)
);

Learn More