R_SRCGPROJQTNITEMCONDITION

CDS View
19 Fields 4 CDS Views

Sourcing Project Qtn Item Condition

R_SRCGPROJQTNITEMCONDITION is a CDS View in S/4HANA. Sourcing Project Qtn Item Condition. It contains 19 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
R_SrcgProjQtnItmCmmdtyExchRate view inner COMPOSITE Srcg Project Qtn Itm Cmmdty Exc Rate
R_SrcgProjQtnItmCmmdtyFormula view inner COMPOSITE SPQ Item Commodity Formula
R_SrcgProjQtnItmCmmdtyTrmQtn view inner COMPOSITE Srcg Proj Qtn Itm Term Quotation
R_SrcgProjQtnItmCommodityTerm view inner COMPOSITE Sourcing project qtn item commodity term

Fields (19)

KeyField CDS FieldsUsed in Views
KEY ConditionRecord ConditionRecord 1
KEY ConditionSequentialNumberShort ConditionSequentialNumberShort 1
ConditionApplication ConditionApplication 4
ConditionCalculationTypeShort ConditionCalculationTypeShort 4
ConditionIsDeleted ConditionIsDeleted 4
ConditionQuantity ConditionQuantity 4
ConditionQuantityUnit ConditionQuantityUnit 4
ConditionRateValue ConditionRateValue 4
ConditionRateValueUnit ConditionRateValueUnit 4
ConditionType ConditionType 2
ConditionValidityEndDate ConditionValidityEndDate 4
ConditionValidityStartDate ConditionValidityStartDate 4
Currency Currency 4
ProcmtHubPlantUniqueID ProcmtHubPlantUniqueID 4
SourcingProjectQuotation SourcingProjectQuotation 4
SourcingProjectQuotationItem SourcingProjectQuotationItem 4
SourcingProjectQuotationUUID SourcingProjectQuotationUUID 4
SrcgProjQtnItemUUID SrcgProjQtnItemUUID 4
SrcgProjQuotationVersion SrcgProjQuotationVersion 4

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.

-- Sourcing Project Qtn Item Condition
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_SRCGPROJQTNITEMCONDITION (
    CONDITIONRECORD,
    CONDITIONSEQUENTIALNUMBERSHORT,
    CONDITIONAPPLICATION,
    CONDITIONCALCULATIONTYPESHORT,
    CONDITIONISDELETED,
    CONDITIONQUANTITY,
    CONDITIONQUANTITYUNIT,
    CONDITIONRATEVALUE,
    CONDITIONRATEVALUEUNIT,
    CONDITIONTYPE,
    CONDITIONVALIDITYENDDATE,
    CONDITIONVALIDITYSTARTDATE,
    CURRENCY,
    PROCMTHUBPLANTUNIQUEID,
    SOURCINGPROJECTQUOTATION,
    SOURCINGPROJECTQUOTATIONITEM,
    SOURCINGPROJECTQUOTATIONUUID,
    SRCGPROJQTNITEMUUID,
    SRCGPROJQUOTATIONVERSION,
    PRIMARY KEY (CONDITIONRECORD, CONDITIONSEQUENTIALNUMBERSHORT)
);

Learn More