SAP WRF_APC_IBID Purchasing List Inbound Interface Detailed Totals Table

Overview

WRF_APC_IBID is a standard SAP S/4HANA table that stores Purchasing List Inbound Interface Detailed Totals data. There are total 19 fields in the WRF_APC_IBID table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table WRF_APC_IBID 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_IBID to other SAP tables and standard CDS views available based on WRF_APC_IBID table in S/4HANA 2020.

Techincal Settings of WRF_APC_IBID

Below are technical details of the table WRF_APC_IBID

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

List of WRF_APC_IBID Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
HIER_IDHierarchyWRF_HIER_CNTWRF_MATGRP_HIERCHAR2
NODEHierarchy NodeWRF_STRUC_NODE2WRF_MATGRP_STRUCCHAR18
SAISOSeason CategorySAISOT6WSPCHAR4
SAISJSeason YearSAISJTWSAICHAR4
ROLLOUTRollout in a SeasonSAITYTWSAICHAR2
ASRT_TYPEAssortment TypeWRFDE_ASSORTYPWRFST_TYPCHAR4
SEQ_NOSequence Number For Purchasing ListsWRF_APC_SEQNONUMC2
KEYFIGKey Figure IDWRF_KEYFIGWRFT_APC_KFIGCHAR2
ASORTAssortmentASORTWRS1CHAR10
CNT_STORESNumber of Stores in AssortmentWRF_CNT_STORESINT410
DIFF_ARTNumber of Different MaterialsWRF_DIFF_ARTINT410
QUAN_PREVTarget Purchasing / Total Quantity in UnitsWRF_QTY_PREVQUAN10
COST_BASICTarget Purchasing / Cost Value (Basic Purchase Price)WRF_COST_BASICCURR19
COST_NETTarget Purchasing / Cost Value (Net/Net)WRF_COST_NETCURR19
RETAILTarget Purchasing / Retail Value without TaxWRF_RETAILCURR19
RETAIL_TAXTarget Purchasing / Retail Value Including TaxWRF_RETAIL_TAXCURR19
WAERSCurrency KeyWAERS*CUKY5
UNITUnitUNITUNIT3

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_IBID

Table NameFieldCardinalityCheck Table
WRF_APC_IBIDASORT:WRS1
WRF_APC_IBIDASRT_TYPE:WRFST_TYP
WRF_APC_IBIDHIER_ID:WRF_MATGRP_HIER
WRF_APC_IBIDKEYFIG:WRFT_APC_KFIG
WRF_APC_IBIDMANDT:T000
WRF_APC_IBIDNODE:WRF_MATGRP_STRUC
WRF_APC_IBIDROLLOUT:TWSAI
WRF_APC_IBIDSAISJ:TWSAI
WRF_APC_IBIDSAISO:T6WSP

Other References