SAP Best Practices SAP RDS for HANA 1.

0 – Quick Guide

3.3 ERP Configuration for Replication

Use
Before you start the data replication, please check and confirm following notes are applied in your ECC
system. Please ensure table FAGL_ORG_INFO has been filled with data.

SAP Note Number: 1590496

3.4 SLT Configuration

It’s prerequisite and not the part of RDS. The trigger based replication can be activated and
monitored with the Synchronization Monitor. Make sure you have installed the SLT component
before proceeding with the following sections. All necessary steps are described at SAP HANA 1.0
Installation Guide - Trigger-based Replication and http://help.sap.com/hana/.

In case you want to know more about SLT Configuration. Please follow SAP Landscape Transformation
for SAP HANA (HA1), which is Building Block Configuration Guide available in content library for detailed
instruction.

3.5 Initial Load and Replication

The Initial load and replication of ERP Tables is very important for the SAP HANA operational reporting
rapid-deployment solution. After reading the Solution Scope and Configuration Guide documents, you can
identify the tables which must be loaded and replicated from ERP. Depending on the size of the data that
is being loaded to HANA server, the initial load process can take some time to complete. Please also use
the documentation at https://websmp204.sap-ag.de/~sapidb/011000358700000604912011.

3.5.1 Initial Load and Replication of ECC Tables

Prerequisite
1. The SLT configuration has been setup successfully. Make sure DD02L and DD02T tables are
created and data is replicated completely.

Procedure
1. Choose StartAll ProgramsSAP HANA SAP HANA Studio to open your SAP HANA studio.
2. In the Quick Launch view, choose Select System and choose the correct HANA server.
3. From the Quick Launch tab page, choose Data Provisioning.
4. In the Data Provisioning Page, choose the correct source system.
5. Choose button Replicate.
6. In the Load Request dialog, input following values and choose button Add to make it in the selected
section.

Please notice that the replication for big tables may take long time, it’s recommened to load big
tables as last step e.g BSEG, BKPF, FAGLFLEXA
Table Name Description
ADRC Addresses (Business Address Services)

© SAP AG Page 9 of 30
SAP Best Practices SAP RDS for HANA 1.0 – Quick Guide

AFKO Order header data PP orders

AFPO Order item
BKPF Accounting Document Header
Accounting: Secondary Index for Customers (Cleared
BSAD Items)
Accounting: Secondary Index for Vendors (Cleared
BSAK Items)
BSEG Accounting Document Segment
BSID Accounting: Secondary Index for Customers
BSIK Accounting: Secondary Index for Vendors
DD01L Domains
DD03L Table Fields
DD04L Data elements
DD04T R/3 DD: Data element texts
DD06L Pool/cluster structures
DD07L R/3 DD: values for the domains
DD: Texts for Domain Fixed Values (Language-
DD07T Dependent)
EBAN Purchase Requisition
EBKN Purchase Requisition Account Assignment
EINA Purchasing Info Record: General Data
EKBE History per Purchasing Document
EKET Scheduling Agreement Schedule Lines
EKKN Account Assignment in Purchasing Document
EKKO Purchasing Document Header
EKKO_TECH Central Contract: technical attributes
EKPO Purchasing Document Item
FAGLFLEXA General Ledger: Actual Line Items
FAGL_ORG_INFO Neues Hauptbuch: Konfigurationsinformationen
KNA1 General Data in Customer Master
KNB1 Customer Master (Company Code)
LFA1 Vendor Master (General Section)
LFB1 Vendor Master (Company Code)

© SAP AG Page 10 of 30
SAP Best Practices SAP RDS for HANA 1.0 – Quick Guide

LFM1 Vendor master record purchasing organization data

LIKP SD Document: Delivery Header Data
LIPS SD document: Delivery: Item data
MAKT Material Descriptions
MARA General Material Data
MARC Plant Data for Material
MARD Storage Location Data for Material
MBEW Material Valuation
MCHB Batch Stocks
MKPF Header: Material Document
MSEG Document Segment: Material
PA0001 HR Master Record: Infotype 0001 (Org. Assignment)
RBKP Document Header: Invoice Receipt
RSEG Document Item: Incoming Invoice
S001 SIS: Customer Statistics
SIS:
S003 SalesOrg/DistCh/Division/District/Customer/Product
SIS: Sales
S006 Rep/SalesOrg/DistCh/Division/Customer/Product
S012 Purchasing
S032 Statistics: Current Stock and Grouping Terms
SKA1 G/L Account Master (Chart of Accounts)
G/L Account Master Record (Chart of Accounts:
SKAT Description)
T000 Clients
T001 Company Codes
T001K Valuation area
T001L Storage Locations
T001W Plants/Branches
T005T Country Names
T005U Taxes: Region Key: Texts
T006 Units of Measurement
T006A Assign Internal to Language-Dependent Unit

© SAP AG Page 11 of 30
SAP Best Practices SAP RDS for HANA 1.0 – Quick Guide

T009 Fiscal Year Variants

T016T Industry Names
T023 Material Groups
T023T Material Group Descriptions
T024 Purchasing Groups
T024D MRP controllers
T024E Purchasing Organizations
T077X Account Group Names (Table T077D)
T077Y Account Group Names (Table T077K)
T134T Material Type Descriptions
T137T Industry Descriptions
T151T Customers: Customer groups: Texts
T156SC Mvt Type: Qty/Value Posting: Customer Table
T156T Movement Type Text
T161 Purchasing Document Types
T161T Texts for Purchasing Document Types
T163 Item Categories in Purchasing Document
T163Y Texts for Item Categories
T171 Customers: Sales Districts
T171T Customers: Sales districts: Texts
T179 Materials: Product Hierarchies
T179T Materials: Product hierarchies: Texts
T188T Conditions: Groups for Customer Classes: Texts
T6WSAT Texts for seasonal material categories
T6WST Texts to describe season indicators
T880 Global Company Data (for KONS Ledger)
T881 Ledger Master
T881T FI-SL Ledger text
TBRCT Industry code text (customer master)
TBSL Posting Key
TCURC Currency Codes
TCURF Conversion Factors

© SAP AG Page 12 of 30
SAP Best Practices SAP RDS for HANA 1.0 – Quick Guide

TCURN Quotations
TCURR Exchange Rates
TCURT Currency Code Names
TCURV Exchange rate types for currency translation
TCURX Decimal Places in Currencies
TGSB Business Areas
TGSBT Business Area Names
TKUKT Customers: Customer classification: Texts
TNLST Description of Nielsen Indicators
TNTPB Descriptions of EAN Categories
TSAD3T Titles (Texts) (Business Address Services)
TSPA Organizational Unit: Sales Divisions
TSPAT Organizational Unit: Sales Divisions: Texts
TVBUR Organizational Unit: Sales Offices
TVGRT Organizational Unit: Sales Groups: Texts
TVKBT Organizational Unit: Sales Offices: Texts
Org.Unit: Sales Office: Assignment to Organizational
TVKBZ Unit
TVKGR Organizational Unit: Sales Groups
TVKO Organizational Unit: Sales Organizations
TVKOT Organizational Unit: Sales Organizations: Texts
TVLS Deliveries: Blocking Reasons/Criteria
TVLST Deliveries: Blocking Reasons/Scope: Texts
TVST Organizational Unit: Shipping Points
TVSTT Organizational Unit: Shipping Points: Texts
TVTW Organizational Unit: Distribution Channels
TVTWT Organizational Unit: Distribution Channels: Texts
VBAK Sales Document: Header Data
VBAP Sales Document: Item Data
VBEP Sales Document: Schedule Line Data
VBKD Sales Document: Business Data
VBRK Billing Document: Header Data

© SAP AG Page 13 of 30
SAP Best Practices SAP RDS for HANA 1.0 – Quick Guide

VBRP Billing Document: Item Data

Sales Document: Header Status and Administrative
VBUK Data
VBUP Sales Document: Item Status
TCKH1 Cost Components - Texts
TCKH3 Cost Components
CKMLMV001 Procurement alternatives
CKMLMV001T Texts for procurement alternatives
CKMLMV003 Process model: Receipts / mixing strategies
CKMLMV004 Process model: Withdrawals
CKMLPP Material Ledger Period Totals Records Quantity
Material Ledger: Cost Component Split (Header) for
CKMLPRKEKO Prices
Material Ledger: Cost Component Split (Elements) for
CKMLPRKEPH Prices
CKMLHD Material Ledger: Header Record
CKMLKEPH Material Ledger: Cost Component Split (Elements)
CKMLLAHD ML Activity Types: Header Record
CSKS Cost Center Master Data
CSKT Cost Center Texts
CSLA Activity master
CSLT Activity type texts

7. Choose Finish to load all the tables.

3.5.2 SQL script for customization of HANA specific tables

Use
The following script must be entered and started in the SQL Editor – make sure that you use the correct
schema.

Procedure
1. Choose StartAll ProgramsSAP HANASAP HANA Studio to open your SAP HANA studio.
2. From the Quick Launch page, choose SQL Editor.
3. Copy the appended SQL text, please take care to replace the schema with the actual schema that you
created.

© SAP AG Page 14 of 30