SAP table TB2BC (Trading Contract: Purchasing Grouping)

SAP table TB2BC has 2 primary key fields being MANDT,TDTPV.

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
TDTPV Control Group Purchasing for Trading Contracts CHAR 4 0 TDTPV
BSTYP Purchasing Document Category CHAR 1 0 BSTYP_TC
F Purchase Order
K Contract
BSART Order Type (Purchasing) CHAR 4 0 T161 BSART
DEFWAERS Trading Contract: Default Currency CUKY 5 0 TCURC DEFWAERS
DEFKURST Trading Contract: Default Exchange Rate Type CHAR 4 0 TCURV DEFKURST
FTACTIVE Trading Contract: Foreign Trade Data Active CHAR 1 0 FTACTIVE
PUINRE Trading Contract: Read Purchasing Info Record CHAR 1 0 PUINRE
EKERV Purchase Price Determination Sequence CHAR 2 0 TWEV EKERV_M
HKLA Delivery Address Origin CHAR 1 0 HKLA
Plant address
A Ship-to party address of the customer
KALSMK_MM Trading Contract: Message Schema for Supplier Messages CHAR 6 0 T683 KALSMB_MM
KALSMP_MM Message Schema for Supplier Messages at Item Level CHAR 6 0 T683 KALSMBP_MM
SYNC_PARTNER_MM Sync follow on partner with trading contract CHAR 1 0 WB2_SYNC_PARTNER
PRICING_TYPE_PO Pricing Type for Purchase Order Item Creation CHAR 1 0 PRICING_TYPE_PO
SYNC_STATUS Transfer Item Complete Status to PO Item CHAR 1 0 WB2_SYNC_STATUS
Information is not transfered to purchase order item
1 Information is transfered to purchase order item
LOP_GROUP Logistical Option Group CHAR 4 0 LOP_C_GRP LOP_GROUP
PRICING_COPY_TO_PO Copy Price to PO in Purchasing Contract Scenario CHAR 1 0 WB2_COPY_TC_PRICING_TO_PO

TB2BC foreign key relationships

Table Field Check Table Check Field
0 TB2BC BSART T161 Purchasing Document Types MANDT
1 TB2BC DEFKURST TCURV Exchange rate types for currency translation MANDT
1 TB2BC DEFKURST TCURV Exchange rate types for currency translation KURST
0 TB2BC DEFWAERS TCURC Currency Codes MANDT
0 TB2BC DEFWAERS TCURC Currency Codes WAERS
1 TB2BC EKERV TWEV Pricing: Determination procedure MANDT
1 TB2BC EKERV TWEV Pricing: Determination procedure KAPPL
0 TB2BC KALSMK_MM T683 Pricing procedures KAPPL
0 TB2BC KALSMK_MM T683 Pricing procedures KALSM
1 TB2BC KALSMP_MM T683 Pricing procedures KAPPL
1 TB2BC KALSMP_MM T683 Pricing procedures KALSM
0 TB2BC LOP_GROUP LOP_C_GRP Group for Logistical Option Categories LOP_GROUP