The FRETB table in SAP ERP or S/4HANA stores Reference Table for Multiple Procurement data. There are total 11 fields in FRETB table. The Reference Table for Multiple Procurement table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FRETB table. It is in ISR: Cross-Docking and Floor-Ready Merchandise (WFRM) ABAP package and is part of the Merchandise Distribution (LO-RFM-MDS) module.
SAP FRETB Table Fields
Following is the list of fields that are available in SAP FRETB table. The primary key fields of the table are MANDT (Client), BTYPB (Procurement document category), BLNRB (Document number, procurement), BPOSB (Document item, procurement), BTYPR (Procurement document category), BLNRR (Document number, procurement), BPOSR (Document item, procurement).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| BTYPB | Procurement document category | BTYPB | CHAR (1) | |
| BLNRB | Document number, procurement | BLNRB | CHAR (10) | |
| BPOSB | Document item, procurement | BPOSB | * | NUMC (6) |
| BTYPR | Procurement document category | BTYPB | CHAR (1) | |
| BLNRR | Document number, procurement | BLNRB | CHAR (10) | |
| BPOSR | Document item, procurement | BPOSB | * | NUMC (6) |
| PMENB | Planned quantity for procurement | PMENB | QUAN (13) | |
| PEINB | Unit of measure, planned quantity for procurement | PEINB | T006 | UNIT (3) |
| STSVE | General status | STSVE | CHAR (1) | |
| ERFDT | Created on | ERFDA | DATS (8) |
