SAP table TB2BD (Trading Contract: Sales Grouping)

SAP table TB2BD has 2 primary key fields being MANDT,TDTPC.

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
TDTPC Control Group Sales for Trading Contracts CHAR 4 0 TDTPC
AUART Sales Document Type CHAR 4 0 TVAK AUART
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
WCHLC Check Finance Docs Before Setting Trading Contract Active CHAR 1 0 WCHLC
VKERV Sales Price Determination Sequence CHAR 2 0 TWEV EKERV_V
KALSMK_SD Trading Contract: Message Schema for Customer Messages CHAR 6 0 T683 KALSMB_SD
KALSMP_SD Message Schema for Customer Messages at Item Level CHAR 6 0 T683 KALSMBP_SD
POSANDEB Anonymous Customer CHAR 10 0 KNA1 POSANDEB
CM_ACTIVE Credit Management Check Active CHAR 1 0 WCM_ACTIVE
Check Not Active
1 Check Active
PRICING_TYPE_SO Pricing Type for Sales Order Item Creation CHAR 1 0 PRICING_TYPE_SO
ABGRU_SD Reason for Rejection of Quotations and Sales Orders CHAR 2 0 TVAG ABGRU_SD
LOP_GROUP Logistical Option Group CHAR 4 0 LOP_C_GRP LOP_GROUP

TB2BD foreign key relationships

Table Field Check Table Check Field
0 TB2BD ABGRU_SD TVAG Sales Documents: Rejection Reasons MANDT
0 TB2BD ABGRU_SD TVAG Sales Documents: Rejection Reasons ABGRU
1 TB2BD AUART TVAK Sales Document Types MANDT
1 TB2BD AUART TVAK Sales Document Types AUART
0 TB2BD DEFKURST TCURV Exchange rate types for currency translation MANDT
0 TB2BD DEFKURST TCURV Exchange rate types for currency translation KURST
1 TB2BD DEFWAERS TCURC Currency Codes MANDT
1 TB2BD DEFWAERS TCURC Currency Codes WAERS
0 TB2BD KALSMK_SD T683 Pricing procedures KAPPL
0 TB2BD KALSMK_SD T683 Pricing procedures KALSM
1 TB2BD KALSMP_SD T683 Pricing procedures KAPPL
1 TB2BD KALSMP_SD T683 Pricing procedures KALSM
0 TB2BD LOP_GROUP LOP_C_GRP Group for Logistical Option Categories LOP_GROUP
1 TB2BD POSANDEB KNA1 General Data in Customer Master MANDT
1 TB2BD POSANDEB KNA1 General Data in Customer Master KUNNR
0 TB2BD VKERV TWEV Pricing: Determination procedure MANDT
0 TB2BD VKERV TWEV Pricing: Determination procedure KAPPL