P_PRCGCNDNRECORDITEM

CDS View
45 Fields 10 CDS Views

P_PRCGCNDNRECORDITEM is a CDS View in S/4HANA. It contains 45 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
A_PurContrItemCondition view inner BASIC Item Condition
I_PricingConditionRecord view inner BASIC Condition Record for Pricing
I_SAFTTaxRate view inner COMPOSITE SAF-T Tax Rate
P_NO_SAFTTAXRATE view inner COMPOSITE
P_PurgPrcgCndnRecdSuplmnt view left_outer BASIC
P_PurgPrcgConditionRecord view inner BASIC
P_SlsPrcgCndnRecdSuplmnt view inner BASIC
P_SlsPrcgConditionRecord view inner BASIC
P_SrcgProjQtnItmCndnAmount view_entity inner BASIC
P_SrcgProjQtnItmCndnAmtSimple view_entity inner BASIC

Fields (45)

KeyField CDS FieldsUsed in Views
KEY ConditionRecord ConditionRecord 1
KEY ConditionSequentialNumber ConditionSequentialNumber,ConditionSequentialNumberShort 8
KEY ConditionType ConditionType 8
AdditionalValueDays AdditionalValueDays 8
BaseUnit BaseUnit 8
CmmdtyPrcgConditionFormulaUUID CmmdtyPrcgConditionFormulaUUID 1
CndnMaxNumberOfSalesOrders CndnMaxNumberOfSalesOrders 8
ConditionAlternativeCurrency ConditionAlternativeCurrency 8
ConditionCalculationType ConditionCalculationType 8
ConditionChangeReason ConditionChangeReason 5
ConditionCurrency ConditionCurrency 6
ConditionExclusion ConditionExclusion 8
ConditionIsDeleted ConditionIsDeleted 8
ConditionLowerLimit ConditionLowerLimit 8
ConditionLowerLimitAmount ConditionLowerLimitAmount 4
ConditionLowerLimitRatio ConditionLowerLimitRatio 4
ConditionQuantity ConditionQuantity 8
ConditionQuantityUnit ConditionQuantityUnit 7
ConditionRateAmount ConditionRateAmount 6
ConditionRateRatio ConditionRateRatio 6
ConditionRateRatioUnit ConditionRateRatioUnit 5
ConditionRateValue ConditionRateValue,TaxRate 10
ConditionRateValueUnit ConditionRateValueUnit 7
ConditionReleaseStatus ConditionReleaseStatus 8
ConditionScaleAmount ConditionScaleAmount 8
ConditionScaleAmountCurrency ConditionScaleAmountCurrency 8
ConditionScaleQuantity ConditionScaleQuantity 8
ConditionScaleQuantityUnit ConditionScaleQuantityUnit 8
ConditionTaxCode ConditionTaxCode 1
ConditionTextID ConditionTextID 8
ConditionToBaseQtyDnmntr ConditionToBaseQtyDnmntr 8
ConditionToBaseQtyNmrtr ConditionToBaseQtyNmrtr 8
ConditionUpperLimit ConditionUpperLimit 8
ConditionUpperLimitAmount ConditionUpperLimitAmount 4
ConditionUpperLimitRatio ConditionUpperLimitRatio 4
ConditionWithholdingTaxCode ConditionWithholdingTaxCode 1
FixedValueDate FixedValueDate 8
IncrementalScale IncrementalScale 7
MaximumConditionAmount MaximumConditionAmount 8
MaximumConditionBasisValue MaximumConditionBasisValue 8
MinimumConditionBasisValue MinimumConditionBasisValue 8
PaymentTerms PaymentTerms 8
PricingScaleBasis PricingScaleBasis 8
PricingScaleLine PricingScaleLine 8
PricingScaleType PricingScaleType 8

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PRCGCNDNRECORDITEM (
    CONDITIONRECORD,
    CONDITIONSEQUENTIALNUMBER,
    CONDITIONTYPE,
    ADDITIONALVALUEDAYS,
    BASEUNIT,
    CMMDTYPRCGCONDITIONFORMULAUUID,
    CNDNMAXNUMBEROFSALESORDERS,
    CONDITIONALTERNATIVECURRENCY,
    CONDITIONCALCULATIONTYPE,
    CONDITIONCHANGEREASON,
    CONDITIONCURRENCY,
    CONDITIONEXCLUSION,
    CONDITIONISDELETED,
    CONDITIONLOWERLIMIT,
    CONDITIONLOWERLIMITAMOUNT,
    CONDITIONLOWERLIMITRATIO,
    CONDITIONQUANTITY,
    CONDITIONQUANTITYUNIT,
    CONDITIONRATEAMOUNT,
    CONDITIONRATERATIO,
    CONDITIONRATERATIOUNIT,
    CONDITIONRATEVALUE,
    CONDITIONRATEVALUEUNIT,
    CONDITIONRELEASESTATUS,
    CONDITIONSCALEAMOUNT,
    CONDITIONSCALEAMOUNTCURRENCY,
    CONDITIONSCALEQUANTITY,
    CONDITIONSCALEQUANTITYUNIT,
    CONDITIONTAXCODE,
    CONDITIONTEXTID,
    CONDITIONTOBASEQTYDNMNTR,
    CONDITIONTOBASEQTYNMRTR,
    CONDITIONUPPERLIMIT,
    CONDITIONUPPERLIMITAMOUNT,
    CONDITIONUPPERLIMITRATIO,
    CONDITIONWITHHOLDINGTAXCODE,
    FIXEDVALUEDATE,
    INCREMENTALSCALE,
    MAXIMUMCONDITIONAMOUNT,
    MAXIMUMCONDITIONBASISVALUE,
    MINIMUMCONDITIONBASISVALUE,
    PAYMENTTERMS,
    PRICINGSCALEBASIS,
    PRICINGSCALELINE,
    PRICINGSCALETYPE,
    PRIMARY KEY (CONDITIONRECORD, CONDITIONSEQUENTIALNUMBER, CONDITIONTYPE)
);

Learn More