SAP Table VLPMA
SD Index: Delivery Items by Material
VLPMA (SD Index: Delivery Items by Material) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VLPMA to other SAP tables.
VLPMA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| VSTEL | Shipping Point/Receiving Point | VSTEL | TVST | CHAR | 4 | 0 | ||
| LFDAT | Delivery date | LFDAT | DATS | 8 | 0 | |||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||
| LFART | Delivery Type | LFART | TVLK | CHAR | 4 | 0 | ||
| KUNNR | Ship-to party | KUNWE | KNA1 | CHAR | 10 | 0 | ||
| KUNAG | Sold-to party | KUNAG | KNA1 | CHAR | 10 | 0 | ||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||
| VBELN | Delivery | VBELN_VL | CHAR | 10 | 0 | |||
| POSNR | Delivery Item | POSNR_VL | VBUP | NUMC | 6 | 0 | ||
| ADRNR | Address number of the ship-to party | ADRNR_WE | CHAR | 10 | 0 | |||
VLPMA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| VLPMA | KUNAG | VLPMA | MANDT | KNA1 | General Data in Customer Master | MANDT |
| VLPMA | KUNAG | VLPMA | KUNAG | KNA1 | General Data in Customer Master | KUNNR |
| VLPMA | KUNNR | VLPMA | MANDT | KNA1 | General Data in Customer Master | MANDT |
| VLPMA | KUNNR | VLPMA | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| VLPMA | LFART | VLPMA | MANDT | TVLK | Delivery Types | MANDT |
| VLPMA | LFART | VLPMA | LFART | TVLK | Delivery Types | LFART |
| VLPMA | MATNR | VLPMA | MANDT | MARA | General Material Data | MANDT |
| VLPMA | MATNR | VLPMA | MATNR | MARA | General Material Data | MATNR |
| VLPMA | POSNR | VLPMA | MANDT | VBUP | Sales Document: Item Status | MANDT |
| VLPMA | POSNR | VLPMA | VBELN | VBUP | Sales Document: Item Status | VBELN |
| VLPMA | POSNR | VLPMA | POSNR | VBUP | Sales Document: Item Status | POSNR |
| VLPMA | VKORG | VLPMA | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| VLPMA | VKORG | VLPMA | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| VLPMA | VSTEL | VLPMA | VSTEL | TVST | Organizational Unit: Shipping Points | VSTEL |
| VLPMA | VSTEL | VLPMA | MANDT | TVST | Organizational Unit: Shipping Points | MANDT |
