SAP ABAP Table TDS_EXPDOC (Information on SD Documents with Validity Interval)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-SLS (Application Component) Sales
     ⤷ ERP_SALES_O2C_SLS (Package) ERP Sales Order 2 Cash - Sales

Basic Data

Table Category	INTTAB	Structure
Structure	TDS_EXPDOC	Table Relationship Diagram
Short Description	Information on SD Documents with Validity Interval

Delivery and Maintenance

Pool/cluster
Delivery Class
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	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
2	TRVOG	☐	TRVOG_VAL	TRVOG_VAL	CHAR	1	0	Transaction Group
3	TRVOGT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
4	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
5	AUARTT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
6	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
7	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
8	ZPAVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
9	ZPERS	☐	DZPERS	PERNR	NUMC	8	0	Person responsible
10	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
11	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
12	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
13	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
14	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
15	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
16	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
17	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
18	AWAHR	☐	AWAHR_AK	AWAHR	NUMC	3	0	Sales Probability
19	DATAB	☐	DATAB_VI	DATUM	DATS	8	0	Quotation or contract valid from
20	DATBI	☐	DATBI_VI	DATUM	DATS	8	0	Quotation or contract valid to
21	KUNNR_T	☐	KUNNR_TXT	NAME	CHAR	35	0	Customer description
22	PZPERS_T	☐	PZPERS_BEZ	NAME	CHAR	35	0	Name of Employee Responsible
23	PARVW_T	☐	PARVW_BEZ	TEXT20	CHAR	20	0	Description of partner function
24	VKORG_T	☐	VKORG_BEZ	TEXT20	CHAR	20	0	Description of sales organization
25	VTWEG_T	☐	VTWEG_BEZ	TEXT20	CHAR	20	0	Description of distribution channel
26	SPART_T	☐	SPART_BEZ	TEXT20	CHAR	20	0	Description of division
27	VKBUR_T	☐	VKBUR_BEZ	TEXT20	CHAR	20	0	Description of sales office
28	VKGRP_T	☐	VKGRP_BEZ	TEXT20	CHAR	20	0	Description of Sales Group
29	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
30	VBTYP_T	☐	VBTYP_TXT	AS4TEXT	CHAR	60	0	Description of sales and distribution document category

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TDS_EXPDOC	KUNNR	KNA1	KUNNR
2	TDS_EXPDOC	SPART	TSPA	SPART
3	TDS_EXPDOC	VKBUR	TVBUR	VKBUR
4	TDS_EXPDOC	VKGRP	TVKGR	VKGRP
5	TDS_EXPDOC	VKORG	TVKO	VKORG
6	TDS_EXPDOC	VTWEG	TVTW	VTWEG

History

Last changed by/on	SAP	20130529
SAP Release Created in	602