SAP WRF_AL_SELECT Update Selection Criterion Table

Overview

WRF_AL_SELECT is a standard SAP S/4HANA table that stores Update Selection Criterion data. There are total 6 fields in the WRF_AL_SELECT table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table WRF_AL_SELECT belongs to Article List (LO-RFM-MD-AL) module and is located in the package Material List (WRF_ARTICLELIST).

In addition, following links provide an overview of foreign key relationships, if any, that link WRF_AL_SELECT to other SAP tables and standard CDS views available based on WRF_AL_SELECT table in S/4HANA 2020.

Techincal Settings of WRF_AL_SELECT

Below are technical details of the table WRF_AL_SELECT

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of WRF_AL_SELECT Fields

The following table gives you an overview of the fields available in WRF_AL_SELECT

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
AL_IDMaterial List IDWRF_ALIDNUMC6
STRUCTUREAL Ref. Structure NameWRF_AL_STRUCTURE*CHAR30
LFDNRSequence NumberWRF_LFDNRNUMC6
SIGNABAP: ID: I/E (include/exclude values)TVARV_SIGNCHAR1
AL_OPTIONOption for ranges tablesOPTIONCHAR2

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_AL_SELECT

Table NameFieldCardinalityCheck Table
WRF_AL_SELECTMANDT:T000

Other References