SAP WRF_POTB_DB1 Worklist OTB Procurement Table
Overview
WRF_POTB_DB1 is a standard SAP S/4HANA table that stores Worklist OTB Procurement data. There are total 14 fields in the WRF_POTB_DB1 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRF_POTB_DB1 belongs to Orders and Contracts (LO-RFM-PUR-POF) module and is located in the package Seasonal Procurement: DDIC Objects in Open-To-Buy Area (WRF_PRC_OTB_DDIC).
In addition, following links provide an overview of foreign key relationships, if any, that link WRF_POTB_DB1 to other SAP tables and standard CDS views available based on WRF_POTB_DB1 table in S/4HANA 2020.
Techincal Settings of WRF_POTB_DB1
Below are technical details of the table WRF_POTB_DB1
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WRF_POTB_DB1 Fields
The following table gives you an overview of the fields available in WRF_POTB_DB1
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| EBELN | Purchasing Document Number | EBELN | * | CHAR | 10 |
| BSTYP | Purchasing Document Category | BSTYP | CHAR | 1 | |
| POHF_TYPE | Document for Seasonal Purchase Order Processing | WRF_POHF_TYPE | CHAR | 1 | |
| SPR_STATUS | OTB Special Release Status | WRF_POTB_SPR_STATUS | CHAR | 2 | |
| RSN_PROFILE | Reason Profile for OTB Special Release | WRF_POTB_SPR_RSN_PROFILE | CHAR | 4 | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | * | CHAR | 10 |
| EKORG | Purchasing organization | EKORG | * | CHAR | 4 |
| EKGRP | Purchasing Group | EKGRP | * | CHAR | 3 |
| BSART | Order Type (Purchasing) | BSART | * | CHAR | 4 |
| SUBMI | Collective Number | SUBMI | CHAR | 10 | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| UNAME | User Name in User Master Record | XUBNAME | * | CHAR | 12 |
| PROGRAMM | ABAP Program Name | PROGRAMM | * | CHAR | 40 |
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 WRF_POTB_DB1