mySAP Study: April 2007

Tuesday, April 24, 2007

BW310 - Data Warehousing

Title: BW310 - Data Warehousing

Pages: 497

Size: 44.9 MB

DOWNLOAD ( Megashare)

Password: sapdocs

reference: mysapbi.blogspot.com

BW365 : SAP BW Authorizations

BW365 - SAP BW Authorizations

Size: 20.3 MB

Pages: 241

Course Goals

This course will provide you with the knowledge and skills to set up a security concept and implement it in SAP BW.

Target Audience

Employees responsible for security and authorization administration in Business Information Warehouse

Prerequisites

Essential:

- ADM940 SAP Authorization Concept or CA940 SAP R/3 Authorization Concept or equivalent knowledge

- BW310 SAP BW Data Warehousing

- BW305 SAP BW Reporting & Analysis

Course Content

SAP BW architecture and strategies for an authorization concept
Similarities and differences between security requirements in SAP R/3 and SAP BW
Setting up authorizations for reporting users
SAP BW administrators and authorizations for administrative tasks
Standard roles and templates for supporting the creation of an authorization concept
Authorizations necessary for linked source systems

Download

reference:mysapbi.blogspot.com

Sunday, April 22, 2007

SAP Tables SD tables

Customers

KNA1 General Data
KNB1 Customer Master–CCode Data (payment method, recon. acct)
KNB4 Customer Payment History
KNB5 Customer Master – Dunning info
KNBK Customer Master Bank Data
KNKA Customer Master Credit Mgmt.
KNKK Customer Master CCA Data (credit limits)
KNVV Sales Area Data (terms, order probability)
KNVI Customer Master Tax Indicator
KNVP Customer master partner Function
KNVD Output type
KNVS Customer Master Ship Data
KLPA Customer/Vendor Link
V_THIT Customer Hierarchy Types
KNVH Customer Hierarchies
KNVK Customer master Contact partner

Sales Documents

VBAKUK VBAK + VBUK
VBUK Header Status and Administrative Data
VBAK Sales Document – General Header Data
VBKA Sales Activities
VBKD Sales Document - Business Header/Item Data
VBPA Sales Document - Partners Header Data
VBUP Item Status
VBPA Sales Document – Partner Item Data
VBAP Sales Document – General Item Data
FPLA sales Document – Items Conditions data
VBFA Document Flow
VBEP Sales Document Schedule Line
VBBE Sales Requirements: Individual Records
VEDA Sales Contract Data
VBELN Sales and Distribution Document Number

SD Delivery

LIPS Delivery Document item data, includes refer. PO
LIKP Delivery Document Header data
Billing Document
VBRK Billing Document Header
VBRP Billing Document Item
Pricing Document
KONP Conditions Item
KONV Condition for Transaction Data
Handling Unit
VEKP Shipping Unit Header
VEPO Shipping Unit Item

Transportation

VTTK Shipment Header
VTTP Shipment Item
TVRO Routes
TVTK Shipment Types
VTRLK Delivery in shipment: Header

Sales Documents Copy Control Tables

TVAK Sales Document Types
TVCPA Sales Documents: Copying Control
T184 Sales Documents: Item Category Determination
TVASP Sales Documents: Blocking Reasons
TVCPF Billing: Copying Control
TVCPL Deliveries: Copying Control

Sales Documents Item Categories Copy Control Tables

TVAPT Sales document item categories: Texts
TVCPA Sales Documents: Copying Control
TVCPF Billing: Copying Control
TVCPL Deliveries: Copying Control
TVEPZ Sales Document: Schedule Line Category Determination
TVLP Deliveries: Item Categories
TVPT Sales documents: Item categories

Sales Documents Schedule Line Categories Copy Control Tables

TVCPA Sales Documents: Copying Control

Billing Documents Copy Control Tables

TVCPF Billing: Copying Control
TVFSP Billing: Blocking Reasons

Delivery Documents Copy Control Tables

T184L Sales Documents: Item Category Determination
TVCPF Billing: Copying Control
TVCPL Deliveries: Copying Control
TVLSP Delivery Blocks

SD Links to FI tables

KNVP Customer Master Partner Functions
KNVV Customer Master Sales Data
KNVD Customer master record sales request form
KNA1 General Data in Customer Master
KNB1 Customer Master (Company Code)
KNB5 Customer master (dunning data)

SD Links to MM tables

MARC Plant data for material
MVKE Sales data for material
MBEW Material Valuation
MARD Storage Location data for Material
T179 Materials: product hierarchy
MLAN Tax classification for material
MAKT material description
MARA General material data
MARM Units of measure of material
MTART – Material Types

SAP SD Structures

VBDKA - Document Header View for Inquiry, Quotation, Order
VBDPA - Document Item View for Inquiries, Quotation, Order
KOMK Communication Header for pricing
KOMP Communication Item for pricing

SAP SD_Relationship Marix Image

BW Queries/Workbooks/Web templates

Queries
RSZELTDIR Directory of the reporting component elements
RSZELTTXT Texts of reporting component elements
RSZELTXREF Directory of query element references
RSRREPDIR Directory of all reports (Query GENUNIID)
RSZCOMPDIR Directory of reporting components

Workbooks
RSRWBINDEX List of binary large objects (Excel workbooks)
RSRWBINDEXT Titles of binary objects (Excel workbooks)
RSRWBSTORE Storage for binary large objects (Excel workbooks)
RSRWBTEMPLATE Assignment of Excel workbooks as personal templates
RSRWORKBOOK 'Where-used list' for reports in workbooks

Web templates
RSZWOBJ Storage of the Web Objects
RSZWOBJTXT Texts for Templates/Items/Views
RSZWOBJXREF Structure of the BW Objects in a Template
RSZWTEMPLATE Header Table for BW HTML Templates