SAP WFIL_ADD_ADR Additional Address of a Plant Table
Overview
WFIL_ADD_ADR is a standard SAP S/4HANA table that stores Additional Address of a Plant data. There are total 6 fields in the WFIL_ADD_ADR table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WFIL_ADD_ADR belongs to Sites (LO-RFM-MD-SIT) module and is located in the package IS-R: Store master (WFIL).
In addition, following links provide an overview of foreign key relationships, if any, that link WFIL_ADD_ADR to other SAP tables and standard CDS views available based on WFIL_ADD_ADR table in S/4HANA 2020.
Techincal Settings of WFIL_ADD_ADR
Below are technical details of the table WFIL_ADD_ADR
- Buffering switched on
- Full buffering as specified by generic key
- Storage type is Column Store
List of WFIL_ADD_ADR Fields
The following table gives you an overview of the fields available in WFIL_ADD_ADR
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| LFDNR | Count parameters | NUMC4 | NUMC | 4 | |
| ADDRNUMBER | Address Number | AD_ADDRNUM | ADRC | CHAR | 10 |
| LONGITUDE | Geo location longitude | GEOLON | DEC | 15 | |
| LATITUDE | Geo location latitude | GEOLAT | DEC | 15 |
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 WFIL_ADD_ADR
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WFIL_ADD_ADR | ADDRNUMBER | 1: C | ADRC |
| WFIL_ADD_ADR | MANDT | C: 1 | T000 |
| WFIL_ADD_ADR | WERKS | C: 1 | T001W |