_VARIANCECOST

21 Fields

_VARIANCECOST is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts 1
KEY CompanyCode CompanyCode 4
KEY ControllingArea ControllingArea 1
KEY FiscalYearPeriod FiscalYearPeriod 2
KEY GLAccount GLAccount 1
KEY Ledger Ledger 5
KEY OrderCategory OrderCategory 1
KEY OrderID OrderID 4
KEY OrderItem OrderItem 7
KEY OrderType OrderType 1
KEY OriginCostCenter OriginCostCenter 1
KEY OriginCostCtrActivityType OriginCostCtrActivityType 1
KEY OriginProduct OriginProduct 1
KEY Plant Plant 1
KEY Product Product 1
KEY ProductGroup ProductGroup 1
KEY ProfitCenter ProfitCenter 1
KEY StorageLocation StorageLocation 1
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 7
AmountInDisplayCurrency CostVarianceInDspCrcy 2
NonSplitVarcAmtInDspCrcy NonSplitVarcAmtInDspCrcy 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 _VARIANCECOST (
    CHARTOFACCOUNTS,
    COMPANYCODE,
    CONTROLLINGAREA,
    FISCALYEARPERIOD,
    GLACCOUNT,
    LEDGER,
    ORDERCATEGORY,
    ORDERID,
    ORDERITEM,
    ORDERTYPE,
    ORIGINCOSTCENTER,
    ORIGINCOSTCTRACTIVITYTYPE,
    ORIGINPRODUCT,
    PLANT,
    PRODUCT,
    PRODUCTGROUP,
    PROFITCENTER,
    STORAGELOCATION,
    SUBLEDGERACCTLINEITEMTYPE,
    AMOUNTINDISPLAYCURRENCY,
    NONSPLITVARCAMTINDSPCRCY,
    PRIMARY KEY (CHARTOFACCOUNTS, COMPANYCODE, CONTROLLINGAREA, FISCALYEARPERIOD, GLACCOUNT, LEDGER, ORDERCATEGORY, ORDERID, ORDERITEM, ORDERTYPE, ORIGINCOSTCENTER, ORIGINCOSTCTRACTIVITYTYPE, ORIGINPRODUCT, PLANT, PRODUCT, PRODUCTGROUP, PROFITCENTER, STORAGELOCATION, SUBLEDGERACCTLINEITEMTYPE)
);

Learn More