BW tables

(1)

___________________________________________________________________________

201 Interview Questions

Business Information Warehouse Bonus Material

(2)

___________________________________________________________________________ © Genie Press 2006 2 TABLE OF CONTENTS Copyright 3 CHAPTER 1. BW 3.5 4 CHAPTER 2. BW in NetWeaver 2004S (or version 7.*) 6

CHAPTER 3. Business Content

8

Master data 8

0CUSTOMER Display attributes 8 Navigational Attributes for

0CUSTOMER 9

0MATERIAL Display Attributes 9 0Material Navigational Attributes 10 Info Cubes 11

MM Cube 0PUR_C01 – Purchasing Data 11

Reports for 0PUR_C01 12 MM Cube number 2, 0PUR_C02 Vendor Evaluation 12

Queries for 0PUR_C02 13 Info Cube 0SD_C01 (Customer) Example for SD cube 13

Reports for 0SD_C01 14

SD Cube, 0SD_C03, Sales Overview 14

Reports in 0SD_C03 15

Finance Cube 0FIAP_C03, AP Line Item 16

Finance Cube 0FIAP_C02, AP Transaction Data 18

Finance Cube 0FIAR_C03, AR Line Item 18

Reports for 0FIAR_C03 19 Finance Cube 0FIAR_C02, AR Transaction data 19

Report for 0FIAR_C02 19

HR Cube, 0PA_C01, Headcount and Personnel Actions 20

Reports from 0PA_C01 21

HR Cube, Benefits, 0PABN_C01 21 Reports for Benefits cube 23

CO-PA Cube example 0COPA_C03 (Quick start) 23

Reports from the CO-PA (Quick start) cube 24 HR Cubes 25 Tables in R/3 26 SD Tables 26 Other SD Tables 26 MM Tables 27 Purchasing Tables 27 FI Tables 27 CHAPTER 4. BW Transactions 30

CHAPTER 5. Data Sources and

Table/fields 31

GL Data Source 0FI_GL_4 31 AR Data Source 0FI_AR_4 33 AP Data Source 0FI_AP_4 35

HR Data Source 0HR_PA_1 (Personnel Actions) 36

HR Data Source 0HR_PA_BN_1 (Benefits) 37

HR Data Source 0HR_PY_1 (Payroll Data) 37

Material Movements (Stock initialization) 2LIS_03_BX 38 Material Movements from Inventory Management 2LIS_03_BF 38

(3)

___________________________________________________________________________

Copyright

© Genie Press 2006

Microsoft®, WINDOWS®, NT®, EXCEL®, Word®, PowerPoint® are registered trademarks of Microsoft Corporation.

ORACLE® is a registered trademark of the Oracle Corporation.

SAP, SAP Logo, R/2, R/3, mySAP, mySAP.com and other SAP products and services mentioned herein are trademarks or registered trademarks of SAP

(4)

___________________________________________________________________________

CHAPTER 1. BW

3.5

This chapter gives the features of BW 3.5 The features of 3.5 are as follows :-

• Information Broadcasting

• Universal data integration – connectivity to JDBC, XMLA, OLE DB, SAP Query

• SAP Netweaver integration

• BPS (Business Planning and Simulation) now integrated with BW 3.5 • Re-usable patterns (Like using a web template within another

template); example you can use it for header/footer situation. • New web XML items – catalog of web objects and Data provider

information; customers can use javascript to customize depending what is on the cell; the XML item data provider information gives the following data :- access to query and view results, complete

navigational state description, contains both meta data and actual data.

i. The XML data provider contains the following components ii. AXIS_INFO – meta data description

iii. AXIS_DATA – data values iv. CELL_DATA – value cells

v. TXT_SYMBOLS – text elements for the query

• The XML object catalog contains information about template properties, items and their attributes and list of data providers. • Drop down box for data views

• New web item – Information Broadcasting • New chart designer wizard

• Bex Web analyzer

• More display options for master data (long names) • Now you can search hierarchy node variable • APD – Analysis Process Designer

• New variables for currency conversion – with flexible rate types, flexible target currency and flexible point in time.

• Open Hub Service can use logical file names now, • Integration of 3rd

party tools in open hub

• Formula builder performance increase – compiled instead of interpreting

• BW connect to other clients (like APO) within the same system • Supports fully Unicode enabled BW server

(5)

___________________________________________________________________________

• Enhanced display options for displaying characteristics (like key and name (short,long,medium)).

Information Broadcasting Features

• Distribute information by email or portal

• Supports different formats HTML, MHTML, Bex workbook, Zip files • Supports different sources :- BI Applications, Workbooks, queries • Can do it in different modes like precalculated, online

• Ability to execute on events (example new data loaded to the info provider) • Wizard support for adhoc scheduling

• Use of KM services for :- subscription, feedback, discussion, collaboration, rating, search, download, notes.

(6)

___________________________________________________________________________

**CHAPTER 2. BW in NetWeaver 2004S (or version 7.*)**

This chapter gives the features of BW 7.*

• Integration of transactional and analytical content • High performance architecture

• Data warehousing work bench instead of AWB for improved usability, display complete data flow, etc

• ODS is now called Enhanced Data store objects; improved performance and flexibility. New feature for write optimized data store (no change log and no activation required) eliminating the step for activation.

• Infosets new features includes support of Info cubes.

• Re modeling tool box; allows you change info cubes without rebuilding from scratch

• New tool content analyzer – analyze BI content objects

• Support of new data sources like web service (XML), UD connect • Remote master data access (no need to extract master data to BW) • GUI based transformation utility. Unification of transfer and update rules • New user modifiable “End Routine” like start routine.

• Unit conversion possible when loading data or reporting • Real time data acquisition

• Performance improvement by using BI Acclerator.

• Process chain enhancements like copy, display only mode, using user id for background process; new process type called “decision”

• Pro active monitoring : time lines and comparisons, drill down views (all based on new technical content info cubes)

• More query performance statistics : additional information in technical content, recording of parallel processes, multi provider information • Enhanced data load statistics, new data load status

• Better error handling – use of error stack to fix and reload errors. • New BI Accelerator – use of Trex engine and new hardware box. • Re-partitioning possible without deleting data

• Support of near in line storage

• New authorization techniques; new analysis authorization replaces old authorization object. Authorization as union and not intersection, high flexibility, special dimensions for authorizations

• .NET based query designer, enhanced application menus, multi selection of objects,

• New Report designer for formatted reporting • Support of Visual Composer

• WAD is now based of .Net

(7)

___________________________________________________________________________

• Bex Analyzer – direct access to info providers, new layout (workbook), Unicode support, application building in excel, use of excel formulas, excel options

• Bex analyzer design tool bar – contains grid analysis, navigation pane, work book settings, etc.

• Standard Bex formats replaced by excel formats • Drag and drop operations

• New broadcasting features – formatted reports, query views, distribution by data burst (recipients from BW Master data), exception broadcasting, PDF output, broadcast to printer.

• Access to UWL (Universal work list) from role. • Document integration – document browser,

(8)

___________________________________________________________________________

CHAPTER 3. Business

Content

The following section describe the samples from business content; each area has one or more cubes described; as a functional consultant you should be thorough with what SAP offers and what the customer wants (gap analysis); once you find the gap, find out how best you can get the additional data in to BW.

Master data

In many installations, as functional person you might be asked to find what SAP delivers and what the customer needs and do a gap analysis; it is very typical that you enhance 0CUSTOMER, 0MATERIAL and 0VENDOR. The following pages describe what master data attributes are.

0CUSTOMER Display attributes

Name Technical name

Address 0ADDR_NUMBR

AFS SAP Number for Customer-DC 0AF_CUSTDC AFS Customer Identification in Partner

System

0AF_CUSTID

Height of geo-location 0ALTITUDE

Location 0CITY

Fiscal year variant 0FISCVARNT

Industry code 1 0IND_CODE_1

Industry Code 2 0IND_CODE_2

Latitude of the Geo-Location 0LATITUDE

Source System 0LOGSYS

Longitude of the Geo-Location 0LONGITUDE

Name 1 0NAME

Name 2 0NAME2

Name 3 0NAME3

Partner company number 0PCOMPANY

First telephone number 0PHONE

Plant 0PLANT

P.O. Box 0POBOX

CAM: PO Box Postal Code 0POSTCD_BOX

CAM: Postal Code (Geo-Relevant) 0POSTCD_GIS

Geo-location precision 0PRECISID

Data source ID of Geo-location 0SRCID

(9)

___________________________________________________________________________

Tax number 1 0TAX_NUMB

Usage indicator for material 0USAGE_IND

Navigational Attributes for 0CUSTOMER

Customer account group 0ACCNT_GRP

Business Partner 0BPARTNER

Country key 0COUNTRY

Customer Classification 0CUST_CLASS

Customer Market 0CUST_MKT

Customer is consumer 0CUS_F_CONS

D-U-N-S Number 0DBDUNS_NUM

Industry key 0INDUSTRY

Key Account 0KEYACCOUNT

Nielsen ID 0NIELSEN_ID

Branch Category 0OUTL_TYPE

Postal Code 0POSTAL_CD

Region (State, Province, County) 0REGION Predefined Call Frequency 0VISIT_RYT

0MATERIAL Display Attributes

AFS Elementary Field "Color"

0AF_COLOR

AFS Fabric Content Code 0AF_FCOCO

AFS Target Group 0AF_GENDER

AFS Grid 0AF_GRID

AFS Intersection 0AF_STYLE

APO Product 0APO_PROD

Base Unit of Measure 0BASE_UOM

Basic material (basic constituent of a material)

0BASIC_MATL

Product 0BBP_PROD

Content unit 0CONT_UNIT

Date on which the record was created 0CREATEDON European Article Numbers/Universal Product

Code

0EANUPC

Gross contents 0GROSS_CONT

Gross weight 0GROSS_WT

Source System 0LOGSYS

Manufacturer 0MANUFACTOR

(10)

___________________________________________________________________________

Usage 0MSA_USAGE

Net contents 0NET_CONT

Net weight of item 0NET_WEIGHT

Order unit 0PO_UNIT

Size/dimension 0SIZE_DIM

Unit of dimension for length/width/height 0UNIT_DIM

Weight unit 0UNIT_OF_WT

Volume 0VOLUME

Volume unit 0VOLUMEUNIT

0Material Navigational Attributes

Competitors 0COMPETITOR

Product 0CRM_PROD

Division 0DIVISION

External material group 0EXTMATLGRP

Active Ingredient 1 (Main Active Ingredient) 0HC_AGENT1

Active Ingredient 2 0HC_AGENT2

Active Ingredient 3 0HC_AGENT3

Anesthetic Indicator 0HC_ANESIND

Approval Type 0HC_APPRTYP

ATC Code 0HC_ATCCODE

Type of Med. Category for ATC Code 0HC_ATCMTYP

Catalog 1 Indicator 0HC_CATIND1

Hazardous Substance Indicator 0HC_HAZMIND

Import Material Indicator 0HC_IMPMIND

Industry sector 0IND_SECTOR

Material category 0MATL_CAT

Material group 0MATL_GROUP

Material type 0MATL_TYPE

Product hierarchy 0PROD_HIER

Cross-Plant Configur. Material 0RT_CONFMAT

Price Band Category 0RT_PRBAND

Procurement Rule 0RT_PRRULE

Season Category 0RT_SEASON

Season Year 0RT_SEAYR

Source of Supply 0RT_SUPS

Industry Standard Description (such as DIN) 0STD_DESCR Type of Certification Requirement 0UCCERTIFTY

Construction Class 0UCCONSTCLA

(11)

___________________________________________________________________________

Info Cubes

MM Cube 0PUR_C01 – Purchasing Data

Characteristics Key Figures

Country key Actual goods receipt quantity D-U-N-S Number Delivery Date Variance 1

Division Delivery Date Variance 2

Flag for Contracts Delivery Date Variance 3 Indicator: Data to Be Canceled Delivery Date Variance 4 Industry Sector Delivery Date Variance 5 Industry sector Delivery quantity variance 1 Material Delivery quantity variance 2 Material Group Delivery quantity variance 3 Material Type Delivery quantity variance 4 Material group Delivery quantity variance 5 Number of purchasing info

record

Effective order value of returns

Plant Effective purchase order value

Postal code GR value: Returns as at posting date Purchasing info record category Goods receipt qty in base unit (calculate

wtd.delivery time)

Purchasing organization Goods receipt quantity of returns Region Goods receipt value as at posting date Value Type for Reporting IR quantity: Returns as at posting date Vendor IR value: Returns as at posting date Version Invoice Amount as at Posting Date

Invoice Receipt Quantity as at Posting Date

Invoice amount: Returns Invoice receipt quantity

Invoice receipt quantity of returns Invoiced amount

Number of contract items Number of deliveries

Number of purchase order items

Number of purchase order schedule lines

Number of quotation items

Number of request for quotation items

Number of scheduling agreement items

Number of scheduling agreement

schedule lines Order quantity

(12)

___________________________________________________________________________

Target delivery quantity Total delivery time in days

Value of goods received in local currency Weighted total delivery time

Reports for 0PUR_C01

Vendor by DUNS Number

D&B Billing Documents per Creditor (1) Variances, invoice

Non-Contract Orders

D&B Dublicate vendors to one Duns Number D&B Invoices per Creditor (4)

Order values

Average delivery time - vendors Quantities: PO - delivery - invoice Delivery Date Variances

Ordering activities

Average delivery time - material Purchase order quantities Vendor service level

Vendor comparison (purchasing values) Price trends over last three months Delivery Quantity Variances

DUNS Family Tree

Purchase Order Value by Vendor Over Time Country comparison - raw materials - GR value Fulfillment rate - deliveries

Values: Purchase order - delivery - invoice Variances, goods receipt

Extractionquery to create Vendor-Exportfile for D&B

Number of Vendors per Material

D&B Invoiced Amount per Vendor with Family Tree

Overall and Mean Purchase Order Value

MM Cube number 2, 0PUR_C02 Vendor Evaluation

Characteristics Key figures

Business partner Points score 1 for compliance with shipping instructions

Indicator: Data to Be Canceled

Points score 1 for on-time delivery performance

(13)

___________________________________________________________________________

Material Points score 1 for quality audit Number of purchasing info

record

Points score 1 for quantity reliability Plant Points score 1 for timeliness of service

provision Purchasing info record

HR Cubes

Info Area Comments Cubes Delta?

PA Personnel Administration

PA and OS get data from info type 1

Use PERNR to schedule multiple info packages

Head count and personnel action (head count is

calculated at the end of the month) N Organizational Management (PA-OS) Staffing Assignments N Personnel Recruitment (PA-RC) Applications and Applications Actions N Personnel Development (PA-PD)

Data from info types 1000, 1001, 1033, 1045 Qualifications Appraisals N Benefit (PA-BN)

Data from info types 0167, 0168, 0169, 0170, 0236, 0377, 0379 Benefits N Compensation Management (PA-CM)

Data from cluster table PCL5 and T77KD table, info types 08,14,15 and 380. • compensation analysis • adjustments • Awards granted • Security data for awards N Training and event management

Data from info types 1000, 1001, 1021, 1023, 1024, 1036, PAD23, 25 and 34 • Training and event management • Professional training N Payroll Accounting PY

The primary source is the Result Table (RT Cluster table), workplace basic pay (WPBP) and FI/CO posting by wage type. Customization is complicated. • Payroll Accounting Y Time Management (PT)

Source for this is Infotype 1, 27, 2001-7 and PCL-BC2 cluster.

• Time and labor Y Cross

Applications Time sheets

(26)

___________________________________________________________________________

Tables in R/3

SD Tables

Area Table Name Description

Sales Order document VBBE Sales requirement

VBLB Release order data

VBAK Sales doc header

VBAP Sales doc item VEPVG Delivery due index

VBEP Sales doc scheduled lines

VBPA Partner table

VBKD Sales doc, business data Shipping delivery

information

VBLK SD delivery note header VEPO SD Doc shipping item

content

VEKP SD Doc, shipping unit header

LIKP Sales doc, delivery header

VTTP Shipment item

VTTK Shipment header

LIPS Sales doc, delivery items

Billing Document VBRK Billing header

VBRP Billing item

Other SD Tables

Table Table Name

KONV Conditions for Transaction Data KONP Conditions for Items

VBEH Schedule line history

VBEP Sales Document: Schedule Line Data VBFA Sales Document Flow

VBPA Sales Document: Partner

VBUK Sales Document: Header Status and Administrative Data

(27)

___________________________________________________________________________

MM Tables

Area Table Description

Basic data MARA Material master

MAKT Material descriptions

MARM Units of measure Purchasing

data

MARC Material master, C segment

MLAN Tax classifications,

material Accounting

data

MBEW Material valuation

Purchasing Tables

Table Table Description

EBAN Purchase Requisition

EBKN Purchase Requisition Account Assignment EKAB Release Documentation

EKBE History per Purchasing Document EKET Scheduling Agreement Schedule Lines EKKN Account Assignment in Purchasing

Document

EKKO Purchasing Document Header EKPO Purchasing Document Item

IKPF Header- Physical Inventory Document ISEG Physical Inventory Document Items LFA1 Vendor Master (General section) LFB1 Vendor Master (Company Code) NRIV Number range intervals

RESB Reservation/dependent requirements

FI Tables

AGKO Cleared Accounts

ANAR Asset Types

ANAT Asset type text

ANEK Document Header Asset Posting ANEP Asset Line Items

ANEV Asset down payment settlement ANKT Asset classes- Description ANLA Asset Master Record Segment ANLB Depreciation terms

(28)

___________________________________________________________________________

ANLC Asset Value Fields ANLH Main asset number

AT02T Transaction Activity Category- Description AT02A Transaction Code for Menu TIMN

AT10 Transaction type AT10T Name of Transaction Type

BKDF Document Header Supplement for Recurring Entry BKORM Accounting Correspondence Requests

BKPF Accounting Document Header BLPK Document log header

BLPP Document log item

BLPR Document Log Index and Planned Order (Backflush) BNKA Bank master record

BP000 Business Partner Master (General Data) BPBK Doc.Header Controlling Obj.

BPEG Line Item Total Values Controlling Obj. BPEJ Line Item Annual Values Controlling Obj. BPEP Line Item Period Values Controlling Obj. BPGE Totals Record for Total Value Controlling obj. BPJA Totals Record for Annual Total Controlling Obj.

BSAD Accounting- Secondary Index for Customers (Cleared Items)

BSAK Accounting- Secondary Index for Vendors (Cleared Items) BSAS Accounting- Secondary Index for G/L Accounts (Cleared

Items)

BSEC One-Time Account Data Document Segment BSEG Accounting Document Segment

BSID Accounting- Secondary Index for Customers BSIK Accounting- Secondary Index for Vendors BSIM Secondary Index, Documents for Material BSIS Accounting- Secondary Index for G/L Accounts CEPC Profit Center Master Data Table

CEPCT Texts for Profit Center Master Data COBRA Settlement Rule for Order Settlement

COBRB Distribution Rules Settlement Rule Order Settlement COKA CO Object- Control Data for Cost Elements

COSP CO Object- Cost Totals for External Postings COSS CO Object- Cost Totals for Internal Postings CRCO Assignment of Work Center to Cost Center

CSKA Cost Elements (Data Dependent on Chart of Accounts) CSKB Cost Elements (Data Dependent on Controlling Area) CSLA Activity master

(29)

___________________________________________________________________________

FEBEP Electronic Bank Statement Line Items FPLA Billing Plan

FPLT Billing Plan- Dates GLPCT EC-PCA- Totals Table

KNA1 General Data in Customer Master KOMK Pricing Communication Header

SKA1 G/L Account Master (Chart of Accounts)

SKAT G/L Account Master Record (Chart of Accounts- Description)

SKB1 G/L account master (company code) T003T Document Type Texts

T007S Tax Code Names T087J Text

TAPRFT Text tab. for investment profile TKA01 Controlling Areas

TKA09 Basic Settings for Versions

(30)

___________________________________________________________________________

CHAPTER 4. BW

Transactions

Transaction Code Transaction Description

RS_PERS_ACTIVATE Bex Persoanization

RSA1 Administrator Work Bench (AWB)

RSA3 Extractor checker

RSA5 Transfer business content

RSA6 Post process of data sources

RSA7 Delta queue monitor

RSA8 Data source repository

RSA9 Transfer application components

RSADMIN Maintenance view

RSATTR Attribute hierarchy run realignment

RSBBS Query jump target

RSBMO2 Open hub monitor

RSD1 Maintain info object

RSDBC DB connect

RSDDV Aggregate maintenance

RSDL DB connect test program

RSH1 Edit hierarchy

RSH3 Simulate hierarchy

RSIMG BW IMG

RSIS1 Create info sources

RSISET Maintain info sets

RSKC Maintain permitted characters RSMO Monitor

RSO2 Generic data source

RSO3 Set up delta for generic data source

RSPC Process chain maintenance

RSRAJ Start reporting agent job

RSRT Report monitor

RSRTRACE Set trace configuration

RSRV Analysis and repair of BW objects RSSM Authorizations for reporting

RSSMQ Start query with user

RSSU53 Display BW authorization check RSSMTRACE To trace authorization for BW reports RSZC Copy queries between info providers RSZDELETE Delete query objects

(31)

___________________________________________________________________________

CHAPTER 5. Data Sources and Table/fields

GL Data Source 0FI_GL_4

Tables Used Financial Accounting document tables

BKPF and BSEG Mapping

Info Object Table(s) from R/3 and Field name

Description 0COMP_CODE BKPF-BUKRS 0AC_DOC_NO BKPF-BELNR 0ITEM_NUM BSEG-BUZEI 0FI_DOCSTAT BKPF-BSTAT, BSEG-AUGDT Open/Close status 0CHRT_ACCTS T001-KTOPL 0GL_ACCOUNT BSEG-HKONT 0ACCT_TYPE BSEG-KOART 0SP_GL_IND BSEG-UMSKZ 0AC_DOC_TYP BKPF-BLART 0POST_KEY BSEG-BSCHL 0DOC_DATE BKPF-BLDAT 0PSTNG_DATE BKPF-BUDAT 0CREATEDON BKPF-CPUDT 0CLEAR_DATE BSEG-AUGDT 0CLR_DOC_NO BSEG-AUGBL 0CO_AREA BSEG-KOKRS 0COSTCENTER BSEG-KOSTL 0PROFIT_CTR BSEG-PRCTR 0COORDER BSEG-AUFNR 0WBS_ELEMT BSEG-PROJK 0PLANT BSEG-WERKS 0BUS_AREA BSEG-GSBER 0FUNDS_CTR BSEG-FKBER 0PART_PRCTR BSEG-PPRCT 0PCOMPANY BSEG-VBUND 0PBUS_AREA BSEG-PARGB

0LOC_CURTP2 Uses function module

FI_CURRENCY_INFORMATION

0LOC_CURTP3 Uses function module

(32)

___________________________________________________________________________

0REF_DOC_NO BKPF-XBLNR

0REF_KEY3 BSEG-XREF3 Reference key for the document items

0ORG_DOC_NO Uses function module

BWFIU_GET_DOCUMENT_ORIGIN

0ORG_DOC_YR Uses function module

0ORG_DOC_CC Uses function module

0ORG_DOC_CO Uses function module

BWFIU_GET_DOCUMENT_ORIGIN 0TXTLG BSEG-SGTXT 0FISCPER BKPF-GJAHR, BKPF-MONAT 0FISCVARNT T001-PERIV 0DEBIT_LC BSEG- SHKZG,BSEG-DMBTR 0CREDIT_LC _BSEG-SHKZG, BSEG-DMBTR 0DEB_CRE_LC _BSEG-SHKZG, BSEG-DMBTR 0DEBIT_DC _BSEG-SHKZG, BSEG-WRBTR 0CREDIT_DC _BSEG-SHKZG, BSEG-WRBTR 0DEB_CRE_DC _BSEG-SHKZG, BSEG-WRBTR 0DEBIT_LC2, 0CREDIT_LC2, 0DEB_CRE_L2 BSEG-SHKZG, BSEG-DMBE2 0DEBIT_LC3, 0CREDIT_LC3, 0DEB_CRE_L3 BSEG-SHKZG, BSEG-DMBE3

(33)

___________________________________________________________________________

AR Data Source 0FI_AR_4

Tables Used BSID (Open Items), BSAD (Closed

Items) Mapping

Description

0RC_ACCOUNT BSID-SAKNR Reconciliation Account 0CLR_DOC_NO BSID-AUGBL 0BLINE_DATE BSID-ZFBDT 0AC_DOC_TYP BSID-BLART 0DOC_DATE BSID-BLDAT 0AC_DOC_NO BSID-BLNR 0TXTLG BSID-SGTXT 0PSTNG_DATE BSID-BUDAT 0COMP_CODE BSID-BUKRS 0POST_KEY BSID-BSCHL 0LAST_DUNN BSID-MADAT

0CLEAR_DATE BSID- AUGDT 0CREATEDON BSID-CPUDT 0REASON_CDE BSID-RSTGR 0FI_DSBITEM BSID-UPOSZ 0FI_XARCH BSID-XARCH 0CHRT_ACCTS T001-KTOPL 0ACCT_TYPE Fix value ‘D’ 0FI_SUBSID BSID-FILKD 0DEBITOR BSID-KUNNR 0C_CTR_AREA BSID-KKBER 0COUNTRY T001-LAND1 0DUNN_AREA BSID-MABER 0DUNN_KEY BSID-MSCHL 0DUNN_BLOCK BSID-MANSP 0DUNN_LEVEL BSID-MAHNS 0NETDUEDATE Calculated 0ITEM_NUM BSID-BUZEI 0FI_DOCSTAT Calculated 0INV_YEAR BSID-REBZJ 0INV_DOC_NO BSID-REBZG 0INV_ITEM BSID-REBZZ 0REF_DOC_NO BSID-XBLNR 0REF_KEY1 BSID-XREF1 0REF_KEY2 BSID-XREF2 0REF_KEY3 BSID-XREF3

(34)

___________________________________________________________________________ © Genie Press 2006 34 0GL_ACCOUNT BSID-HKONT 0PMNT_BLOCK BSID-ZLSPR 0DSCT_DATE1 Calculated 0DSCT_DATE2 Calculated 0SP_GL_IND BSID-UMSKZ

0DOC_NUMBER BSID-VBELN Sales Document 0PMNTTRMS BSID-ZTERM

0PYMT_METH BSID-ZLSCH

0FISCPER BSID-GJAHR and

BSID-MONAT 0FISCVARNT T001 – PERIV 0DEB_CRE_DC Calculated 0DEB_CRE_LC Calculated 0NETTERMS BSID-ZBD3T 0CREDIT_DC Calculated 0CREDIT_LC Calculated 0DSCT_PCT1 BSID-ZBD1P 0DSCT_DAYS1 BSID-ZBD1T 0DSCT_PCT2 BSID-ZBD2P 0DSCT_DAYS2 BSID-ZBD2T 0DSC_AMT_DC BSID- WSKTO 0DSC_AMT_LC BSID- SKNTO

0DISC_BASE BSID- SKFBT

0DEBIT_DC and 0DEBIT_LC

(35)

___________________________________________________________________________

AP Data Source 0FI_AP_4

Tables Used BSIK (Open Items), BSAK (Closed

Items) Mapping

Description

0RC_ACCOUNT BSIK-SAKNR Reconciliation Account 0CLR_DOC_NO BSIK-AUGBL 0BLINE_DATE BSIK-ZFBDT 0AC_DOC_TYP BSIK-BLART 0DOC_DATE BSIK-BLDAT 0AC_DOC_NO BSIK-BLNR 0TXTLG BSIK-SGTXT 0PSTNG_DATE BSIK-BUDAT 0COMP_CODE BSIK-BUKRS 0POST_KEY BSIK-BSCHL 0LAST_DUNN BSIK-MADAT

0CLEAR_DATE BSIK- AUGDT 0CREATEDON BSIK-CPUDT 0REASON_CDE BSIK-RSTGR 0FI_DSBITEM BSIK-UPOSZ 0FI_XARCH BSIK-XARCH 0CHRT_ACCTS T001-KTOPL 0ACCT_TYPE Fix value ‘K’ 0FI_SUBSID BSIK-FILKD 0DEBITOR BSIK-KUNNR 0C_CTR_AREA BSIK-KKBER 0COUNTRY T001-LAND1 0DUNN_AREA BSIK-MABER 0DUNN_KEY BSIK-MSCHL 0DUNN_BLOCK BSIK-MANSP 0DUNN_LEVEL BSIK-MAHNS 0NETDUEDATE Calculated 0ITEM_NUM BSIK-BUZEI 0FI_DOCSTAT Calculated 0INV_YEAR BSIK-REBZJ 0INV_DOC_NO BSIK-REBZG 0INV_ITEM BSIK-REBZZ 0REF_DOC_NO BSIK-XBLNR 0REF_KEY1 BSIK-XREF1 0REF_KEY2 BSIK-XREF2 0REF_KEY3 BSIK-XREF3

(36)

___________________________________________________________________________ © Genie Press 2006 36 0GL_ACCOUNT BSIK-HKONT 0PMNT_BLOCK BSIK-ZLSPR 0DSCT_DATE1 Calculated 0DSCT_DATE2 Calculated 0SP_GL_IND BSIK-UMSKZ

0DOC_NUMBER BSIK-VBELN Sales Document 0PMNTTRMS BSIK-ZTERM

0PYMT_METH BSIK-ZLSCH

0FISCPER BSIK-GJAHR and

BSIK-MONAT 0FISCVARNT T001 – PERIV 0DEB_CRE_DC Calculated 0DEB_CRE_LC Calculated 0NETTERMS BSIK-ZBD3T 0CREDIT_DC Calculated 0CREDIT_LC Calculated 0DSCT_PCT1 BSIK-ZBD1P 0DSCT_DAYS1 BSIK-ZBD1T 0DSCT_PCT2 BSIK-ZBD2P 0DSCT_DAYS2 BSIK-ZBD2T 0DSC_AMT_DC BSIK- WSKTO 0DSC_AMT_LC BSIK- SKNTO

0DISC_BASE BSIK- SKFBT

0DEBIT_DC and 0DEBIT_LC

Calculated

HR Data Source 0HR_PA_1 (Personnel Actions)

Tables Used PA0000, PA0302

Mapping

Description 0EMPLSTATUS PA0000-STAT2

0ACTIONREAS MASSG from PA0000, PA0302 0ACTIONTYPE MASSN from

PA0000, PA0302

0EMPLOYEE PERNR from

PA0000, PA0302

0CALDAY BEGDA from

(37)

___________________________________________________________________________

HR Data Source 0HR_PA_BN_1 (Benefits)

Tables Used Uses the function module

HR_BW_EXTRACT_IS_BENPLAN Mapping

Description 0BEN_AREA _PA0171-BAREA

0BEN_PLAN _T5UBU-BPLAN 0DEPCVRG _PA0167-BPCAT

0PRGM_GRP1 PA0171-BENGR First programming grouping 0HICOMP _PA0375-HICMP Highly compensated employee 0PLANCATEG _T5UB1-BPCAT Plan category

0BEN_OPTION PA0167 PA0168 PA0377 fields BOPTI BCOVR LEVL1 0PLANTYPE _T5UBA-PLTYP 0PRGM_GRP2 PA0171-BSTAT

HR Data Source 0HR_PY_1 (Payroll Data)

Tables Used Data is read from payroll cluster PCL2

and not from standard tables Mapping

Description 0BUS_AREA WPBP-GSBER 0COMP_CODE WPBP-BUKRS 0COUNTRY_ID VERSC-MOLGA 0EMPLGROUP WPBP-PERSG 0HRPOSITION WPBP-PLANS 0JOB WPBP-STELL 0MAST_CCTRW WPBP-KOSTL 0ORGUNIT WPBP-ORGEH 0PERS_AREA WPBP-WERKS

(38)

___________________________________________________________________________ © Genie Press 2006 38 0PERS_SAREA WPBP-BTRTL 0TIME_STAT WPBP-ZTERF 0WAGETYPE RT-LGART 0RTNUM RT-ANZHL 0AMOUNT RT-BETRG

Material Movements (Stock initialization) 2LIS_03_BX

This replaces 2LIS_40_S278. it calculates valuated sales order stock.

Tables Used Filled only from stock tables and not from MSEG or BSEG

Mapping

Description 0BATCH Stock table –

CHARG

0CUST_VEND From stock table (KUNNR)

0MATERIAL From stock table 0PLANT From stock table 0STOCKCAT Filled according to

stock

0STOCKTYPE Filled according to stock

0STOR_LOC Filled according to stock

0VAL_TYPE MCHA-BWTAR

Material Movements from Inventory Management 2LIS_03_BF

This replaces 2LIS_40_S278. it calculates valuated sales order stock.

Tables Used MSEG, MBEW

Mapping

Description

0RT_PROMO MSEG-AKTNR

0VAL_CLASS MBEW-BKLAS

0DOC_DATE MKPF-BLDAT

0STOCKTYPE Filled by LIS 0STOCKCAT Filled by LIS

(39)

___________________________________________________________________________ © Genie Press 2006 39 0PSTNG_DATE MKPF-BUDAT 0COMP_CODE MSEG-BUKRS 0BWAPPLNM BW customizing 0MOVETYPE MSEG-BWART 0STOCKRELEV BW customizing 0VAL_TYPE MSEG-BWTAR 0PROCESSKEY BW Customize 0BATCH MSEG-CHARG

0MATMREA MSEG-GRUND Reason for goods movement

0BUS_AREA MSEG-GSBER 0COSTCENTER MSEG-KOSTL 0SOLD_TO MSEG-KUNNR 0WHSE_NUM MSEG-LGNUM 0STOR_LOC MSEG-LGORT 0STRGE_BIN MSEG-LGPLA 0VENDOR MSEG-LIFNR 0MATERIAL MSEG-MATNR 0DOC_NUM MKPF-MBLNR 0DOC_YEAR MKPF-MJAHR 0PROFIT_CTR MSEG-PRCTR 0DCINDIC MSEG-SHKZG 0PLANT MSEG-WERKS 0CO_AREA MSEG-KOKRS 0DOC_ITEM MSEG-ZEILE 0COORDER MSEG-AUFNR 0MOVE_PLANT MSEG-UMWRK

0INDSPECSTK MSEG-KZBWS Valuation special stock 0CPPVLC BW Customizing 0CPSVLC BW Customizing 0CPSTLC BW Customizing 0CPQUABU BW Customizing 0VALUE_LC MSEG-DMBTR 0QUANT_B MSEG-MENGE