SAP ABAP Table TDS_DLVDATE (CP_APPL_SLS: SD Delivery Date Info)

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_DLVDATE	Table Relationship Diagram
Short Description	CP_APPL_SLS: SD Delivery Date Info

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	.INCLUDE	☐				0	0	CP_APPL_SLS: General Sales Document
2	.INCLUDE	☐				0	0	SD Docs General + Div. Flags (Deliv. Block, Bill.Block...)
3	.INCLUDE	☐				0	0	SD Documents General
4	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
5	TRVOG	☐	TRVOG_GEN	TRVOG_GEN	CHAR	1	0	Transaction Group
6	TRVOGT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
7	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
8	AUARTT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
9	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
10	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
11	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
12	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
13	ZPAVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
14	ZPERS	☐	DZPERS	PERNR	NUMC	8	0	Person responsible
15	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
16	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
17	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
18	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
19	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
20	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
21	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
22	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
23	AWAHR	☐	AWAHR_AK	AWAHR	NUMC	3	0	Sales Probability
24	DATAB	☐	DATAB_VI	DATUM	DATS	8	0	Quotation or contract valid from
25	DATBI	☐	DATBI_VI	DATUM	DATS	8	0	Quotation or contract valid to
26	F_ALL	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
27	F_OPEN	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
28	F_INC	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
29	F_DELBLOCK	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
30	F_BILLBLOCK	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
31	NAME_KUN	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
32	NAME_ZPERS	☐	NAME1_VP	NAME	CHAR	35	0	Name 1 of a partner
33	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
34	VDATU	☐	EDATU_VBAK	DATUM	DATS	8	0	Requested delivery date
35	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
36	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
37	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
38	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	*
39	VSART	☐	VSARTTR	VERSART	CHAR	2	0	Shipping type	*
40	TRATY	☐	TRATY	TRATY	CHAR	4	0	Means-of-Transport Type	*
41	TRMTYP	☐	TRMTYP	MATNR	CHAR	18	0	Means of Transportation	*
42	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
43	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
44	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	*
45	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
46	DISPZPAVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
47	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	*
48	FAKSKT	☐	BEZEI_FAKSP	TEXT20	CHAR	20	0	Description
49	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	*
50	LIFSKT	☐	BEZEI_LIFSP	TEXT20	CHAR	20	0	Description
51	LEDAT	☐	LEDAT	DATUM	DATS	8	0	Delivery Creation Date

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in	604