SAP WRF_APC_PABD Planned Article Basic Data Table

Overview

WRF_APC_PABD is a standard SAP S/4HANA table that stores Planned Article Basic Data data. There are total 26 fields in the WRF_APC_PABD table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table WRF_APC_PABD belongs to Orders and Contracts (LO-RFM-PUR-POF) module and is located in the package Operational Assortment Planning and Control (WRF_APC).

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

Techincal Settings of WRF_APC_PABD

Below are technical details of the table WRF_APC_PABD

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

List of WRF_APC_PABD Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
MATNRPlanned Material NumberWRF_PLNART*CHAR40
MTARTMaterial typeMTARTT134CHAR4
MATKLMaterial GroupMATKLT023CHAR9
CHAR_PROFCharacteristic ProfileWRF_CHARPROFCHAR18
ATINN1Internal characteristicATINNCABNNUMC10
ATINN2Internal characteristicATINNCABNNUMC10
ATINN3Internal characteristicATINNCABNNUMC10
APP_IDApplication IDWRF_APPIDWRF_APPL_SETNUMC2
HIER_IDHierarchy IDWRF_HIERIDWRF_HIER_IDCHAR2
NODE_IDNode IDWRF_NODEIDWRF_HIER_NODESNUMC6
ATTYPMaterial CategoryATTYPCHAR2
REF_MATLReference MaterialREF_MATNR*CHAR40
BASE_UOMBase Unit of MeasureMEINST006UNIT3
FPRFMDistribution profile of material in plantFPRFMTMFPFCHAR3
GENMATMaterial Number of the Generic Material in Prepack MaterialsWSTR_SATNR_PP*CHAR40
REL_FLAGPlanned Material: Release FlagWRF_APC_ARTREL_FLAGCHAR1
DEL_FLAGPlanned Material Deletion Flag (OAPC)WRF_APC_ARTDEL_FLAGCHAR1
PRICAT_FLAGPlanned Material Originates from PRICAT (OAPC)WRF_APC_PRICAT_FLAGCHAR1
PRIMVAROperational APC: Master Variant for PRICAT ProcessingWRF_APC_PRIMVAR*CHAR40
PRINBRPRICAT: Unique internal catalog numberPRINBRPRICAT_K001CHAR10
EAN_UPC_BASEPRICAT: EAN/UPC Code of Base Unit of MeasurePRIEANBASISCHAR35
VALIDITY_BASEPrice Catalog Inbound Start of Validity PeriodPRIVALIDITYDATS8
EAN_UPC_TYPEType of material identificationPRIEANTYPCHAR2
PLANONLY_PPIdentify prepacks that have been created for planning onlyWRF_APC_PLANONLY_PPCHAR1
TIMESTAMPTime StampWRF_TIMESTAMPNUMC14

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_APC_PABD

Table NameFieldCardinalityCheck Table
WRF_APC_PABDAPP_ID:WRF_APPL_SET
WRF_APC_PABDATINN1:CABN
WRF_APC_PABDATINN2:CABN
WRF_APC_PABDATINN3:CABN
WRF_APC_PABDBASE_UOM:T006
WRF_APC_PABDFPRFM:TMFPF
WRF_APC_PABDGENMAT1: CN*
WRF_APC_PABDHIER_ID:WRF_HIER_ID
WRF_APC_PABDMANDT:T000
WRF_APC_PABDMATKL:T023
WRF_APC_PABDMTART:T134
WRF_APC_PABDNODE_ID:WRF_HIER_NODES
WRF_APC_PABDPRINBR:PRICAT_K001

Other References