SAP VLPMA SD Index: Delivery Items by Material Table

Overview

VLPMA is a standard SAP S/4HANA table that stores SD Index: Delivery Items by Material data. There are total 12 fields in the VLPMA table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VLPMA belongs to Shipping (LE-SHP) module and is located in the package WS-SHP: General Processing for Shipping (VL).

In addition, following links provide an overview of foreign key relationships, if any, that link VLPMA to other SAP tables and standard CDS views available based on VLPMA table in S/4HANA 2020.

Techincal Settings of VLPMA

Below are technical details of the table VLPMA

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VLPMA Fields

The following table gives you an overview of the fields available in VLPMA

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTCLNT3
MATNRMaterial NumberMATNRMARACHAR40
VSTELShipping Point / Receiving PointVSTELTVSTCHAR4
LFDATDelivery dateLFDATDATS8
VKORGSales OrganizationVKORGTVKOCHAR4
LFARTDelivery TypeLFARTTVLKCHAR4
KUNNRShip-to partyKUNWEKNA1CHAR10
KUNAGSold-To PartyKUNAGKNA1CHAR10
ERNAMName of Person who Created the ObjectERNAMCHAR12
VBELNDeliveryVBELN_VLCHAR10
POSNRDelivery ItemPOSNR_VLNUMC6
ADRNRAddress number of the ship-to partyADRNR_WECHAR10

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VLPMA

Table NameFieldCardinalityCheck Table
VLPMAKUNAG1: CNKNA1
VLPMAKUNNR1: CNKNA1
VLPMALFART1: CNTVLK
VLPMAMATNR1: CNMARA
VLPMAVKORG1: CNTVKO
VLPMAVSTEL1: CNTVST

Other References