SAP table COBK (CO Object: Document Header)

SAP table COBK has 3 primary key fields being MANDT,KOKRS,BELNR.

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
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
BELNR Document Number CHAR 10 0 CO_BELNR
GJAHR Fiscal Year NUMC 4 0 GJAHR
VERSN Version in CO Document Header CHAR 3 0 TKA09 VERSN_COBK
VRGNG CO Business Transaction CHAR 4 0 TJ01 CO_VORGANG
TIMESTMP Time created (Greenwich Meantime) DEC 16 0 RKE_HZSTMP
PERAB From Period NUMC 3 0 CO_PERAB
PERBI To period NUMC 3 0 CO_PERBI
BLDAT Document Date DATS 8 0 CO_BLDAT
BUDAT Posting Date DATS 8 0 CO_BUDAT
CPUDT Date Document Was Created DATS 8 0 CO_CPUDT
USNAM User Name CHAR 12 0 SYUNAME
BLTXT Document Header Text CHAR 50 0 CO_BLTXT
STFLG Identifier for reversal document CHAR 1 0 CO_STFLG
STOKZ Indicator: Document was reversed CHAR 1 0 CO_STOKZ
REFBT Document Type of Reference Document CHAR 1 0 CO_REFBT
REFBN Reference Document Number CHAR 10 0 CO_REFBN
REFBK Company Code of FI Document CHAR 4 0 T001 CO_REFBK
REFGJ Fiscal Year of Reference Document NUMC 4 0 CO_REFGJ
BLART Document Type of FI Reference Document CHAR 2 0 T003 CO_REFBA
LDGRP Ledger Group CHAR 4 0 * FAGL_LDGRP
ORGVG Original CO Business Transaction CHAR 4 0 T022 CO_ORGVG
SUMBZ Number of Posting Lines for Local Objects NUMC 3 0 CO_SUMBZ
DELBZ Number of Deleted Line Items NUMC 3 0 CO_DELBZ
WSDAT Value Date for Currency Translation DATS 8 0 WSDAT
KURST Exchange Rate Type CHAR 4 0 TCURV KURST
VARNR CO actual postings fast input: Variant CHAR 5 0 CO_VARNR
KWAER Controlling area currency CUKY 5 0 TCURC KWAER
CTYP1 Currency Type 1 in CO Standard Ledger CHAR 2 0 CO_CTYP1
CTYP2 Currency Type 2 in CO Standard Ledger CHAR 2 0 CO_CTYP2
CTYP3 Currency Type 3 in CO Standard Ledger CHAR 2 0 CO_CTYP3
CTYP4 Currency Type 4 in CO Standard Ledger CHAR 2 0 CO_CTYP4
AWTYP Reference procedure CHAR 5 0 * AWTYP
AWORG Reference Organizational Units CHAR 10 0 AWORG
LOGSYSTEM Logical System CHAR 10 0 TBDLS LOGSYSTEM
CPUTM Time of Entry TIMS 6 0 CPUTM
ALEBZ Number of Posting Rows Sent to External Systems NUMC 3 0 CO_ALEBZ
ALEBN For ALE: CO Document Number in Generating System CHAR 10 0 CO_ALEBN
AWSYS Logical system of source document CHAR 10 0 * AWSYS
AWREF_REV Reversal: Reference Document No. of Document to Be Reversed CHAR 10 0 AWREF_REV
AWORG_REV Reversal: Reference Organizations of Document to Be Reversed CHAR 10 0 AWORG_REV
AWKEY Reference Key CHAR 20 0 AWKEY
VALDT Special Valuation Date for Cost Accounting DATS 8 0 CO_VALDT
KOKRS_SENDER Controlling Area in Sender System CHAR 4 0 KOKRS_SENDER
BELNR_SENDER CO Document Number of Controlling Document in Sender System CHAR 10 0 COBELNR_SENDER
LOGSYSTEM_SENDER Logical System of the Sender CHAR 10 0 LOGSYSTEM_SENDER
REPROCESSING_STATUS_CODE Reprocessing status code CHAR 1 0 FINS_REPROCESSING_STATUS_CODE
1 Invalid after Correction
2 Reverses Document after Correction
3 Valid after Correction
4 Temporary Posting
5 Reverses Temporary Posting

COBK foreign key relationships

Table Field Check Table Check Field
0 COBK BLART T003 Document Types MANDT
1 COBK KOKRS TKA01 Controlling Areas MANDT
0 COBK KURST TCURV Exchange rate types for currency translation MANDT
0 COBK KURST TCURV Exchange rate types for currency translation KURST
1 COBK KWAER TCURC Currency Codes MANDT
1 COBK KWAER TCURC Currency Codes WAERS
0 COBK LOGSYSTEM TBDLS Logical system LOGSYS
1 COBK MANDT T000 Clients MANDT
0 COBK REFBK T001 Company Codes BUKRS
1 COBK VERSN TKA09 Basic Settings for Versions MANDT
1 COBK VERSN TKA09 Basic Settings for Versions KOKRS
1 COBK VERSN TKA09 Basic Settings for Versions VERSN
0 COBK VRGNG TJ01 Business Transactions VRGNG