COSTS

68 Fields

COSTS is an SAP database table in S/4HANA. It contains 68 fields.

Fields (68)

KeyField CDS FieldsUsed in Views
KEY BusinessTransactionCategory BusinessTransactionCategory 2
KEY CompanyCode CompanyCode 1
KEY ControllingArea ControllingArea 3
KEY ControllingDebitCreditCode ControllingDebitCreditCode 2
KEY ControllingKeySubNumber ControllingKeySubNumber 2
KEY CostElement CostElement 4
KEY CostOriginGroup CostOriginGroup 3
KEY CostOriginType CostOriginType 2
KEY CtrlgOriginClassification CtrlgOriginClassification 2
KEY IsLotSizeIndependent IsLotSizeIndependent 2
KEY Material Material 6
KEY MfgOrderBusTransactionType MfgOrderBusTransactionType 2
KEY OriginBusinessProcess OriginBusinessProcess 2
KEY OriginCostCenter OriginCostCenter 2
KEY OriginCostCtrActivityType OriginCostCtrActivityType 2
KEY OriginObject OriginObject 2
KEY OriginOrder OriginOrder 1
KEY Partner Partner 2
KEY PartnerBusinessProcess PartnerBusinessProcess 2
KEY PartnerCostCenter PartnerCostCenter 2
KEY PartnerCostCtrActivityType PartnerCostCtrActivityType 2
KEY PartnerOrder PartnerOrder 2
KEY Plant Plant 6
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 2
KEY UnitOfMeasure UnitOfMeasure 4
ActlCostInDspCrcy ActlCostInDspCrcy 2
ActlFixedCostInDspCrcy ActlFixedCostInDspCrcy 2
ActlVarblCostInDspCrcy ActlVarblCostInDspCrcy 2
ActualFixedQuantity ActualFixedQuantity 1
ActualQuantity ActualControlQuantity,ActualQuantity 2
ActualVariableQuantity ActualVariableQuantity 1
CompanyCodeCurrency CompanyCodeCurrency 1
CrdtActlFxdCostInDspCrcy CrdtActlFxdCostInDspCrcy 2
CrdtActlVarblCostInDspCrcy CrdtActlVarblCostInDspCrcy 2
CrdtPlnFxdCostInDspCrcy CrdtPlnFxdCostInDspCrcy 1
CrdtPlnVarblCostInDspCrcy CrdtPlnVarblCostInDspCrcy 1
CrdtTargetCostInDspCrcy CrdtTargetCostInDspCrcy 2
CreditActlCostInDspCrcy CrdtActlCtrlCostInDspCrcy,CreditActlCostInDspCrcy 2
CreditPlanCostInDspCrcy CrdtPlanCtrlCostInDspCrcy,CreditPlanCostInDspCrcy 1
DebitActlCostInDspCrcy DebitActlCostInDspCrcy,DebitActlCtrlCostInDspCrcy 2
DebitActlFxdCostInDspCrcy DebitActlFxdCostInDspCrcy 2
DebitActlPlnDiffCostInDspCrcy DebitActlPlnDiffCostInDspCrcy 1
DebitActlTgtDiffCostInDspCrcy DebitActlTgtDiffCostInDspCrcy 2
DebitActlVarblCostInDspCrcy DebitActlVarblCostInDspCrcy 2
DebitPlanCostInDspCrcy DebitPlanCostInDspCrcy,DebitPlanCtrlCostInDspCrcy 1
DebitPlnFxdCostInDspCrcy DebitPlnFxdCostInDspCrcy 1
DebitPlnVarblCostInDspCrcy DebitPlnVarblCostInDspCrcy 1
DebitTargetCostInDspCrcy DebitTargetCostInDspCrcy 2
InptPrVarcAmtInDspCrcy InptPrVarcAmtInDspCrcy 2
InptQtyVarcAmtInDspCrcy InptQtyVarcAmtInDspCrcy 2
LotSizeVarcAmtInDspCrcy LotSizeVarcAmtInDspCrcy 2
MixedPrVarcAmtInDspCrcy MixedPrVarcAmtInDspCrcy 2
OrderID OrderID 1
OutpPrVarcAmtInDspCrcy OutpPrVarcAmtInDspCrcy 2
PlanCostInDspCrcy PlanCostInDspCrcy 1
PlanFixedCostInDspCrcy PlanFixedCostInDspCrcy 1
PlanQuantity PlanControlQuantity,PlanQuantity 1
PlanVarblCostInDspCrcy PlanVarblCostInDspCrcy 1
RmngVarcAmtInDspCrcy RmngVarcAmtInDspCrcy 2
RsceUsgeVarcAmtInDspCrcy RsceUsgeVarcAmtInDspCrcy 2
ScrapVarcAmtInDspCrcy ScrapVarcAmtInDspCrcy 2
TargetCostInDspCrcy TargetCostInDspCrcy 2
TargetFixedQuantity TargetFixedQuantity 1
TargetQuantity TargetQuantity 2
TargetVariableQuantity TargetVariableQuantity 1
UnrlzdCostRsrvAmtInDspCrcy UnrlzdCostRsrvAmtInDspCrcy 2
WIPCostInDspCrcy WIPCostInDspCrcy 2
WIPQuantity WIPQuantity 2

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 COSTS (
    BUSINESSTRANSACTIONCATEGORY,
    COMPANYCODE,
    CONTROLLINGAREA,
    CONTROLLINGDEBITCREDITCODE,
    CONTROLLINGKEYSUBNUMBER,
    COSTELEMENT,
    COSTORIGINGROUP,
    COSTORIGINTYPE,
    CTRLGORIGINCLASSIFICATION,
    ISLOTSIZEINDEPENDENT,
    MATERIAL,
    MFGORDERBUSTRANSACTIONTYPE,
    ORIGINBUSINESSPROCESS,
    ORIGINCOSTCENTER,
    ORIGINCOSTCTRACTIVITYTYPE,
    ORIGINOBJECT,
    ORIGINORDER,
    PARTNER,
    PARTNERBUSINESSPROCESS,
    PARTNERCOSTCENTER,
    PARTNERCOSTCTRACTIVITYTYPE,
    PARTNERORDER,
    PLANT,
    SUBLEDGERACCTLINEITEMTYPE,
    UNITOFMEASURE,
    ACTLCOSTINDSPCRCY,
    ACTLFIXEDCOSTINDSPCRCY,
    ACTLVARBLCOSTINDSPCRCY,
    ACTUALFIXEDQUANTITY,
    ACTUALQUANTITY,
    ACTUALVARIABLEQUANTITY,
    COMPANYCODECURRENCY,
    CRDTACTLFXDCOSTINDSPCRCY,
    CRDTACTLVARBLCOSTINDSPCRCY,
    CRDTPLNFXDCOSTINDSPCRCY,
    CRDTPLNVARBLCOSTINDSPCRCY,
    CRDTTARGETCOSTINDSPCRCY,
    CREDITACTLCOSTINDSPCRCY,
    CREDITPLANCOSTINDSPCRCY,
    DEBITACTLCOSTINDSPCRCY,
    DEBITACTLFXDCOSTINDSPCRCY,
    DEBITACTLPLNDIFFCOSTINDSPCRCY,
    DEBITACTLTGTDIFFCOSTINDSPCRCY,
    DEBITACTLVARBLCOSTINDSPCRCY,
    DEBITPLANCOSTINDSPCRCY,
    DEBITPLNFXDCOSTINDSPCRCY,
    DEBITPLNVARBLCOSTINDSPCRCY,
    DEBITTARGETCOSTINDSPCRCY,
    INPTPRVARCAMTINDSPCRCY,
    INPTQTYVARCAMTINDSPCRCY,
    LOTSIZEVARCAMTINDSPCRCY,
    MIXEDPRVARCAMTINDSPCRCY,
    ORDERID,
    OUTPPRVARCAMTINDSPCRCY,
    PLANCOSTINDSPCRCY,
    PLANFIXEDCOSTINDSPCRCY,
    PLANQUANTITY,
    PLANVARBLCOSTINDSPCRCY,
    RMNGVARCAMTINDSPCRCY,
    RSCEUSGEVARCAMTINDSPCRCY,
    SCRAPVARCAMTINDSPCRCY,
    TARGETCOSTINDSPCRCY,
    TARGETFIXEDQUANTITY,
    TARGETQUANTITY,
    TARGETVARIABLEQUANTITY,
    UNRLZDCOSTRSRVAMTINDSPCRCY,
    WIPCOSTINDSPCRCY,
    WIPQUANTITY,
    PRIMARY KEY (BUSINESSTRANSACTIONCATEGORY, COMPANYCODE, CONTROLLINGAREA, CONTROLLINGDEBITCREDITCODE, CONTROLLINGKEYSUBNUMBER, COSTELEMENT, COSTORIGINGROUP, COSTORIGINTYPE, CTRLGORIGINCLASSIFICATION, ISLOTSIZEINDEPENDENT, MATERIAL, MFGORDERBUSTRANSACTIONTYPE, ORIGINBUSINESSPROCESS, ORIGINCOSTCENTER, ORIGINCOSTCTRACTIVITYTYPE, ORIGINOBJECT, ORIGINORDER, PARTNER, PARTNERBUSINESSPROCESS, PARTNERCOSTCENTER, PARTNERCOSTCTRACTIVITYTYPE, PARTNERORDER, PLANT, SUBLEDGERACCTLINEITEMTYPE, UNITOFMEASURE)
);

Learn More