_COSTS

76 Fields

_COSTS is an SAP database table in S/4HANA. It contains 76 fields.

Fields (76)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY ChartOfAccounts ChartOfAccounts 1
KEY CompanyCode CompanyCode 11
KEY ControllingArea ControllingArea 5
KEY ControllingKeySubNumber ControllingKeySubNumber 1
KEY ControllingValueType ControllingValueType 1
KEY CostElement CostElement 3
KEY CostOriginGroup CostOriginGroup 3
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket 1
KEY FinancialPlanningEntryItem FinancialPlanningEntryItem 1
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc 1
KEY FiscalYear FiscalYear 1
KEY GLAccount GLAccount 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY Material Material 3
KEY OrderID OrderID 4
KEY OrderItem OrderItem 3
KEY OrderOperation OrderOperation 1
KEY PartnerCostCenter PartnerCostCenter 2
KEY PartnerCostCtrActivityType PartnerCostCtrActivityType 2
KEY PlanningCategory PlanningCategory 1
KEY Plant Plant 6
KEY Product Product 2
KEY SelectedCurrencyBranch SelectedCurrencyBranch 1
KEY UnitOfMeasure UnitOfMeasure 3
KEY WorkCenterInternalID WorkCenterInternalID 1
ActlCostInDspCrcy ActlCostInDspCrcy 1
ActualQuantity ActualQuantity 1
CompanyCodeCurrency CompanyCodeCurrency 1
ControllingDebitCreditCode ControllingDebitCreditCode 1
ControllingObject ControllingObject 1
CostOriginGroupForFilter CostOriginGroupForFilter 1
CreditActlCostInDspCrcy CreditActlCostInDspCrcy 1
CreditPlanCostInDspCrcy CreditPlanCostInDspCrcy 1
CtrlgOriginClassification CtrlgOriginClassification 1
CtrlgOrignClassificationFoFltr CtrlgOrignClassificationFoFltr 1
DebitActlCostInDspCrcy DebitActlCostInDspCrcy 1
DebitActlPlnDiffCostInDspCrcy DebitActlPlnDiffCostInDspCrcy 1
DebitPlanCostInDspCrcy DebitPlanCostInDspCrcy 1
DisplayCurrency DisplayCurrency 2
InptPrVarcAmtInDspCrcy InptPrVarcAmtInDspCrcy 1
InptQtyVarcAmtInDspCrcy InptQtyVarcAmtInDspCrcy 1
IsLotSizeIndependent IsLotSizeIndependent 1
IsMarkedForDeletion IsMarkedForDeletion 1
LotSizeVarcAmtInDspCrcy LotSizeVarcAmtInDspCrcy 1
MaterialForFilter MaterialForFilter 1
MfgOrderHasMultipleItems MfgOrderHasMultipleItems 1
MRPPlant MRPPlant 1
OrderCategory OrderCategory 1
OrderDescription OrderDescription 1
OrderType OrderType 1
OriginCostCenter OriginCostCenter 1
OriginCostCtrActivityType OriginCostCtrActivityType 1
OriginObject OriginObject 1
OutpPrVarcAmtInDspCrcy OutpPrVarcAmtInDspCrcy 1
Partner Partner 1
PartnerAccountAssignment PartnerAccountAssignment 1
PartnerOrder PartnerOrder 1
PlanCostInDspCrcy PlanCostInDspCrcy 1
PlanQuantity PlanQuantity 1
PlantForFilter PlantForFilter 1
ProductionVersion ProductionVersion 1
ProfitCenter ProfitCenter 1
ReferenceOrder ReferenceOrder 1
ResponsibleCostCenter ResponsibleCostCenter 1
RmngVarcAmtInDspCrcy RmngVarcAmtInDspCrcy 1
RsceUsgeVarcAmtInDspCrcy RsceUsgeVarcAmtInDspCrcy 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
StorageLocation StorageLocation 1
SubLedgerAcctLineItemType SubLedgerAcctLineItemType 1
UnrlzdCostRsrvAmtInDspCrcy UnrlzdCostRsrvAmtInDspCrcy 1
WBSElementInternalID WBSElementInternalID 1
WIPCostInDspCrcy WIPCostInDspCrcy 1
WIPQuantity WIPQuantity 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 _COSTS (
    ACCOUNTINGDOCUMENT,
    CHARTOFACCOUNTS,
    COMPANYCODE,
    CONTROLLINGAREA,
    CONTROLLINGKEYSUBNUMBER,
    CONTROLLINGVALUETYPE,
    COSTELEMENT,
    COSTORIGINGROUP,
    FINANCIALPLANNINGDATAPACKET,
    FINANCIALPLANNINGENTRYITEM,
    FINANCIALPLANNINGREQTRANSSQNC,
    FISCALYEAR,
    GLACCOUNT,
    LEDGER,
    LEDGERGLLINEITEM,
    MATERIAL,
    ORDERID,
    ORDERITEM,
    ORDEROPERATION,
    PARTNERCOSTCENTER,
    PARTNERCOSTCTRACTIVITYTYPE,
    PLANNINGCATEGORY,
    PLANT,
    PRODUCT,
    SELECTEDCURRENCYBRANCH,
    UNITOFMEASURE,
    WORKCENTERINTERNALID,
    ACTLCOSTINDSPCRCY,
    ACTUALQUANTITY,
    COMPANYCODECURRENCY,
    CONTROLLINGDEBITCREDITCODE,
    CONTROLLINGOBJECT,
    COSTORIGINGROUPFORFILTER,
    CREDITACTLCOSTINDSPCRCY,
    CREDITPLANCOSTINDSPCRCY,
    CTRLGORIGINCLASSIFICATION,
    CTRLGORIGNCLASSIFICATIONFOFLTR,
    DEBITACTLCOSTINDSPCRCY,
    DEBITACTLPLNDIFFCOSTINDSPCRCY,
    DEBITPLANCOSTINDSPCRCY,
    DISPLAYCURRENCY,
    INPTPRVARCAMTINDSPCRCY,
    INPTQTYVARCAMTINDSPCRCY,
    ISLOTSIZEINDEPENDENT,
    ISMARKEDFORDELETION,
    LOTSIZEVARCAMTINDSPCRCY,
    MATERIALFORFILTER,
    MFGORDERHASMULTIPLEITEMS,
    MRPPLANT,
    ORDERCATEGORY,
    ORDERDESCRIPTION,
    ORDERTYPE,
    ORIGINCOSTCENTER,
    ORIGINCOSTCTRACTIVITYTYPE,
    ORIGINOBJECT,
    OUTPPRVARCAMTINDSPCRCY,
    PARTNER,
    PARTNERACCOUNTASSIGNMENT,
    PARTNERORDER,
    PLANCOSTINDSPCRCY,
    PLANQUANTITY,
    PLANTFORFILTER,
    PRODUCTIONVERSION,
    PROFITCENTER,
    REFERENCEORDER,
    RESPONSIBLECOSTCENTER,
    RMNGVARCAMTINDSPCRCY,
    RSCEUSGEVARCAMTINDSPCRCY,
    SALESORDER,
    SALESORDERITEM,
    STORAGELOCATION,
    SUBLEDGERACCTLINEITEMTYPE,
    UNRLZDCOSTRSRVAMTINDSPCRCY,
    WBSELEMENTINTERNALID,
    WIPCOSTINDSPCRCY,
    WIPQUANTITY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, CHARTOFACCOUNTS, COMPANYCODE, CONTROLLINGAREA, CONTROLLINGKEYSUBNUMBER, CONTROLLINGVALUETYPE, COSTELEMENT, COSTORIGINGROUP, FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGENTRYITEM, FINANCIALPLANNINGREQTRANSSQNC, FISCALYEAR, GLACCOUNT, LEDGER, LEDGERGLLINEITEM, MATERIAL, ORDERID, ORDERITEM, ORDEROPERATION, PARTNERCOSTCENTER, PARTNERCOSTCTRACTIVITYTYPE, PLANNINGCATEGORY, PLANT, PRODUCT, SELECTEDCURRENCYBRANCH, UNITOFMEASURE, WORKCENTERINTERNALID)
);

Learn More