SAP table TB2BE (Trading Contract: Trading Contract Type)

SAP table TB2BE has 2 primary key fields being MANDT,TCTYP.

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 MANDT
TCTYP Trading Contract Type CHAR 4 0 TCTYP
TDTPV Control Group Purchasing for Trading Contracts CHAR 4 0 TB2BC TDTPV
TDTPC Control Group Sales for Trading Contracts CHAR 4 0 TB2BD TDTPC
STATGR Trading Contract: Status Group CHAR 1 0 TB2BB STATGR
TXTGR Text Determination Procedure CHAR 2 0 TTXG TXTGR
INCPO Item Number Increment of SD Documents NUMC 6 0 INCPO
DEFWAERS Trading Contract: Default Currency CUKY 5 0 TCURC DEFWAERS
DEFKURST Trading Contract: Default Exchange Rate Type CHAR 4 0 TCURV DEFKURST
NUMKI Number Range of Internal Number Assignment CHAR 2 0 NUMKI
TCUNCGR Trading Contract: Incompleteness Group CHAR 2 0 TB2BG TCUNCGR
TCSACHV Trading Contract: Default for Person Responsible CHAR 1 0 TCSACHV
No Default
A Default from Logon User
GBATCH Trading Contract: Automatic Generation of Batches CHAR 1 0 GBATCH
TCTDID Trading Contract: Default Text Type for Main Screen CHAR 4 0 TTXID TCTDID
WCHUN Trad. Contr.: Check Completeness Bef. Setting to Active CHAR 1 0 WCHUN
WCHQU Trad. Contr.: Check Quantities Before Setting to Active CHAR 1 0 WCHQU
LIVAR List variant for sales price calculation CHAR 2 0 TWST LIVAR
KAPPL_NA Application for output conditions CHAR 2 0 T681A NA_KAPPL
KALSMK_MGT Trading Contract: Message Schema for Messages for Employee CHAR 6 0 T683 KALSMB_MGT
KALSMP_MGT Trad.Contr: Message Schema f. Empl., Messages at Item Level CHAR 6 0 T683 KALSMBP_MGT
TC_URL Trading Contract URL CHAR 132 0 TC_URL
USE_CASE Use Case Type CHAR 2 0 WB2_USE_CASE_TYPE
Standard
10 Trading Contract Settlement (Washout)
11 Trading Contract Settlement (Circle)
12 Trading Contract Settlement (String)
13 Trading Contract Settlement (Energy)
CEACT Fast Data Entry of Characteristics Is Active CHAR 1 0 /SAPMP/CEACT
Fast Data Entry of Characteristics Is Not Active
X Fast Data Entry of Characteristics Is Active
PDACT Activate Inheritance CHAR 1 0 /SAPMP/PDACT
Inheritance Is Active
X Inheritance Has Been Deactivated
PPROT Log of Characteristic Value Inheritance CHAR 1 0 /SAPMP/PPROT
No Error List
X Issue of an Error List
PUSER Inheritance: Overwrite User Values CHAR 1 0 /SAPMP/PUSER
Values Set by Users Will Not Be Overwritten
X Values Set by Users May Be Overwritten
PAUSW Inheritance of Characteristics Selection List CHAR 1 0 /SAPMP/PAUSW
Characteristics Can Be Chosen from a List
X A Selection List Is Provided for the Characteristics
ATNAM Characteristic name CHAR 30 0 MILL_SE_ATNAM1
PARTNER_POP_UP Partner Selection Pop Up Required CHAR 1 0 WB2_PARTNER_POP_UP
TCCAT Trading Contract Category CHAR 1 0 TCCAT
Trading Contract With Follow-On Documents
A Precontract Without Follow-On Document Creation
TKONN_EX_ACT Trading Contract: External Identifier Active CHAR 1 0 TKONN_EX_ACT
External identifier not active
A External identifier active (optional)
B External identifier active (required); used for all displays
TKONN_EX_CHECK Trading Contract: Check External Identifier CHAR 1 0 TKONN_EX_CHECK
No Check
E Check With Error if Identifier Already Exists
W Check With Warning if Identifier Already Exists
TC_CHANGE_CHECK Trading Contract: Schema for Fields to be Checked CHAR 10 0 TB2BV TC_CHANGE_CHECK
POFOST Portfolio: Control Type for Portfolio Determination CHAR 4 0 TPOST WB2_CONTR_GROUP
BTBSTA_DEF_INCO Trading Contract: Default Application Status Incomplete CHAR 1 0 TB2BF BTBSTA_DEF_INCO
BTBSTA_DEF Trading Contract: Default Application Status CHAR 1 0 TB2BF BTBSTA_DEF
FOL_DOC_DIR Trading Contract: Create Follow-On Document When TC Posted CHAR 1 0 WB2_FOLLOW_DOC_DIRECT
No Direct Follow-On Document Generation
A Direct Asynchronized Follow-On Document Generation
X Direct Synchronized Follow-On Document Generation
TC_TYPE_BLOCK Trading Contract: Contract Type Block CHAR 1 0 WB2_TC_TYPE_BLOCK
Not blocked - can be used
X Blocked
PZUGR Responsibility Group CHAR 4 0 TPOFOB PZUGR
TCGROUP Trading Contract Group CHAR 4 0 TEWTCGROUP WB2_TCGROUP
DELIVDEF Trading Contract: Default Value for Delivery Date CHAR 1 0 WB2_DELIVDATE_DEFAULT
Proposal based on today's date
A No Default
PRICE_DEFAULT Trading Contract: Price Proposal CHAR 1 0 WB2_PRICE_DEFAULT
Price Entered Manually
A Price Proposed by System
PARGR Partner Determination Procedure CHAR 4 0 TVPG PARGR
CLOSING_RULE Trading Contract: Completion Rule CHAR 1 0 WB2_CLOSING_RULE
Complete When Fully Referenced (According to Copy Control)
A Complete When Referenced Once
B Is Never Complete
WB2_BEZOB Reference Required CHAR 1 0 WB2_BEZOB
No Reference Required
A Reference to Contract Required
B Reference to Pre-Contract Required
C Reference to Contract or Pre-Contract Required
D Reference to Template not Possible
ASSO_OFF Deactivate Association for One Side in Trading Contract CHAR 1 0 WB2_ASSO_OFF
No Deactivation
P Deactivate Association for Purchasing Side
S Deactivate Association for Sales Side
PRCHGRP Price Change Group CHAR 2 0 TB2BP4 WB2_PRCHGRP
BWREL Trading Contract Type: BW Relevance CHAR 1 0 BWREL
PRICING_TYPE Definition of Pricing Procedure in Trading Contract CHAR 1 0 WB2_PRICING_TYPE
Using Sales Pricing
1 Using Standard Pricing
TCVARIANT Transaction variant CHAR 30 0 SHDTVCIU TCVARIANT
GTS_RELEVANT Trading Contract Type Is Relevant for GTS Check CHAR 1 0 WB2_GTS_RELEVANT
Check Inactive
1 Sales-Side Check Active
2 Purchasing-Side Check Active
3 Check Active
4 Based on Trading Contract Type
EVENT_RELEVANT Trading Contract: Control of Event Call-Up CHAR 1 0 WB2_EVENT_RELEVANT
Not Called
1 Called
2 Called with Data Container
LIGRU List group CHAR 1 0 LIGRU
A Org. Levels Collective Calculation for Materials
B Material Collective Calculation for Org. Levels
C Display ALV - Org. Levels Collective Calculation for Matls
D Display ALV - Material Collective Calculation for Org.Levels
PLANT_CONTROL Control of Plant Entry in the Trading Contract CHAR 1 0 WB2_PLANT_CONTROL
Is Mandatory
1 Can Be Entered Later
2 Is Changeable if no Goods Movements Exist
PURCHASE_PLANT Control of Differing Ordering Plant in Trading Contract CHAR 1 0 WB2_PURCHASE_PLANT
Alternative Order Plant Is not Active
1 Alternative Order Plant Is Active
CONTEXT Context CHAR 10 0 TWUF_CONTEXT WUF_CONTEXT
TYPE_USAGE GTM: Usage of Trading Contract Type CHAR 1 0 WB2_TYPE_USAGE
No Restrictions
1 For Services Only
REP_GROUP Replication Group CHAR 4 0 TB2BS2 WB2_REPLICATION_GROUP
AR_OBJECT Document type CHAR 10 0 TOADV SAEOBJART
ITEM_HANDLING Control of Item Number Allocation for Enterprise SOA Call-Up CHAR 1 0 WB2_ITEM_HANDLING
Assigned Internally with Enterprise SOA Call-Up (Standard)
1 Identical with Reference Doc. Item w. Enterprise SOA Call-Up
CHANGE_DOC Scope of Change Document CHAR 1 0 WB2_CHANGE_DOC
Active at Document Level Without Document Conditions
1 Active at Document Level With Document Conditions
DOCUMENT_INDEX Document Index Active CHAR 1 0 WB2_DOCUMENT_INDEX_ACTIVE
DOC_INDEX_DELETE Delete Document Index When Document Is Closed CHAR 1 0 WB2_DOC_INDEX_DEL_AFTER_CLOSE
PARTNER_HI GT: Partner Hierarchy active CHAR 1 0 WB2_PARTNER_HIERARCHY
Inactive
1 Active
BATCH_DET_ACT Batch Determination for Trading Contract CHAR 1 0 WB2B_BATCH_DETERMINATION
TXZUF Text Group NUMC 4 0 TXZUF_WB2 WB2_TXZUF
SINGLE_ORG_DATA Control of Organizational Data Entry CHAR 1 0 WB2_SINGLE_ORG_DATA
always requires purchase and sales data
1 is determined by the contract type configuration
CONSOL_CONTEXT Context for Trading Contract consolidation CHAR 10 0 TSMT_CONTEXT WB2_CONSOLIDATION_CONTEXT
FREEZE_GROUP Group of Frozen Fields NUMC 4 0 WB2_C_FREEZE_H WB2_FREEZE_GROUP
CALL_OFF_PARTY Check Partner Authorizations for Contract Call Off CHAR 1 0 WB2_CALL_OFF_PARTY
No check
1 Partners in the Trading Contract
2 Partners in the hierarchy
WRART Settlement Process Type CHAR 4 0 TMZR WRART
LFART_C Alternative Settlement Doc. Type for Customer-Related Settl. CHAR 4 0 TMFK WB2_LFART_CUSTOMER
LFART_V Alternative Settlement Doc. Type for Supplier-Related Settl. CHAR 4 0 TMFK WB2_LFART_VENDOR
LFART Alternative Settlement Document Type at Contract Settlement CHAR 4 0 TMFK WB2_LFART
SET_VARIANT Business Process Variant for Contract Settlement CHAR 1 0 WB2_WASHOUT_SET_VARIANT
1 One Settlement Document for Both Business Partners
2 Separate Settlement Documents for Each Business Partner
3 Settlement Document for Supplier
4 Settlement Document for Customer
GTS_CHECK Legal Control Check CHAR 1 0 WB2_GTS_CHECK_AT_UPDATE
Check at update is inactive
1 Check at update is active
2 Check at update is active, no update if error occurs
FLOW_DISPLAY Document Flow Control Indicator CHAR 1 0 WB2_FLOW_DISPLAY
will be displayed within trading contract application
1 will not be displayed within trading contract application
FLOW_SIZE Max Number of Flow Entries to Show in the Document Flow Tree INT4 10 0 WB2_FLOW_SIZE
RELEASE_LOG Handling of Release Messages CHAR 1 0 WB2_RELEASE_LOG
No Update
1 Information Stored Without History Data
2 Information Stored with History Data
PURPOSE Purpose of Trading Contract CHAR 2 0 WB2_TC_PURPOSE
Standard Trading Contract
01 Trading Contract for Load Planning
02 Trading Contract for Load
03 Trading Contract for Price Fixings
ITEM_REL_TYPE Undefined range (can be used for patch levels) CHAR 4 0 CHAR4
LOCK_FOL_DOCS Lock for Follow-on Documents of a Trading Contract CHAR 1 0 WB2_LOCK_FOLLOW_ON_DOCS
Follow on documents will not be locked
1 Follow on documents will be locked
SETTL_PURPOSE Settlement Purpose of a Trading Contract CHAR 1 0 WB2_SETTLEMENT_PURPOSE
1 Washout Processing
2 Circle Processing
3 String Processing
4 Energy Processing
BATCH_CLASS Batch Classification is enabled CHAR 1 0 WB2_BATCH_CLASS_ENABLED
Batch Classification is not allowed
1 Batch Classification is allowed
2 Batch Classification: Display only
PPE_GROUP_CODE Pricing and Payment Event Group CHAR 4 0 PPE_C_GROUP PPE_GROUP
DELIVDEF_TYPE Trading Contract: Default for Date Type of Delivery Date CHAR 1 0 WB2_DELIVDATE_TYPE_DEFAULT
TRMRISK_CTRL TRM Raw Exposure Update Control CHAR 1 0 WB2_TRM_RISK_UPD_CONTROL
Update Inactive
1 Sales Side Update
2 Purchasing Side Update
3 Update Active
4 Based on Trading Contract Type
TIME_CONTROL Setting of Date and Time CHAR 1 0 WB2_TIME_CONTROL
Taken from Application Server
1 Taken from Local Date & Time of Current User
ITMAC Trade Compliance is active CHAR 1 0 /SAPSLL/ITMAC

TB2BE foreign key relationships

Table Field Check Table Check Field
0 TB2BE AR_OBJECT TOADV SAP ArchiveLink: Global document types MANDT
0 TB2BE AR_OBJECT TOADV SAP ArchiveLink: Global document types AR_OBJECT
1 TB2BE BTBSTA_DEF TB2BF Trading Contract: Status Group/Application Stat. Link MANDT
0 TB2BE BTBSTA_DEF_INCO TB2BF Trading Contract: Status Group/Application Stat. Link MANDT
1 TB2BE CONSOL_CONTEXT TSMT_CONTEXT Context CLIENT
0 TB2BE DEFKURST TCURV Exchange rate types for currency translation MANDT
0 TB2BE DEFKURST TCURV Exchange rate types for currency translation KURST
1 TB2BE DEFWAERS TCURC Currency Codes MANDT
1 TB2BE DEFWAERS TCURC Currency Codes WAERS
0 TB2BE FREEZE_GROUP WB2_C_FREEZE_H Header: Group of frozen fields CLIENT
0 TB2BE FREEZE_GROUP WB2_C_FREEZE_H Header: Group of frozen fields FOR_HEADER
1 TB2BE KALSMK_MGT T683 Pricing procedures KAPPL
1 TB2BE KALSMK_MGT T683 Pricing procedures KALSM
0 TB2BE KALSMP_MGT T683 Pricing procedures KAPPL
0 TB2BE KALSMP_MGT T683 Pricing procedures KALSM
1 TB2BE KAPPL_NA T681A Conditions: Applications KAPPL
0 TB2BE LFART TMFK Settlement Document Types LFART
1 TB2BE LFART_C TMFK Settlement Document Types LFART
0 TB2BE LFART_V TMFK Settlement Document Types LFART
1 TB2BE LIVAR TWST Sales Price Calculation: List Variants MANDT
1 TB2BE LIVAR TWST Sales Price Calculation: List Variants LIVAR
0 TB2BE PARGR TVPG Partner Function Groups PARGR
1 TB2BE POFOST TPOST Portfolio Determination: Control Table MANDT
1 TB2BE POFOST TPOST Portfolio Determination: Control Table KAPPL
0 TB2BE PPE_GROUP_CODE PPE_C_GROUP Pricing and Payment Event Groups MANDT
0 TB2BE PPE_GROUP_CODE PPE_C_GROUP Pricing and Payment Event Groups GROUP_CODE
1 TB2BE PRCHGRP TB2BP4 Price change group MANDT
1 TB2BE PRCHGRP TB2BP4 Price change group PRCHGRP
0 TB2BE PZUGR TPOFOB Responsibility Group MANDT
1 TB2BE REP_GROUP TB2BS2 Trading Contract: Replication Group MANDT
0 TB2BE STATGR TB2BB Trading Contract: Status Group Definition MANDT
0 TB2BE STATGR TB2BB Trading Contract: Status Group Definition STATGR
1 TB2BE TCGROUP TEWTCGROUP Trading Contract Groups MANDT
1 TB2BE TCGROUP TEWTCGROUP Trading Contract Groups TEW_TYPE
0 TB2BE TCUNCGR TB2BG Trading Contract: Incompleteness Group MANDT
0 TB2BE TCUNCGR TB2BG Trading Contract: Incompleteness Group TCUNCGR
1 TB2BE TC_CHANGE_CHECK TB2BV Trading Contract: Schema for Fields to be Checked MANDT
1 TB2BE TC_CHANGE_CHECK TB2BV Trading Contract: Schema for Fields to be Checked TC_CHANGE_CHECK
0 TB2BE TDTPC TB2BD Trading Contract: Sales Grouping MANDT
1 TB2BE TDTPV TB2BC Trading Contract: Purchasing Grouping MANDT
0 TB2BE TXTGR TTXG Text Processing: Text ID Groups MANDT
1 TB2BE TXZUF TXZUF_WB2 GT: Text Group MANDT
0 TB2BE WRART TMZR Settlement Process Types MANDT