SAP table COSS (Generated Table for View)

SAP table COSS has 14 primary key fields being MANDT,LEDNR,OBJNR,GJAHR,WRTTP,VERSN,KSTAR,HRKFT,VRGNG,PAROB,USPOB,BEKNZ,TWAER,PERBL.

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 T000 MANDT
LEDNR Ledger for Controlling Objects CHAR 2 0 LEDNR
00 Standard ledger
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
GJAHR Fiscal Year NUMC 4 0 GJAHR
WRTTP Value Type CHAR 2 0 CO_WRTTP
01 Plan
02 Plan: Splitting Among Activity Types
03 Actual: Splitting Among Activity Types
04 Actual
05 Target
06 Target (WIP)
07 Target: Splitting Among Activity Types
08 Plan: Correction for Internal Bus.Vol Between Cost Centers
09 Actual: Correction for IBV Between Cost Centers
10 Statistical Plan
11 Statistical Actual
12 Down Payment as Operating Expense
13 Statistical Down Payments as Expense
19 Order Receipt/Orders Balance
21 Commitments from Purchase Requisition
22 Purchase Order Commitment
23 Reservation Commitment
24 Funds Commitment
25 Remainder from Apportioned Orders/Networks (Order Commitmts)
26 Commitments from Transfer Price Agreement
28 Value from Customer Quotation
29 Value from Sales Order
2A Funds Reservation
2B Funds Precommitment
30 Scrap
31 Variances
32 Results Analysis and WIP Calculation
33 Results Analysis: Credit Side/Debit Side
34 Results Analysis: Cost of Sales from Resource-Rel. Billing
35 Plan for True Investments
36 Budget for True Investments
37 Program Budget for True Investments
38 Program Plan for True Investments
39 Request Plan
3C Control Costs
40 Request Plan for True Investments
41 Budget
42 Assigned Budget
43 Payment Budget
44 Payment Budget: Assigned Funds
45 Payment budget: Releases
46 Cash Release
47 Program Budget
48 Program Plan
49 Planned Accrual Calculations: Results Analysis, WIP Calc.
4A Payment Budget: Statistical
4B Budget Balance
4C Payment Budget: Clear on Revenue Item
50 Purchase Requisitions
51 Purchase Orders
52 Business Trip Commitments
53 User-Defined Payment Commitment (Financial Transaction 50)
54 Invoices
55 Bank clearings
56 User-Defined Payment Obligation (Financial Transaction 70)
57 Payments
58 Down Payment Requests
59 Down Payments for Bank Clearing
5A Payment Obligations from Purchasing Down Payments
60 Parked Document
61 Down Payments
62 Planned Payments
63 Down Payment Clearings
64 Funds Transfers
65 Funds Commitment
66 Profit Transfer Postings
67 Other Statistical Documents
68 Other Non-Statistical Document
69 Commitment Budget: Funds Reservations
6A Planned Down Payments
6B Clarification Worklist FI-CA
70 Commitment Budget
71 Commitment Budget - Assigned Funds
72 Commitment Budget: Releases
73 Purchase Order: Cycle Counting Blocking Amount
74 Funds Reservation: Cycle Counting Blocking Amount
75 Commitment Budget: Funds Reservation Cycle Cntg Blckng Amt
76 Commitment Budget: Purchase Orders, Cycle Counting Blckg Amt
77 Commitment Budget: Purchase Orders
7C Commitment Budget: Expense Type Budget for Revenue Item
80 Funds Block
81 Funds Reservation
82 Funds Precommitment
83 Forecast of Revenue
84 Payment Reservation
85 Payment Budget: Reservations
86 Payment Budget: Earmarked Funds
87 Payment Budget: Reserved Releases
88 Payment Budget: Earmarked Releases
89 Commitment Budget: Reservations
90 Commitment Budget: Earmarked Funds
91 Commitment Budget: Reserved Releases
92 Commitment Budget: Earmarked Releases
93 Financial Budget
94 Payment Budget: Adjustment Field
95 Actual CO Postings
96 Purchase Order Overhead
97 Purchase Requisition Overhead
98 Funds Reservation (CO)
99 Financial Result
9A Financial Result: Statistical
9B Financial Budget: Statistical
9C Financial Budget Plan Balance
9D Funds Management: HR Integration
9E Approved Total Costs/Revenue
D1 Distribution of Actual Costs (By Source Assignment)
D2 Distribution of Commitments (By Source Assignment)
D3 Distribution of Work-in-Process (By Source Assignment)
D4 Distribution of Earned Value (By Source Assignment)
D5 Distribution of Payments (By Source Assignment)
D6 Distribution of Down Payments (By Source Assignment)
P1 Earned Value (Plan)
P2 Earned Value (Actual)
P3 Capitalized Remainder Costs
U1 Source Document - Statistical Actuals
U4 Source Document - Actual
VERSN Version CHAR 3 0 TKA09 VERSN
KSTAR Cost Element CHAR 10 0 CSKA KSTAR
HRKFT CO key subnumber CHAR 14 0 CO_SUBKEY
VRGNG CO Business Transaction CHAR 4 0 CO_VORGANG
PAROB Partner Object CHAR 22 0 ONR00 PAROB
USPOB Source Object (Cost Center/Activity Type) CHAR 22 0 ONR00 USPOB
BEKNZ Debit/credit indicator CHAR 1 0 BEKNZ
A Special: Sender credit from settlement
H Credit posting or sender credit posting
L Special: Sender credit from delivery to inventory
S Debit posting or receiver debit posting
TWAER Transaction Currency CUKY 5 0 TCURC TWAER
PERBL Period Block NUMC 3 0 PERBL
MEINH Unit of Measure UNIT 3 0 T006 CO_MEINH
WTG001 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG002 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG003 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG004 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG005 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG006 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG007 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG008 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG009 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG010 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG011 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG012 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG013 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG014 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG015 Total Value in Transaction Currency CURR 23 2 WTGXXX
WTG016 Total Value in Transaction Currency CURR 23 2 WTGXXX
WOG001 Total Value in Object Currency CURR 23 2 WOGXXX
WOG002 Total Value in Object Currency CURR 23 2 WOGXXX
WOG003 Total Value in Object Currency CURR 23 2 WOGXXX
WOG004 Total Value in Object Currency CURR 23 2 WOGXXX
WOG005 Total Value in Object Currency CURR 23 2 WOGXXX
WOG006 Total Value in Object Currency CURR 23 2 WOGXXX
WOG007 Total Value in Object Currency CURR 23 2 WOGXXX
WOG008 Total Value in Object Currency CURR 23 2 WOGXXX
WOG009 Total Value in Object Currency CURR 23 2 WOGXXX
WOG010 Total Value in Object Currency CURR 23 2 WOGXXX
WOG011 Total Value in Object Currency CURR 23 2 WOGXXX
WOG012 Total Value in Object Currency CURR 23 2 WOGXXX
WOG013 Total Value in Object Currency CURR 23 2 WOGXXX
WOG014 Total Value in Object Currency CURR 23 2 WOGXXX
WOG015 Total Value in Object Currency CURR 23 2 WOGXXX
WOG016 Total Value in Object Currency CURR 23 2 WOGXXX
WKG001 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG002 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG003 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG004 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG005 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG006 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG007 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG008 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG009 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG010 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG011 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG012 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG013 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG014 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG015 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKG016 Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKF001 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF002 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF003 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF004 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF005 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF006 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF007 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF008 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF009 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF010 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF011 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF012 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF013 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF014 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF015 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WKF016 Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
PAG001 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG002 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG003 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG004 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG005 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG006 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG007 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG008 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG009 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG010 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG011 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG012 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG013 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG014 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG015 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAG016 Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAF001 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF002 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF003 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF004 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF005 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF006 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF007 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF008 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF009 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF010 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF011 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF012 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF013 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF014 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF015 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
PAF016 Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
MEG001 Total Quantity QUAN 15 3 MEGXXX
MEG002 Total Quantity QUAN 15 3 MEGXXX
MEG003 Total Quantity QUAN 15 3 MEGXXX
MEG004 Total Quantity QUAN 15 3 MEGXXX
MEG005 Total Quantity QUAN 15 3 MEGXXX
MEG006 Total Quantity QUAN 15 3 MEGXXX
MEG007 Total Quantity QUAN 15 3 MEGXXX
MEG008 Total Quantity QUAN 15 3 MEGXXX
MEG009 Total Quantity QUAN 15 3 MEGXXX
MEG010 Total Quantity QUAN 15 3 MEGXXX
MEG011 Total Quantity QUAN 15 3 MEGXXX
MEG012 Total Quantity QUAN 15 3 MEGXXX
MEG013 Total Quantity QUAN 15 3 MEGXXX
MEG014 Total Quantity QUAN 15 3 MEGXXX
MEG015 Total Quantity QUAN 15 3 MEGXXX
MEG016 Total Quantity QUAN 15 3 MEGXXX
MEF001 Fixed Quantity QUAN 15 3 MEFXXX
MEF002 Fixed Quantity QUAN 15 3 MEFXXX
MEF003 Fixed Quantity QUAN 15 3 MEFXXX
MEF004 Fixed Quantity QUAN 15 3 MEFXXX
MEF005 Fixed Quantity QUAN 15 3 MEFXXX
MEF006 Fixed Quantity QUAN 15 3 MEFXXX
MEF007 Fixed Quantity QUAN 15 3 MEFXXX
MEF008 Fixed Quantity QUAN 15 3 MEFXXX
MEF009 Fixed Quantity QUAN 15 3 MEFXXX
MEF010 Fixed Quantity QUAN 15 3 MEFXXX
MEF011 Fixed Quantity QUAN 15 3 MEFXXX
MEF012 Fixed Quantity QUAN 15 3 MEFXXX
MEF013 Fixed Quantity QUAN 15 3 MEFXXX
MEF014 Fixed Quantity QUAN 15 3 MEFXXX
MEF015 Fixed Quantity QUAN 15 3 MEFXXX
MEF016 Fixed Quantity QUAN 15 3 MEFXXX
MUV001 Quantities Incomplete CHAR 1 0 MUVXX
MUV002 Quantities Incomplete CHAR 1 0 MUVXX
MUV003 Quantities Incomplete CHAR 1 0 MUVXX
MUV004 Quantities Incomplete CHAR 1 0 MUVXX
MUV005 Quantities Incomplete CHAR 1 0 MUVXX
MUV006 Quantities Incomplete CHAR 1 0 MUVXX
MUV007 Quantities Incomplete CHAR 1 0 MUVXX
MUV008 Quantities Incomplete CHAR 1 0 MUVXX
MUV009 Quantities Incomplete CHAR 1 0 MUVXX
MUV010 Quantities Incomplete CHAR 1 0 MUVXX
MUV011 Quantities Incomplete CHAR 1 0 MUVXX
MUV012 Quantities Incomplete CHAR 1 0 MUVXX
MUV013 Quantities Incomplete CHAR 1 0 MUVXX
MUV014 Quantities Incomplete CHAR 1 0 MUVXX
MUV015 Quantities Incomplete CHAR 1 0 MUVXX
MUV016 Quantities Incomplete CHAR 1 0 MUVXX
BELTP Debit Type NUMC 1 0 BP_INOUT
0
1 Costs and credit-side payments
2 Revenues and debit-side payments
TIMESTMP Time created (Greenwich Meantime) DEC 16 0 RKE_HZSTMP
BUKRS Company Code CHAR 4 0 BUKRS
FKBER Functional Area CHAR 16 0 FKBER
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_SEGMENT
GEBER Fund CHAR 10 0 FM_FUND
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
BUDGET_PD Budget Period CHAR 10 0 FM_BUDGET_PERIOD

COSS foreign key relationships

Table Field Check Table Check Field
0 COSS KSTAR CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
0 COSS KSTAR CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
1 COSS MANDT T000 Clients MANDT
0 COSS MEINH T006 Units of Measurement MANDT
0 COSS MEINH T006 Units of Measurement MSEHI
1 COSS OBJNR ONR00 General Object Number MANDT
0 COSS PAROB ONR00 General Object Number MANDT
0 COSS PAROB ONR00 General Object Number OBJNR
1 COSS SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
0 COSS TWAER TCURC Currency Codes MANDT
0 COSS TWAER TCURC Currency Codes WAERS
1 COSS USPOB ONR00 General Object Number MANDT
1 COSS USPOB ONR00 General Object Number OBJNR
0 COSS VERSN TKA09 Basic Settings for Versions MANDT
0 COSS VERSN TKA09 Basic Settings for Versions KOKRS
0 COSS VERSN TKA09 Basic Settings for Versions VERSN