SAP table FCOCOSTESTSDM (Generated Table for View)

SAP table FCOCOSTESTSDM has 8 primary key fields being MANDT,BZOBJ,KALNR,KALKA,KADKY,TVERS,BWVAR,KKZMA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BZOBJ Reference Object CHAR 1 0 CK_OBJ
KALNR Cost Estimate Number - Product Costing NUMC 12 0 CKHS CK_KALNR1
KALKA Costing Type CHAR 2 0 CK_KALKA
KADKY Costing Date (Key) DATS 8 0 CK_KADKY
TVERS Costing Version NUMC 2 0 CK_TVERS
BWVAR Valuation Variant in Costing CHAR 3 0 TCK05 CK_BWVAR
KKZMA Costs Entered Manually in Additive or Automatic Cost Est. CHAR 1 0 CK_KKZMA
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
BWKEY Valuation area CHAR 4 0 T001K BWKEY
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KADAT Costing Date From DATS 8 0 CK_ABDAT
BIDAT Costing Date To DATS 8 0 CK_BIDAT
KADAM Costing Date From DATS 8 0 CK_ABDAT
BIDAM Costing Date To DATS 8 0 CK_BIDAT
BWDAT Valuation Date of a Cost Estimate DATS 8 0 CK_BWDAT
ALDAT Quantity Structure Date for Costing DATS 8 0 CK_BRDAT
BEDAT Requirements Date DATS 8 0 CK_BEDAT
VERID Production Version CHAR 4 0 VERID
STNUM Bill of Material CHAR 8 0 STNUM
STLAN BOM Usage CHAR 1 0 STLAN
STALT Alternative BOM CHAR 2 0 STALT
STCNT Internal counter NUMC 8 0 CIM_COUNT
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PLNTY Task List Type CHAR 1 0 PLNTY
PLNAL Group Counter CHAR 2 0 PLNAL
PLNCT Internal counter NUMC 8 0 CIM_COUNT
LOEKZ Deletion Indicator for Product Costing CHAR 1 0 CK_LOEKZ
LOSGR Lot Size for Product Costing QUAN 13 3 CK_LOSGR
MEINS Valuation Unit of Measure UNIT 3 0 T006 CK_MEINH_BEW
ERFNM Costed by User CHAR 12 0 CK_KALKUSR
ERFMA User ID of Person Who Created Additive Cost Estimate CHAR 12 0 CK_ERFMA
CPUDT Date on Which Cost Estimate Was Created DATS 8 0 CK_CPUDT
CPUDM Date on Which Additive Cost Estimate Was Saved DATS 8 0 CK_CPUDM
CPUTIME System Time TIMS 6 0 SYUZEIT
FEH_ANZ No. System Messages in Selection/Qty Structure Determination INT4 10 0 CK_FEH_ANZ
FEH_K_ANZ Number of System Messages in Costing INT4 10 0 CK_FEH_ANK
FEH_STA Costing Status CHAR 2 0 CK_FEH_STA
MAXMSG Message Type CHAR 1 0 SYMSGTY
FREIG Release of Standard Cost Estimate CHAR 1 0 CK_FREIG
MKALK Mixed Costing Indicator CHAR 1 0 CK_MKALK
BALTKZ Cost Estimate for a Procurement Alternative CHAR 1 0 CK_BALT_FLAG
KALNR_BA Cost Estimate Number of Procurement Alternative NUMC 12 0 CKKALNRBA
BTYP Process Category CHAR 4 0 CKML_BTYP
MISCH_VERH Mixed Costing: Mixing Ratio DEC 13 3 CK_MISCHVERH
BWVAR_BA Valuation Variant of Procurement Alternative CHAR 3 0 CK_BWVAR_BA
PLSCN Planning Scenario in Long-Term Planning NUMC 3 0 PLSCN
PLMNG Production Plan Quantity Transferred to the Cost Estimate QUAN 15 3 CKI_PLMNG
SOBSL Special Procurement Key for the Costing Object CHAR 2 0 CK_SOBSK
SOBES Special procurement type CHAR 1 0 SOBES
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
9 IS-OIL only: Stock transfer reservation
E Standard in-house production
P Production in plant 2
SOWRK Special Procurement Plant - Costing CHAR 4 0 CK_SOWRK
SOBWT Valuation Type from Special Procurement CHAR 10 0 CK_SOBWT
SODIR Indicator for Direct Production (Collective Order) CHAR 1 0 CLCOR
SODUM Phantom item indicator CHAR 1 0 DUMPS
KALSM Costing Sheet for Calculating Overhead CHAR 6 0 T683 CK_KALSM
AUFZA Overhead Type CHAR 1 0 AUFZA
1 Actual overhead rate
2 Planned overhead rate
3 Commitment overhead rate
BWSMR Valuation Strategy for Raw Materials and Purchased Parts CHAR 1 0 CK_BWSMR
SUBSTRAT Substrategy for Material Valuat. with Purchasing Info Record CHAR 1 0 CK_SUBSTRAT
RLDNR Ledger in General Ledger Accounting CHAR 2 0 FINS_LEDGER
KLVAR Costing Variant CHAR 4 0 TCK03 CK_KLVAR
KOSGR Costing Overhead Group CHAR 10 0 TCK14 CK_KOSGR
ZSCHL Overhead key CHAR 6 0 TKZSL AUFZSCHL
POPER Posting period NUMC 3 0 POPER
BDATJ Posting Date YYYY NUMC 4 0 BDATJ
STKOZ Internal counter NUMC 8 0 CIM_COUNT
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
TOPKA Top Cost Estimate (Point-of-Entry Position) CHAR 1 0 CK_TOPKA
CMF_NR Error Management Number NUMC 12 0 CMF_NR
OCS_COUNT Number of OCS Messages Sent NUMC 5 0 CMF_OCSCNT
OBJNR Object number CHAR 22 0 J_OBJNR
ERZKA Cost Estimate Created with Product Costing CHAR 1 0 CK_ERZKA
LOSAU Lot Size Taking Scrap into Account QUAN 13 3 CK_LOSAU
AUSID Assembly/Operation Scrap Included CHAR 1 0 CK_AUSID
No Assembly Scrap or Operation Scrap
1 Assembly Scrap Only
2 Operation Scrap Only
3 Assembly Scrap and Operation Scrap
AUSSS Assembly scrap in percent DEC 5 2 AUSSS
SAPRL Release the document as it was last saved CHAR 4 0 KK_SAPRL
KZROH Material Component CHAR 1 0 CK_KZROH
AUFPL Routing No. for Operations with Non-Order-Related Production NUMC 10 0 CK_AUFPL
CUOBJ Object Number for Conf. Objects NUMC 18 0 CK_CUOBJ
CUOBJID Indicator for Configurable Objects CHAR 1 0 CK_CUOBJID
1 Configured Material (Variant)
2 Configurable Material
TECHS Parameter Variant/Standard Variant CHAR 12 0 TECHS
TYPE Configured Material (Variant) CHAR 40 0 MARA CK_TYPE
WRKLT Plant (Variant) CHAR 4 0 CK_WRKLT
VORMDAT Date on Which Cost Estimate Was Marked DATS 8 0 CK_VORMDAT
VORMUSR User Who Marked Cost Estimate in Material Master CHAR 12 0 CK_VORMUSR
FREIDAT Date on Which Cost Estimate Released in Material Master DATS 8 0 CK_FREIDAT
FREIUSR User Who Released Cost Estimate in Material Master Record CHAR 12 0 CK_FREIUSR
UEBID Transfer Control CHAR 4 0 CK_UEBID
PROZESS Process Through Which Co-Product Was Costed CHAR 40 0 CK_PROZESS
PR_VERID Production Version To Be Costed CHAR 4 0 MKAL CK_VERID
CSPLIT Apportionment Structure CHAR 4 0 CSPLIT
KZKUP Indicator: Material can be co-product CHAR 1 0 KZKUPMAT
FXPRU Fixed-Price Co-Product CHAR 1 0 CK_FIXPRKU
CFXPR Cost Estimate Contains Fixed-Price Co-Products CHAR 1 0 CK_CONTFIXPRICE
ZIFFR Equivalence Number DEC 3 0 CK_ZIFFR
SUMZIFFR Sum of Equivalence Numbers of Co-Products for a Process DEC 5 0 CK_SUMZIFFR
AFAKT Costg.: Apportionment Factor for Itemiz. Line in Joint Prod. FLTP 16 16 CK_SPLITFAC
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
POSNR Item number of the SD document NUMC 6 0 POSNR
PSPNR Work Breakdown Structure Element (WBS element) NUMC 8 0 WB_POSNR
SBDKZ Dependent requirements ind. for individual and coll. reqmts CHAR 1 0 SBDKZ
Individual and collective requirements
1 Individual requirements only
2 Collective requirements only
MLMAA Material Ledger Activated at Material Level CHAR 1 0 CK_ML_MAAC
BESKZ Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
DISST Low-Level Code CHAR 3 0 DISST
KALST Costing Level NUMC 4 0 CK_KALST
TEMPLATE Template CHAR 10 0 ABC_TEMPL
PATNR Partner number for costing NUMC 6 0 NKPRTN
PART_VRSN Partner Version NUMC 2 0 CK_PARVRSN
ELEHK Cost Component Structure - CGM and Sales/Administr. Costs CHAR 2 0 CK_ELESMHK
ELEHKNS Cost Component Structure for Auxiliary Cost Component Split CHAR 2 0 CK_ELESMNS
VOCNT Counter for Marking a Cost Estimate NUMC 1 0 CK_VOCNT
GSBER Business Area CHAR 4 0 GSBER
PRCTR Profit Center CHAR 10 0 PRCTR
SEGUNIT Valuation Segmentation Unit CHAR 30 0 FINS_SEGMENTATION_UNIT
TPVAR Variant for Finding Transfer Price CHAR 3 0 TPVAR1 TPVARIANT
KURST Exchange Rate Type CHAR 4 0 TCURV KURST
MGTYP Quantity Structure Type CHAR 5 0 CKMLMV006 CKML_MGTYP
HWAER Local Currency CUKY 5 0 HWAER
FWAER_KPF Currency Key CUKY 5 0 WAERS
REFID Reference Variant NUMC 2 0 CK_REFID
MEINH_WS Batch-specific matl unit of measure (proportion/prod. unit) UNIT 3 0 LRMEI_WS
KZWSO Units of measure usage CHAR 1 0 KZWSO
Alternative unit of measure
A Proportion unit
B Product unit
ASL Cost Estimate of an Order BOM CHAR 1 0 CK_ASL
KALAID Name of Costing Run CHAR 8 0 CK_KALAID
KALADAT Costing Run Date DATS 8 0 CK_KALADAT
OTYP Object Type CHAR 2 0 CKML_OTYP
BA Procurement Alternative
EB Sales Order Stock
LA Activity Type
MB Material (Valuation Level)
MK Material (Totals Record: Valuation Area)
OB Vendor Stock
PR Procurement Process
QB Project Stock
ST Material (Summation Level)
VA Consumption Alternative
WL WIP Activity Type
WM WIP Material
BVC_SOBSL_USE Use special procurement stock transfer for broken val. chain CHAR 1 0 CK_BVC_SOBSL_USE
BAPI_CREATED Cost Estimate Generated by BAPI CHAR 1 0 CK_BAPI
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
LOGSYSTEM_SENDER Logical System of the Sender CHAR 10 0 LOGSYSTEM_SENDER
BZOBJ_SENDER Reference Object CHAR 1 0 CK_OBJ
KALNR_SENDER Cost Estimate Number - Product Costing of the Sender NUMC 12 0 CK_KALNR1_SENDER
KALKA_SENDER Costing Type CHAR 2 0 CK_KALKA
KADKY_SENDER Costing Date (Key) DATS 8 0 CK_KADKY
TVERS_SENDER Costing Version NUMC 2 0 CK_TVERS
BWVAR_SENDER Valuation Variant in Costing CHAR 3 0 CK_BWVAR
KKZMA_SENDER Costs Entered Manually in Additive or Automatic Cost Est. CHAR 1 0 CK_KKZMA
/CWM/XCWMAT Material Is Activated for CW CHAR 1 0 /CWM/XCWMAT
/CWM/LOSGR_BAS Costing Lot Size in Base Unit of Measure QUAN 13 3 /CWM/CK_LOSGR_BAS
/CWM/MEINH_BAS Base Unit of Measure UNIT 3 0 MEINS
/CWM/LOSGR_BEW Costing Lot Size in Valuation Unit of Measure QUAN 13 3 /CWM/CK_LOSGR_BEW
/CWM/MEINH_BEW Valuation Unit of Measure UNIT 3 0 /CWM/CK_MEINH_BEW
CRULE Cost Apportionment Methods CHAR 1 0 CSPLITRULE
1 Quantity-Based
2 Equivalence Numbers
3 Quantity-Based with Equivalence Numbers
PACKNO Package number NUMC 10 0 PACKNO
INTROW Internal line number for limits NUMC 10 0 INTROW
BOSFSHT Schema for Additions/Deductions CHAR 4 0 BOSFSHT
BOSDVERSION Version NUMC 3 0 BOSDVERS
GRC_COSTING Goods Receipt Costing CHAR 1 0 CK_GRC_COSTING
CLINT Internal Class Number NUMC 10 0 CLINT
PPEGUID Internal Identification for PVS Objects RAW 16 0 PVS_GUID
OTYPE iPPE Object Type CHAR 1 0 PVS_OTYPE
A Alternative
N Node
R Relationship
V Variant
APPLOBJ_TYPE Application Object Type for iPPE CHAR 4 0 PVS_APPLOBJ_TYPE
AENNR Change Number CHAR 12 0 AENNR
IPPE_COSTING Costing for a Material with iPPE Quantity Structure CHAR 1 0 CK_IPPE_COSTING
CMPEXT_NONCOL Internal Identification of the Component (Material/Product) CHAR 40 0 PVS_CMPID
CCODE Color Supplement Key CHAR 10 0 PVS_COL_CODE
NONCOL_VERID Production Version CHAR 4 0 VERID
VBELV Originating Document CHAR 10 0 VBELV
POSNV Originating Item NUMC 6 0 POSNV
SDM_STATUS NUMC 2 0

FCOCOSTESTSDM foreign key relationships

Table Field Check Table Check Field
0 FCOCOSTESTSDM BWTAR T149D Global Valuation Types MANDT
0 FCOCOSTESTSDM BWTAR T149D Global Valuation Types BWTAR
1 FCOCOSTESTSDM BWVAR TCK05 Valuation Variants in Costing MANDT
0 FCOCOSTESTSDM KALNR CKHS Header: Unit Costing (Control + Totals) MANDT
0 FCOCOSTESTSDM KALNR CKHS Header: Unit Costing (Control + Totals) LEDNR
0 FCOCOSTESTSDM KALNR CKHS Header: Unit Costing (Control + Totals) KALNR
0 FCOCOSTESTSDM KALNR CKHS Header: Unit Costing (Control + Totals) KALKA
0 FCOCOSTESTSDM KALNR CKHS Header: Unit Costing (Control + Totals) KADKY
0 FCOCOSTESTSDM KALNR CKHS Header: Unit Costing (Control + Totals) TVERS
0 FCOCOSTESTSDM KALNR CKHS Header: Unit Costing (Control + Totals) BWVAR
0 FCOCOSTESTSDM KALNR CKHS Header: Unit Costing (Control + Totals) KKZMA
1 FCOCOSTESTSDM KALSM T683 Pricing procedures KAPPL
1 FCOCOSTESTSDM KALSM T683 Pricing procedures KALSM
0 FCOCOSTESTSDM KLVAR TCK03 Costing Variants MANDT
1 FCOCOSTESTSDM KOKRS TKA01 Controlling Areas MANDT
0 FCOCOSTESTSDM KOSGR TCK14 Overhead Groups MANDT
0 FCOCOSTESTSDM KOSGR TCK14 Overhead Groups KOSGR
1 FCOCOSTESTSDM KURST TCURV Exchange rate types for currency translation MANDT
1 FCOCOSTESTSDM KURST TCURV Exchange rate types for currency translation KURST
0 FCOCOSTESTSDM MATNR MARA General Material Data MANDT
0 FCOCOSTESTSDM MATNR MARA General Material Data MATNR
1 FCOCOSTESTSDM MEINS T006 Units of Measurement MANDT
1 FCOCOSTESTSDM MEINS T006 Units of Measurement MSEHI
0 FCOCOSTESTSDM PR_VERID MKAL Production Versions of Material WERKS
0 FCOCOSTESTSDM PR_VERID MKAL Production Versions of Material VERID
1 FCOCOSTESTSDM TPVAR TPVAR1 Variants for Finding Transfer Prices MANDT
1 FCOCOSTESTSDM TPVAR TPVAR1 Variants for Finding Transfer Prices KOKRS
0 FCOCOSTESTSDM TYPE MARA General Material Data MATNR
1 FCOCOSTESTSDM WERKS T001W Plants/Branches MANDT
1 FCOCOSTESTSDM WERKS T001W Plants/Branches WERKS
0 FCOCOSTESTSDM ZSCHL TKZSL Overhead Key ZSCHL