SAP ABAP Table VLPMA (SD Index: Delivery Items by Material)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VL (Package) WS-SHP: General Processing for Shipping

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VLPMA	Table Relationship Diagram
Short Description	SD Index: Delivery Items by Material

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	VSTEL	☑	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
4	LFDAT	☑	LFDAT	DATUM	DATS	8	0	Delivery date
5	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
6	LFART	☑	LFART	LFART	CHAR	4	0	Delivery Type	TVLK
7	KUNNR	☑	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
8	KUNAG	☑	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
9	ERNAM	☑	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
10	VBELN	☑	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
11	POSNR	☑	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
12	ADRNR	☐	ADRNR_WE	ADRNR	CHAR	10	0	Address number of the ship-to party	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VLPMA	KUNAG	KNA1	KUNNR	KEY	1	CN
2	VLPMA	KUNNR	KNA1	KUNNR	KEY	1	CN
3	VLPMA	LFART	TVLK	LFART	KEY	1	CN
4	VLPMA	MATNR	MARA	MATNR	KEY	1	CN
5	VLPMA	POSNR	VBUP	POSNR	KEY	1	CN
6	VLPMA	VKORG	TVKO	VKORG	KEY	1	CN
7	VLPMA	VSTEL	TVST	VSTEL	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in