SAP table TKB9G (PA Transfer Structure: Source)

SAP table TKB9G has 4 primary key fields being MANDT,ERSCH,ERZUO,KOKRS.

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
ERSCH PA Transfer Structure CHAR 2 0 TKB9A ERSCH
ERZUO PA Transfer Structure Assignment CHAR 3 0 TKB9C ERZUO
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
CLASS Set Class CHAR 4 0 * SETCLASS
SETNR Group Name CHAR 15 0 GRPNAME
VALMIN From Value CHAR 40 0 SETVALMIN
VALMAX To Value CHAR 40 0 SETVALMAX
ABKAT Category for Variance/Results Analysis NUMC 2 0 ABKAT
01 Input Price Variance PRIV
02 Exchange Rate Variance EXRV
04 Input Quantity Variance QTYV
06 Resource-Usage Variance RSUV
11 Remaining Input Variance INPV
20 Mixed-Price Variance MXPV
21 Output Price Variance OPPV
22 Lot Size Variance/Fixed-Cost Variance LSFV
24 Output Quantity Variance OPQV
31 Remaining Variance REMV
41 Scrap SCRP
43 Incoming Orders: New Order IONO
44 Incoming Orders: Changed Order IOCO
45 Incoming Orders: Rejection IORE
46 Incoming Orders: Change in Plan IOCP
49 Order Balance: Reduction by Billing Documents OBRB
50 Other Results Analysis Data ORAD
51 Work in Process with Requirement to Capitalize WIPR
52 Work in Process with Option to Capitalize WIPO
53 Work in Process with Prohibition to Capitalize WIPP
54 Reserves for Unrealized Costs (Group with Req. to Cap.) RUCR
55 Reserves for Unrealized Costs (Grp with Option to Cap.) RUCO
56 Reserves for Unrealized Costs (Grp w/ Prohib. to Cap.) RUCP
57 Reserves for Cost of Comp./Comm. (Grp w/ Req. to Cap.) RCCR
58 Reserves for Cost of Comp./Comm. (Grp w/ Opt. to Cap.) RCCO
59 Reserves for Cost of Comp./Comm. (Grp w/Prohib.to Cap.) RCCP
60 Reserves for Imminent Loss RIML
61 Reserves for Imm. Loss, Including Inv. w/Option to Cap. RILC
62 Capitalized Profit CAPP
63 Cost of Sales with Requirement to Capitalize COSR
64 Cost of Sales with Option to Capitalize COSO
65 Cost of Sales with Prohibition to Capitalize COSP
66 Calculated Costs CLCO
67 Calculated Revenue CLRV
68 Revenue in Excess of Billings (POC Method) POCI
69 Revenue Surplus (POC Method) POCS
70 Calculated Profit (POC Method) POCP
71 Loss (POC Method) POCL
72 Realized Loss (POC Method, Data for Profit. Analysis) POCR
73 Valuated Costs VLCO
74 Valuated Cost of Complaints and Commissions VLCC
75 Valuated Actual Revenue/Revenue Affecting Net Income VLRV
76 Variance from Results Analysis VARR
79 Reduction in Rev. Excess of Billings by Down Payments RRDP
80 Down Payment Surplus DNPS
81 Planned Revenue of Valuation PLRV
82 Planned Costs of Valuation PLCV
95 Revenue from Debit Results Analysis RDRA
96 Inventory from Debit Results Analysis IDRA
97 Costs from Credit Results Analysis CCRA
98 Reserves from Credit Results Analysis RCRA
99 Inventory from Credit Results Analysis ICRA
BEMOT Accounting Indicator CHAR 2 0 TBMOT BEMOT
RECIND Recovery Indicator CHAR 2 0 T8JJ JV_RECIND

TKB9G foreign key relationships

Table Field Check Table Check Field
0 TKB9G BEMOT TBMOT Accounting indicators MANDT
0 TKB9G BEMOT TBMOT Accounting indicators BEMOT
1 TKB9G ERSCH TKB9A Assignment Structure for Settlement to Profitability Anysis MANDT
1 TKB9G ERSCH TKB9A Assignment Structure for Settlement to Profitability Anysis ERSCH
0 TKB9G ERZUO TKB9C Assignment in PA Transfer Structures MANDT
1 TKB9G KOKRS TKA01 Controlling Areas MANDT
0 TKB9G RECIND T8JJ Recovery Indicator MANDT
0 TKB9G RECIND T8JJ Recovery Indicator BUKRS