_WIPVARIANCE

20 Fields

_WIPVARIANCE is an SAP database table in S/4HANA. It contains 20 fields.

Fields (20)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts 3
KEY CompanyCode CompanyCode 1
KEY ControllingValueType ControllingValueType 1
KEY GLAccount GLAccount 3
KEY Ledger Ledger 1
KEY OrderCategory OrderCategory 1
KEY OrderID OrderID 1
KEY OrderItem OrderItem 1
KEY OrderType OrderType 1
KEY OriginCostCenter OriginCostCenter 3
KEY OriginCostCtrActivityType OriginCostCtrActivityType 3
KEY OriginProduct OriginProduct 3
KEY Plant Plant 1
KEY ProducedProduct ProducedProduct 1
KEY ResultAnalysisInternalID ResultAnalysisInternalID 1
KEY SalesOrder SalesOrder 1
KEY SalesOrderItem SalesOrderItem 1
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 1
KEY WBSElementInternalID WBSElementInternalID 1
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 _WIPVARIANCE (
    CHARTOFACCOUNTS,
    COMPANYCODE,
    CONTROLLINGVALUETYPE,
    GLACCOUNT,
    LEDGER,
    ORDERCATEGORY,
    ORDERID,
    ORDERITEM,
    ORDERTYPE,
    ORIGINCOSTCENTER,
    ORIGINCOSTCTRACTIVITYTYPE,
    ORIGINPRODUCT,
    PLANT,
    PRODUCEDPRODUCT,
    RESULTANALYSISINTERNALID,
    SALESORDER,
    SALESORDERITEM,
    SUBLEDGERACCTLINEITEMTYPE,
    WBSELEMENTINTERNALID,
    NONSPLITVARCAMTINDSPCRCY,
    PRIMARY KEY (CHARTOFACCOUNTS, COMPANYCODE, CONTROLLINGVALUETYPE, GLACCOUNT, LEDGER, ORDERCATEGORY, ORDERID, ORDERITEM, ORDERTYPE, ORIGINCOSTCENTER, ORIGINCOSTCTRACTIVITYTYPE, ORIGINPRODUCT, PLANT, PRODUCEDPRODUCT, RESULTANALYSISINTERNALID, SALESORDER, SALESORDERITEM, SUBLEDGERACCTLINEITEMTYPE, WBSELEMENTINTERNALID)
);

Learn More