PRICINGASPECT

PRICINGASPECT is an SAP database table in S/4HANA. It contains 16 fields.

Fields (16)

KeyField CDS FieldsUsed in Views
KEY TradingContractItem TradingContractItem 2
KEY TradingContractNumber TradingContractNumber 2
KEY TrdgContrPrcgAspectSrceLotID SourceLotId,TrdgContrPrcgAspectSrceLotID 4
ACMContrPrcgTotAmtCrcy ACMContrPrcgTotAmtCrcy 1
ACMPrcgCndnFlatPrice PrcgCndnTradingContrCurrency 1
ACMPrcgFixationStatus PricingStatus 1
ACMPrcgTotAmt ACMPrcgTotAmt 1
ACMPriceFixationStatus ACMPriceFixationStatus 1
ACMPricingAspect ACMPricingAspect 1
ACMPricingAspectValue ACMPricingAspectValue 1
ContractTradeQuantity ContractTradeQuantity,Quantity 3
ContractTradeUnit ContractTradeUnit,UoM 3
PrcLotDistributedQty PrcLotDistributedQty 1
PricingDate PricingDate 1
Side Side 1
TrdgContractItemUnitOfMeasure TrdgContractItemUnitOfMeasure 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRICINGASPECT (
    TRADINGCONTRACTITEM,
    TRADINGCONTRACTNUMBER,
    TRDGCONTRPRCGASPECTSRCELOTID,
    ACMCONTRPRCGTOTAMTCRCY,
    ACMPRCGCNDNFLATPRICE,
    ACMPRCGFIXATIONSTATUS,
    ACMPRCGTOTAMT,
    ACMPRICEFIXATIONSTATUS,
    ACMPRICINGASPECT,
    ACMPRICINGASPECTVALUE,
    CONTRACTTRADEQUANTITY,
    CONTRACTTRADEUNIT,
    PRCLOTDISTRIBUTEDQTY,
    PRICINGDATE,
    SIDE,
    TRDGCONTRACTITEMUNITOFMEASURE,
    PRIMARY KEY (TRADINGCONTRACTITEM, TRADINGCONTRACTNUMBER, TRDGCONTRPRCGASPECTSRCELOTID)
);