SAP WRPL Replenishment: quantities per customer/material Table
Overview
WRPL is a standard SAP S/4HANA table that stores Replenishment: quantities per customer/material data. There are total 57 fields in the WRPL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRPL belongs to Forecasting Procedures (LO-RFM-PUR-FC) module and is located in the package Retail: Replenishment (WRPL).
In addition, following links provide an overview of foreign key relationships, if any, that link WRPL to other SAP tables and standard CDS views available based on WRPL table in S/4HANA 2020.
Techincal Settings of WRPL
Below are technical details of the table WRPL
- Buffering allowed but switched off
- Full buffering as specified by generic key
- Storage type is Column Store
List of WRPL Fields
The following table gives you an overview of the fields available in WRPL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| KUNNR | Recipient | WRKUNNR | KNA1 | CHAR | 10 |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| STOCK | - obsolete - | WRQUAN_OLD | QUAN | 13 | |
| SOBST | Target stock at recipient | WRSOBST | QUAN | 13 | |
| MABST | - obsolete - | WRQUAN_OLD | QUAN | 13 | |
| MINBE | Reorder point | WRMINBE | QUAN | 13 | |
| EISBE | Safety Stock | EISBE | QUAN | 13 | |
| MEINS | - obsolete - | WRUNIT_OLD | * | UNIT | 3 |
| PERAN | - obsolete - | WRDEC3_OLD | DEC | 3 | |
| ANZPR | - obsolete - | WRDEC3_OLD | DEC | 3 | |
| PRMOD | - obsolete - | WRCHR1_OLD | CHAR | 1 | |
| CHNGE | - obsolete - | WRCHR1_OLD | CHAR | 1 | |
| EXFLG | - obsolete - | WRCHR1_OLD | CHAR | 1 | |
| NIMGT | Use Replenishment-Based Inventory Management | WRNIMGT | CHAR | 1 | |
| NGRCT | Correct replenishment stock against document quantity | WRNGRCT | CHAR | 1 | |
| DISMM | MRP Type | DISMM | T438A | CHAR | 2 |
| PRWUG | Minimum target stock | WRPRWUG | QUAN | 13 | |
| PRWOG | Maximum target stock | WRPRWOG | QUAN | 13 | |
| TRCOV | Target range of coverage | WRANZPR | DEC | 3 | |
| SRP_MATKL | Material Group | MATKL | * | CHAR | 9 |
| SRP_BFLME | Generic Material with Logistical Variants | BFLME | CHAR | 1 | |
| SRP_PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | |
| SRP_WEBAZ | Goods receipt processing time in days | WEBAZ | DEC | 3 | |
| SRP_LFRHY | Planning cycle | LFRHY | * | CHAR | 3 |
| SRP_PERKZ | Period Indicator | PERKZ | CHAR | 1 | |
| SRP_PERIV | Fiscal Year Variant | PERIV | * | CHAR | 2 |
| SRP_WERKS | Plant | WERKS_D | * | CHAR | 4 |
| SRP_RESWK | Supplying (issuing) plant in case of stock transport order | RESWK | * | CHAR | 4 |
| SRP_LIFNR | Account Number of Vendor or Creditor | LIFNR | * | CHAR | 10 |
| SRP_MDREL | Flag: Relevance of Merchandise Distribution in RESWK | WSRP_DC_MDREL | CHAR | 1 | |
| SRP_EKORG | Purchasing organization | EKORG | * | CHAR | 4 |
| SRP_WBTYP | Default doc. category store order inbound - replenishment | VWWSBTYPVO | CHAR | 1 | |
| SRP_ATPFLG | Run ATP Check | WSRP_ATPFLG | CHAR | 1 | |
| SRP_RLTFLG | Include Replenishment Lead-Time in ATP Check | WSRP_RLTFLG | CHAR | 1 | |
| SRP_DYNTS | Calculate Target Stock Dynamically | WSRP_DYNTS | CHAR | 1 | |
| SRP_BZTEK | Processing time required by purchasing department | BZTEK | NUMC | 2 | |
| SRP_MENGU | Quantity Updating in Material Master Record | MENGU | CHAR | 1 | |
| SRP_HEAD | Material Number | MATNR | * | CHAR | 40 |
| SRP_IMFLG | Store Replenishment: MM-Based Inventory Management Active | WSRP_IMFLG | CHAR | 1 | |
| SRP_WBZFLG | Include Default Replenishment Lead-Time | WSRP_WBZFLG | CHAR | 1 | |
| SRP_VKORG | Sales Organization | VKORG | * | CHAR | 4 |
| SRP_VTWEG | Distribution Channel | VTWEG | * | CHAR | 2 |
| SRP_SPART | Division | SPART | * | CHAR | 2 |
| SRP_INFLS | Read Customer Material | INFLS | CHAR | 1 | |
| SRP_DEFQTUNIT | Default Unit of Measure | WSRP_DEFQTUNIT | * | UNIT | 3 |
| SRP_VENUNITGR | Vendor Unit of Measure Group | WSRP_VENUNITGR | CHAR | 4 | |
| SRP_BUYUNITGR | Recipient Unit of Measure Group | WSRP_BUYUNITGR | CHAR | 4 | |
| SRP_RDPRF | Rounding Profile | RDPRF | * | CHAR | 4 |
| SRP_MAXQT | Maximum quantity | MDR1MAXQT | DEC | 30 | |
| SRP_MINQT | Minimum quantity | MDR1MINQT | DEC | 30 | |
| SRP_MAMIQTUNIT | Unit of Measure for Minimum and Maximum Quantity | WSRP_MAMIQTUNIT | * | UNIT | 3 |
| SRP_VABME | Variable Purchase Order Unit Active | VABME | CHAR | 1 | |
| SRP_BSTRF | Rounding value for purchase order quantity | BSTRF | QUAN | 13 | |
| SRP_VAVME | Variable Sales Unit Not Allowed | VAVME | CHAR | 1 | |
| SRP_SCHME | Unit of Measure for Increment | WSRP_SCHME | * | UNIT | 3 |
| SRP_PSTYP | Item category in purchasing document | PSTYP | * | CHAR | 1 |
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 WRPL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRPL | DISMM | 1: CN | T438A |
| WRPL | KUNNR | 1: CN | KNA1 |
| WRPL | MANDT | 1: CN | T000 |
| WRPL | MATNR | 1: CN | MARA |