2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

m
m
Products and Technology Groups Partners Topics Events What's New Get Started
u
ni
t
y
SAP Community  Products and Technology  Technology  Technology Blogs by Members
 Procedure to Load data using Setup Table

Technology Blogs by Members

Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP
products, technology, and events. Get in the mix!

Blog  What are you looking for today?

Procedure to Load data using Setup Table

karthik_vasudevan
Active Contributor

‎2014 Sep 17 8:23 PM

 14 Kudos  75,076

SAP Managed Tags: BW (SAP Business Warehouse)

Procedure to
load data using Setup Table

Summary

The objective of the document is to give information to load data using setup tables
when delta is still enabled. The information below is available in SCN in different forums.
I have tried to collate that and give some more information in my personal experience in
one single document.

Introduction

https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 1/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

Setup tables are nothing but tables which are directly linked to application tables. SAP
doesn’t allow direct access to application tables and hence to extract data from those
tables, we have setup table as an interface between them and the extractor.

Load from setup table is used to initialize delta loads, which means this is always a full
load from the application tables, based on the selection provided while
running setup job. Once the load from setup table is completed, we could normally load
deltas through delta queue.

Business Scenario

We have various scenarios to load historical data to newly developed info-provider or existing info-provider
with few enhancements. In these scenarios, we may need the help of setup tables to load data and this is a
part of LO Extraction scenario.

Business users want a new report based on purchasing which cannot be achieved using a standard info-
cube based on the requirement. Hence we have developed a new Info cube which needs to have data
from 2LIS_02_SCL and 2LIS_02_SCL (which is already delta enabled).

In the above scenario, if the business doesn’t require history data, then there is no challenge since we
could add the new info-cube in the existing delta info-packages.

If the business requires history data, then we need to load history data using setup table and then add the
same info-cube in existing delta loads.

Procedure to fill setup table and load data to BI

We need to keep in mind that the setup table is not filled always. If we have a scenario to
load full/Init, we need to fill the corresponding setup tables by scheduling setup runs
(BGD jobs).

Before proceeding to fill the setup tables, we should make sure that they are empty

Below is the procedure to delete setup tables. The procedure to delete setup table for all
components is same and the deletion is component dependent, not
datasource wise. Hence if we our requirement is to load data from HDR datasource, we
https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 2/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

need to fill the whole component which includes HDR information also.

Transaction code to delete setup table is LBWG

Once we get the above screen, we could specify the component (02, 11, etc...) and click
on execute button.

Once we execute, it would give us the below screen for confirmation. Click ‘Yes’ to
proceed further.

(We are not going to delete any data from application tables. We are deleting the setup
table before filling it up, just to avoid duplicate data)

Once the setup table is deleted, the below message will appear in the bottom of the
screen

Now we are done with the deletion of setup table and we are fine to proceed further to
fill it back

https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 3/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

Deletion activity is very simple with one transaction for all components. But in order to fill
the setup tables, we have the following transaction codes for
individual components.

T-Code Application

OLI1BW Material Movements

OLIZBW Invoice Verification/Revaluation

OLI3Bw Purchasing Documents

OLI4BW Shop Floor Information system

OLIFBW Repetitive Manufacturing

OLIQBW Quality Management

OLIIBW Plant Maintenance

OLISBW Service Management (customer Service)

OLI7BW SD Sales Order

OLI8BW Deliveries

https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 4/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

OLI9BW SD Billing Documents

VIFBW LES-Shipment Cost

VTBW LES-Transport

ORISBW Retail

OLIABW Agency Business

OLI6BW Invoice Verification

OLI4KBW Kanban

We could also achieve the above through the transaction code SBIW in the following
path.

Settings for Application-Specific Data Sources --> Logistics --> Managing Extract
Structures --> Initialization --> Filling in the Setup Table --> Choose the component to fill

https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 5/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

Loading data to BI

Once the required history data is available in setup table, we could start loading it to BI.
Before triggering the info-package, we need to change the settings in info-package to
load it as Repair-Full request.

Below are the steps to convert an info-package with full load to a repair full load

Open the info-package

Menu --> Scheduler --> Click ‘Repair Full Request’ as below

https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 6/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

Below screen will appear in which we need to check the option ‘Indicate Request as
Repair Request’

The purpose of changing the full load to repair-full load is because we wouldn’t be able
to run delta after a full load. Hence the load should be a repair-full
load.

There is also an option to change a full load request into repair full request after loading
using the program ‘RSSM_SET_REPAIR_FULL_FLAG’

Once the full loads are completed, we need to run the above program which will give us
the below screen

https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 7/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

We need to fill the above information and execute. All full requests in the info-provider
will be converted into Repair-Full request. After which, we could do delta loading without
any issues.

Points to remember

The setup table deletion and filling up activity should be preferably done in non-
business hours
Before starting the activities, it is suggested to lock the business users, so that delta
will not be lost
It is not mandatory to stop V3 jobs, since the setup table concept runs entirely a
different path and it will not disturb delta. But still, we should run V3 jobs manually
until and make sure delta loads to BI picks ‘0’ data.
When we run setup table filling jobs, it is always recommended to fill it for selective
regions or periods. We can never predict on how much data is available in
application tables. If we don’t specify any selections, it will take days to complete
the job.

Naming Convention of setup tables

Setup table name will be extract structure name followed by SETUP.

It starts with 'MC' followed by application component '01'/'02' etc. and then last digits of
the Data source name and then followed by SETUP. We can also derive it with the name
of communication structure in LBWE followed by 'SETUP'

Below is the list of setup table names for the application 02 – Purchasing.

With the use of these tables, we could make sure that the data is deleted/ filled after the
corresponding jobs
https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 8/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

Application Datasource Setup Table

Purchasing 2LIS_02_ACC MC02M_0ACCSETUP

Purchasing 2LIS_02_CGR MC02M_0CGRSETUP

Purchasing 2LIS_02_HDR MC02M_0HDRSETUP

Purchasing 2LIS_02_ITM MC02M_0ITMSETUP

Purchasing 2LIS_02_SCL MC02M_0SCLSETUP

Purchasing 2LIS_02_SCN MC02M_0SCNSETUP

Purchasing 2LIS_02_SGR MC02M_0SGRSETUP

Important Transaction Codes

NPRT – Log for Setup Table jobs

LBWG – To delete setup table based on

components

Tags:

Data Warehouse sap bi SAP BW

https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 9/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

7 Comments

Former Member


‎2014 Sep 27 11:09 AM

 0 Kudos

Hi Karthik,

Good Document.... Thanks..

karthik_vasudevan
Active Contributor


‎2014 Sep 27 11:11 AM

 0 Kudos

Thanks Raghunathan :smile: I am glad

Former Member


https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 10/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community
‎2014 Oct 09 4:27 AM

 0 Kudos

Nicely done Karthik! Thanks for referring it.

Former Member


‎2016 Jul 13 6:30 AM

 0 Kudos

Good guide Karthik! Thanks for sharing..

former_member667783
Explorer


‎2020 Mar 25 5:20 AM

 0 Kudos

Do we need to fill repair full request as mandatory ? I have done a separate full load
infopackage without disturbing the existing delta on the datasource in production and
then I was able to load the missing data using a full load and the delta did not get
disturbed. ...so what do you mean by repair full request ? Did it change recently. Please
advise.

Thanks

https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 11/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

FCI
Active Contributor


‎2020 Mar 25 8:31 AM

 0 Kudos

I never had the time to really investigate this but I'm under the impression that this option
(FULL REPAIR) is only useful for 3x data flows (or is it linked to the BW version ?).

I found no trace of this option in the help.sap.com other than in the "scheduler 3x"
chapter.

gokulviswa02
Discoverer


‎2023 Dec 11 6:46 AM

 0 Kudos

Hi folks,

I have one question what is the reason "FI" was not using Setup table.
Thanks in advance!

You must be a registered user to add a comment. If you've already registered,

sign in. Otherwise, register and sign in.

https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 12/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

Comment

Labels In This Area

"as_written_by_Marian_Zeis" 2 "automatische backups" 1 "Best Practices" 1

"Data Source Migration" 1 "Integration Challenges" 2 "regelmäßige sicherung" 1

"SAP BW 7.4" 1 "SAP BW" 5 "SAP VARIANT CONFIGURAITION 2

"SAP_BUILD_APPS" 1 "SAPDatasphere" 3 "TypeScript" "Development" "FeedBack" 1

*SAP" 1 -147 Get CurrentUserInfo failed 1 2YM 1 3-TIER Extensibility 3

30 examples 1 505 Technology Updates​53 1 @expertsap 2 @hanasizing 1

@RetroDate_HireDateCorrection 1 @sapcommunity 1 @sapilm @archiving @sapiq 1

@SAPSupport 2 @SCPI 2

A Comprehensive Guide to Using OLE Objects in SAP ABAP 1 aATP 1 ABAP 45

ABAP 7.4 2 ABAP API 1 ABAP BAPI BAPI_FIXEDASSET_CREATE1 1 ABAP BTP 1

ABAP CDS VIEW 2 ABAP CDS Views 13 ABAP CDS Views - BW Extraction 3

ABAP CDS Views - CDC (Change Data Capture) 3 ABAP Class 3 ABAP Cloud 9

ABAP Cloud Developer Trial 1 ABAP Custom 1 ABAP DDIC CDS view 1

ABAP development 14 ABAP Editor 2 ABAP Enhancement 1

ABAP Environment & RAP 2 ABAP Extensibility 5 ABAP for EWM 1

ABAP in Eclipse 3 ABAP Interface 1 ABAP New Syntax 1 ABAP ODATA 2

ABAP on HANA 1 ABAP OOABAP 1 ABAP PLATFORM 1 ABAP Platform Trial 2

ABAP Programming 8 ABAP Push Channels 1 ABAP Query 1 ABAP RAP 4

ABAP RAP custom action 3 ABAP RAP(RESTful Application Programming) 7

ABAP RESTFul API 1 ABAP RESTful Application Programming Model 2

ABAP String functions 1 abap technical 1 ABAP test cokpit 1 abap to xml 1

abapGit 1 absl 2 Accenture 1

Access data from datasphere to ADF Azure Data Factory 5

access data from SAP Datasphere directly from Snowflake 1

Access data from SAP datasphere to Qliksense 2 Accessibility 1

Accessibility in SAPUI5 1 Accrual 1 Acquire SAC Knowledge 3 acquired 1

https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 13/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

action 1 actions 1 Activity 1 Adaptation Project 1 adapter 2

adapter modules 2 ADDING LEAN SERVICES 2 Addon 2

Adobe Document Services 1 Adobe forms 1 ADS 1 ADS Config 1

ADS with ABAP 1 ADS with Java 1 ADT 4 Advance Shipping and Receiving 1

Advanced ABAP 1 Advanced Event Mesh 4 Advanced formula 1

Advanced Formulas 2 Advanced Metric 1 Advanced SAP Techniques 1

Related Content
Fiori & CAP: getting custom action working
in Technology Q&A yesterday

SAP Datasphere - Replication Flow - Initial - Downtime

in Technology Q&A Friday

Call Hana cloud stored procedure from CAP java application

in Technology Q&A Friday

On-Premises to Cloud SAP S/4HANA Conversion Planning and Execution – Part 1:

Migration Timeline etc.
in Technology Blogs by Members Thursday

How to Switch from GET to POST Call in SAPUI5 Analytical Table with Node.js
Backend?
in Technology Q&A Wednesday

Popular Blog Posts

https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 14/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

SAP PI for Beginners

former_member200339
Participant

 730116  155  388

ABAP 7.40 Quick Reference

jeffrey_towell2
Participant

https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 15/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

 1228820  75  345

Difference between SAP S/4HANA :Public Vs Private edition : RISE with SAP

rajarajeswari_kaliyaperum
Active Participant

 192704  47  313

Top Kudoed Authors

hardyp180  9

saroopreddy88  7

Matthias_BW  7

mike_zaschka  6

https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 16/17
2/10/25, 1:32 PM Procedure to Load data using Setup Table - SAP Community

BjörnS  5

SachinArtani  5

Marian_Zeis  4

Aman07  4

ManabuInoue  4

arunmaarirajha  4

View all

Privacy Terms of Use

Copyright Legal Disclosure

Trademark Support

Cookie Preferences
Follow

https://community.sap.com/t5/technology-blogs-by-members/procedure-to-load-data-using-setup-table/ba-p/13242857 17/17