SAP ABAP Table TVTA (Organizational Unit: Sales Area(s))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VZCORE (Package) B2R: BAPI Structures

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TVTA	Table Relationship Diagram
Short Description	Organizational Unit: Sales Area(s)

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
3	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
4	SPART	☑	SPART	SPART	CHAR	2	0	Division	TVKOS
5	.INCLUDE	☐				0	0	Organizational Unit: Sales Area(s)
6	VTWKU	☐	VTWKU	VTWEG	CHAR	2	0	Reference distrib.channel for cust.and material masters	TVTW
7	SPAKU	☐	SPAKU	SPART	CHAR	2	0	Reference division for customers	TSPA
8	VTWKO	☐	VTWKO	VTWEG	CHAR	2	0	Reference distribution channel for conditions	TVTW
9	SPAKO	☐	SPAKO	SPART	CHAR	2	0	Reference division for conditions	TSPA
10	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
11	VKOAU	☐	VKOAU	VKORG	CHAR	4	0	Reference sales org.for sales doc.types (by sales area)	TVKO
12	VTWAU	☐	VTWAU	VTWEG	CHAR	2	0	Distribution channel for sales doc types	TVTW
13	SPAAU	☐	SPAAU	SPART	CHAR	2	0	Reference division for document types (by sales area)	TSPA
14	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
15	REGGB	☐	REGGB	REGGB	NUMC	3	0	Rule for determining the business area
16	REVFP	☐	REVFP	REVFP	CHAR	1	0	Rule for transferring the results of the availability check
17	FIXMG	☐	FIXMG	XFELD	CHAR	1	0	Delivery date and quantity fixed
18	AFIND	☐	AFIND	XFELD	CHAR	1	0	Promo determination
19	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
20	J_1ASNR	☐	J_1ADBRNCH	J_1BBRANCH	CHAR	4	0	Branch for domestic operations	J_1BBRANCH
21	J_1AESNR	☐	J_1AEBRNCH	J_1BBRANCH	CHAR	4	0	Branch for export operations	J_1BBRANCH
22	.INCLU--AP	☐				0	0	IS-M/AM: Append Structure for Sales Area
23	ISP_VB	☐	VERBBEZ	BEZIRK	CHAR	10	0	IS-M: Distribution Zone	JVTBEZIRK
24	ISM_BP_VTB_GROUP	☐	GROUP_SALESAREA	ISM_GROUP_SALESAREA	CHAR	4	0	IS-M: Sales Area Group for Business Partner Selection	TJH_GR_SALESAREA
25	.INCLU--AP	☐				0	0	CEM: Append to Table TVTA
26	.INCLUDE	☐				0	0	CEM: Include for Table TVTA
27	J_3GKBAUL	☐	J_3GKBAUL	J_3GKBAUL	CHAR	1	0	ETM-Relevant Indicator
28	.INCLU--AP	☐				0	0	IS-Oil Append for TVTA
29	OID_CHECKC	☐	OID_CHECKC	OIDMSG_PRD	CHAR	1	0	Check customer ship-to/sold-to warning/error/information

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TVTA	GSBER	TGSB	GSBER	REF	C	CN
2	TVTA	ISM_BP_VTB_GROUP	TJH_GR_SALESAREA	GR_SA
3	TVTA	ISP_VB	JVTBEZIRK	BEZIRK	REF	1	CN
4	TVTA	J_1AESNR	J_1BBRANCH	BRANCH
5	TVTA	J_1ASNR	J_1BBRANCH	BRANCH		1	CN
6	TVTA	KKBER	T014	KKBER		C	CN
7	TVTA	MABER	T047M	MABER	REF	C	CN
8	TVTA	SPAAU	TSPA	SPART	REF	1	CN
9	TVTA	SPAKO	TSPA	SPART	REF	C	CN
10	TVTA	SPAKU	TSPA	SPART	REF	1	CN
11	TVTA	SPART	TVKOS	SPART	KEY	1	CN
12	TVTA	VKOAU	TVKO	VKORG	REF	1	CN
13	TVTA	VKORG	TVKO	VKORG	KEY	1	CN
14	TVTA	VTWAU	TVTW	VTWEG	REF	1	CN
15	TVTA	VTWEG	TVKOV	VTWEG	KEY	1	CN
16	TVTA	VTWKO	TVTW	VTWEG	REF	1	CN
17	TVTA	VTWKU	TVTW	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20100310
SAP Release Created in