SAP AULW Delivery Phases Table
Overview
AULW is a standard SAP S/4HANA table that stores Delivery Phases data. There are total 36 fields in the AULW table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AULW belongs to Allocation (LO-RFM-PUR-AL) module and is located in the package Application development R/3 Purchasing, Allocation table (WAUF).
In addition, following links provide an overview of foreign key relationships, if any, that link AULW to other SAP tables and standard CDS views available based on AULW table in S/4HANA 2020.
Techincal Settings of AULW
Below are technical details of the table AULW
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AULW Fields
The following table gives you an overview of the fields available in AULW
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| ABELN | Allocation Table | ABELN | AUKO | CHAR | 10 |
| ABELP | Allocation Table Item | ABELP | AUPO | NUMC | 5 |
| ABELG | Store Group of an Allocation Table | ABELG | * | NUMC | 5 |
| ABELF | Identifier of a Recipient of an Item of an Allocation Table | ABELF | * | NUMC | 5 |
| LWNUM | Serial number | LFNR3 | NUMC | 3 | |
| WEDAT | Delivery date | LFDAT | DATS | 8 | |
| WETYP | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | |
| WEUZT | Delivery Date Time-Spot | LZEIT | TIMS | 6 | |
| WEPRZ | Delivery phase in percent of total qty | LWPRZ | NUMC | 3 | |
| MENGE | Quantity | MENGE_D | QUAN | 13 | |
| AUFME | Allocation Unit | AUFME | T006 | UNIT | 3 |
| WEMNG | Quantity of goods received | WEEMG | QUAN | 13 | |
| MBLNR | Number of Material Document | MBLNR | CHAR | 10 | |
| MBLPO | Item in Material Document | MBLPO | NUMC | 4 | |
| LFMNG | GR qty assigned after alloc tbl adjustment made | EFMNG | QUAN | 13 | |
| VRKME | Sales unit | VRKME | T006 | UNIT | 3 |
| LEDAT | Delivery Creation Date | LEDAT | DATS | 8 | |
| VBLNU | Generated delivery number | VBLNU | * | CHAR | 10 |
| VBLPU | Generated delivery note item | VBLPU | * | NUMC | 6 |
| BEDAT | Order date/ latest date for generating follow-on documents | SPBEDAT | DATS | 8 | |
| BSTMG | Purchase Order Quantity | BSTMG | QUAN | 13 | |
| BSTME | Purchase Order Unit of Measure | BSTME | T006 | UNIT | 3 |
| EBLNU | Purchase Order Generated for Supplier | EBLNU | * | CHAR | 10 |
| EBLPU | Generated purchase order item | EBLPU | * | NUMC | 5 |
| UMDAT | Purchase Order Date | BEDAT | DATS | 8 | |
| UMLMG | Purchase Order Quantity | BSTMG | QUAN | 13 | |
| UMLME | Purchase Order Unit of Measure | BSTME | T006 | UNIT | 3 |
| UBSTN | Generated warehouse order | UBSTN | * | CHAR | 10 |
| UBSTP | Generated stock transport order item | UBSTP | * | NUMC | 5 |
| ELIKZ | Delivery Completed Indicator | ELIKZ | CHAR | 1 | |
| IMNGL | Confirmed quantity in delivery phase | IMNGL | QUAN | 13 | |
| WMNGE | Quantity requested by store | WMNGE | QUAN | 13 | |
| VBELN_GKA | Number of generated sales order | VBELN_GKA | * | CHAR | 10 |
| VBELP_GKA | Number of generated sales order item | VBELP_GKA | * | NUMC | 6 |
| WRF_AT_DL_ID | Dateline ID (GUID) | WRF_AT_DL_ID | CHAR | 22 |
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 AULW
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AULW | ABELN | 1: CN | AUKO |
| AULW | ABELP | 1: CN | AUPO |
| AULW | AUFME | 1: CN | T006 |
| AULW | BSTME | 1: CN | T006 |
| AULW | MANDT | 1: N | T000 |
| AULW | UMLME | 1: CN | T006 |
| AULW | VRKME | 1: CN | T006 |