SAP ABAP Table TDS_SLS_IND_PR (Individual Purchase Document Structure)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD (Application Component) Sales and Distribution
     ⤷ ERP_SALES_O2C_WHOLESALE (Package) ERP Sales Order 2 Cash - Wholesale

Basic Data

Table Category	INTTAB	Structure
Structure	TDS_SLS_IND_PR	Table Relationship Diagram
Short Description	Individual Purchase Document Structure

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	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
2	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
3	BSART	☐	BBSRT	BSART	CHAR	4	0	Purchase Requisition Document Type	T161
4	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
5	BEDNR	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
6	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
7	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
9	MENGE	☐	BAMNG	MENG13	QUAN	13	3	Purchase requisition quantity
10	MEINS	☐	BAMEI	MEINS	UNIT	3	0	Purchase requisition unit of measure	T006
11	BADAT	☐	BADAT	DATUM	DATS	8	0	Requisition (request) date
12	LFDAT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
13	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
14	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
15	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
16	FRGDT	☐	FRGDT	DATUM	DATS	8	0	Purchase Requisition Release Date
17	LIFNR	☐	WLIEF	LIFNR	CHAR	10	0	Desired vendor	LFA1
18	LIFNAM	☐	NAME1	TEXT30	CHAR	30	0	Name
19	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	LFA1
20	FLFNAM	☐	NAME1	TEXT30	CHAR	30	0	Name
21	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
22	BSMNG	☐	BSMNG	MENG13	QUAN	13	3	Quantity ordered against this purchase requisition
23	BMEIN	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
24	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
25	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
26	EBAKZ	☐	EBAKZ	XFELD	CHAR	1	0	Purchase requisition closed
27	PREIS	☐	BAPRE	WERT11	CURR	11	2	Price in Purchase Requisition
28	STATU	☐	BANST	BANST	CHAR	1	0	Processing status of purchase requisition
29	BANPR	☐	BANPR	BANPR	CHAR	2	0	Requisition Processing State
30	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
31	TRVOG	☐	TRVOG_GEN	TRVOG_GEN	CHAR	1	0	Transaction Group
32	TRVOG_T	☐	BEZEI20	TEXT20	CHAR	20	0	Description
33	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
34	AUART_T	☐	BEZEI20	TEXT20	CHAR	20	0	Description
35	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
36	KUNAG_T	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
37	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
38	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
39	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
40	ZPAVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
41	ZPERS	☐	DZPERS	PERNR	NUMC	8	0	Person responsible
42	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
43	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
44	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
45	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
46	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
47	PZPERS_T	☐	NAME1	TEXT30	CHAR	30	0	Name
48	PARVW_T	☐	PARVW_BEZ	TEXT20	CHAR	20	0	Description of partner function
49	VKORG_T	☐	VKORG_BEZ	TEXT20	CHAR	20	0	Description of sales organization
50	VTWEG_T	☐	VTWEG_BEZ	TEXT20	CHAR	20	0	Description of distribution channel
51	SPART_T	☐	SPART_BEZ	TEXT20	CHAR	20	0	Description of division
52	VKBUR_T	☐	VKBUR_BEZ	TEXT20	CHAR	20	0	Description of sales office
53	VKGRP_T	☐	VKGRP_BEZ	TEXT20	CHAR	20	0	Description of Sales Group
54	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
55	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
56	VBTYP_T	☐	VBTYP_TXT	AS4TEXT	CHAR	60	0	Description of sales and distribution document category
57	POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
58	GBSTK	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
59	ETENR	☐	ETENR	ETENR	NUMC	4	0	Schedule line	*
60	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
61	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
62	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
63	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
64	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
65	STATU_T	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
66	GBSTK_T	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
67	BANPR_T	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
68	FRGGR	☐	FRGGR	FRGGR	CHAR	2	0	Release group	*
69	EDATU	☐	EDATU	DATUM	DATS	8	0	Schedule line date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TDS_SLS_IND_PR	AUART	TVAK	AUART
2	TDS_SLS_IND_PR	BMEIN	T006	MSEHI
3	TDS_SLS_IND_PR	BSART	T161	BSART
4	TDS_SLS_IND_PR	EKGRP	T024	EKGRP
5	TDS_SLS_IND_PR	EKORG	T024E	EKORG
6	TDS_SLS_IND_PR	FLIEF	LFA1	LIFNR
7	TDS_SLS_IND_PR	KNTTP	T163K	KNTTP
8	TDS_SLS_IND_PR	KUNAG	KNA1	KUNNR
9	TDS_SLS_IND_PR	LIFNR	LFA1	LIFNR
10	TDS_SLS_IND_PR	MEINS	T006	MSEHI
11	TDS_SLS_IND_PR	PSTYP	T163	PSTYP
12	TDS_SLS_IND_PR	WAERS	TCURC	WAERS
13	TDS_SLS_IND_PR	WERKS	T001W	WERKS

History

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