SAP table COBRB (Distribution Rules Settlement Rule Order Settlement)

SAP table COBRB has 6 primary key fields being MANDT,OBJNR,LEDNR,LDGRP,BUREG,LFDNR.

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
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
LEDNR Ledger in General Ledger Accounting CHAR 2 0 FINS_LEDGER
LDGRP Ledger Group CHAR 4 0 FAGL_LDGRP
BUREG Distribution Rule Group NUMC 3 0 BRSGR
LFDNR Sequence Number of Distribution Rule NUMC 7 0 BR_LFDNR
PERBZ Settlement Type CHAR 3 0 PERBZ_LD
AUT Automatic Settlement
EPA Line Item Settlement
GES Full Settlement
JHR Capitalization in AUC
PER Periodic Settlement
VOR Periodic Settlement Before AUC Capitalization
URZUO Source Assignment CHAR 3 0 TSC0D URZUO
GABJA Valid-from Year NUMC 4 0 GABJA
GABPE Valid-from Period NUMC 3 0 GABPE
GBISJ Valid-to Year NUMC 4 0 GBISJ
GBISP Valid To NUMC 3 0 GBISP
PROZS Settlement Percentage Rate DEC 5 2 BRGPROZS
AQZIF Equivalence Number for Order Settlement DEC 10 0 AQZIF
BMENG Quantity for Settlement QUAN 15 3 BRGMENGE
BEINH Unit of Measure UNIT 3 0 T006 BRGMEINH
BETRR Amount for Amount Rule CURR 23 2 BETRR
BWAER Currency for the Amount in the Amount Rule CUKY 5 0 TCURC BRGBWAER
BRTYP Amount Rule Type CHAR 2 0 BRTYP
Settle Each Period
01 Amount Is Upper Limit
UO Settle One Time Only
BREST Remaining Amount for Amount Settlement w. Amount Rule Cat. CURR 23 2 AMOUNTREST
ERSJA Year First Used NUMC 4 0 ERSJA
ERSPE Period of First Use NUMC 3 0 ERSPE
LETJA Year Last Used NUMC 4 0 LETJA
LETPE Period of Last Use NUMC 3 0 LETPE
ZINCL "Including Overheads" - Indicator CHAR 1 0 DZINCL
DFREG Default Rule CHAR 3 0 TKB2A DFREG
AVORG Settlement Transaction CHAR 4 0 TJ01 AVORG
VERSN Version CHAR 3 0 VERSN
KONTY Account assignment category CHAR 2 0 KONTY
KOKRS Controlling Area of Receiver CHAR 4 0 TKA01 BRGKOKRS
WERKS Plant CHAR 4 0 WERKS_D
GSBER Business Area CHAR 4 0 GSBER
BUKRS Company Code CHAR 4 0 T001 BUKRS
HKONT G/L Account Number CHAR 10 0 SKA1 SAKNR
PRCTR Profit Center CHAR 10 0 PRCTR
KOSTL Receiver Cost Center CHAR 10 0 BRGKOSTL
AUFNR Order Number CHAR 12 0 AUFK AUFNR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
ANLN1 Main Asset Number CHAR 12 0 ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLN2
MATNR Material Number CHAR 40 0 MATNR
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
NPLNR Network Number for Account Assignment CHAR 12 0 AUFK NPLNR
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL Internal counter NUMC 8 0 CIM_COUNT
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PASUBNR Profitability Segment Changes (CO-PA) NUMC 4 0 RKESUBNR
KDAUF Sales Order Number CHAR 10 0 KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
RECID Recovery Indicator CHAR 2 0 T8JJ JV_RECIND
RIFIND Derivation Rule for Recovery Indicator in Settlement (JV) CHAR 1 0 JV_RIFIND
1 Transfer from sender summary records
2 Transfer from master records for receiver objects
3 Transfer from master records for settlement cost element
4 Transfer from settlement assignment
5 Manual entry in allocation rule
POSNR Order item number NUMC 4 0 CO_POSNR
KSTRG Cost Object CHAR 12 0 KSTRG
PRZNR Business Process CHAR 12 0 CO_PRZNR
REC_OBJNR1 Object Number for Settlement Receiver CHAR 22 0 ONR00 SREC_OBJNR
REC_OBJNR2 Object Number for Settlement Receiver CHAR 22 0 ONR00 SREC_OBJNR
MRULE Manipulation Rule CHAR 4 0 T8JL1 MANIPRULE
EXTNR Distribution Rule Number NUMC 7 0 COBR_EXTNR
STRAT Method for Determining the Tracing Factor for Settlement NUMC 3 0 CO_STRAT
000 Manual Setting of Tracing Factor
005 Delivery Value with Product Cost Collector
010 Settlement by Amount Fixed-Price Co-Product
ANBWA Asset Transaction Type CHAR 3 0 TABW ANBWA
SRSTRAT Strategy for Automatic Generation of Settlement Rules CHAR 3 0 TKB10SA SR_STRAT

COBRB foreign key relationships

Table Field Check Table Check Field
0 COBRB ANBWA TABW Asset transaction types MANDT
1 COBRB AUFNR AUFK Order master data AUFNR
0 COBRB AVORG TJ01 Business Transactions VRGNG
1 COBRB BEINH T006 Units of Measurement MANDT
1 COBRB BEINH T006 Units of Measurement MSEHI
0 COBRB BUKRS T001 Company Codes BUKRS
1 COBRB BWAER TCURC Currency Codes MANDT
1 COBRB BWAER TCURC Currency Codes WAERS
0 COBRB BWTAR T149D Global Valuation Types MANDT
0 COBRB BWTAR T149D Global Valuation Types BWTAR
1 COBRB DFREG TKB2A Default Rules for Posting Rules MANDT
0 COBRB HKONT SKA1 G/L Account Master (Chart of Accounts) MANDT
0 COBRB HKONT SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 COBRB HKONT SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 COBRB KOKRS TKA01 Controlling Areas MANDT
0 COBRB MANDT T000 Clients MANDT
1 COBRB MRULE T8JL1 Joint Venture: Manipulation Rules for Recovery Indicator MANDT
1 COBRB MRULE T8JL1 Joint Venture: Manipulation Rules for Recovery Indicator KOKRS
1 COBRB MRULE T8JL1 Joint Venture: Manipulation Rules for Recovery Indicator MRULE
0 COBRB NPLNR AUFK Order master data AUFNR
1 COBRB OBJNR ONR00 General Object Number MANDT
0 COBRB RECID T8JJ Recovery Indicator MANDT
0 COBRB RECID T8JJ Recovery Indicator BUKRS
1 COBRB REC_OBJNR1 ONR00 General Object Number MANDT
1 COBRB REC_OBJNR1 ONR00 General Object Number OBJNR
0 COBRB REC_OBJNR2 ONR00 General Object Number MANDT
0 COBRB REC_OBJNR2 ONR00 General Object Number OBJNR
1 COBRB URZUO TSC0D Assignment Table MANDT
1 COBRB URZUO TSC0D Assignment Table SCZUO