SAP BW 3.5 Function Details

This document can be used as a handbook for understanding SAP BW 3.5 objects/functionalities. Click the link below
SAP_BW_3.5_Functoin_Detail

Sales and Distribution - Tables and Structures

Sales Document
VBAK Sales Document - Header Data
VBKD Sales Document - Business Data
VBUP Item Status
VBAP Sales Document - Item Data
VBPA Partners
VBFA Document Flow
VBEP Sales Document Schedule Line
VBAKUK Sales Document Header and Status Data
VBUK Header Status and Administrative Data
VBBE Sales Requirements: Individual Records

SD Delivery Documemt
LIPS Delivery Document item data
LIKP Delivery Document Header data

Billing Document
VBRK Billing:Header data
VBRP Billing:Item data

Material Master
MARA General Material Data
MVKE Sales Data for Material
MARC Plant Data for Material
MARD Storage Location Data for Material

Customer Master
KNA1 General Data
KNB1 Customer Master (Company Code)
KNB4 Customer Payment History
KNB5 Customer master (dunning data)
KNBK Customer Master (Bank Details)
KNBW Customer master record (withholding tax types)
KNKA Customer Master Credit Mgmt.
KNKK Customer Master Credit Control Area Data (credit limits)
KNVA Customer Master Loading Points
KNVD Customer master record sales request form
KNVH Customer Hierarchies
KNVI Customer Master Tax Indicator
KNVK Customer Master Contact Partner
KNVL Customer Master Licenses
KNVP Customer Master Partner Functions
KNVS Customer Master Shipping Data
KNVT Customer Master Record Texts for Sales
KNVV Customer Master Sales Data
KLPA Customer/Vendor Link

Pricing
KOMK Pricing Communications-Header - Structure
KOMP Pricing Communication Item - Structure
KONV Conditions (Transaction Data)
KONP Conditions (Item)

Output
NAST Message Status

SD Shipping Unit
VEKP Shipping unit item (Content)
VEPO Shipping Unit Header

Delivery Due Index - item
VBUP: Item status
VBAP: Sales document: Item data
VBKD: Sales document: Business Data
VEBA: Contract
VBLB: Forecast delivery schedules
VBEP: Sales document: Schedule line
VBBE: Individual requirements
VBBS: Summarized requirements
VBUV: Incompletion log
VBFA: SD document flows
VBPA: Partner
JSTO: PP status
NAST: Output
STXH: Texts: Header
STXL: Texts: Lines
KONV: Conditions

SALES - header
VBUK: Header status and administrative data
VBAK: Sales document: Header data
VBKD: Sales document: Business Data
VAKPA: Partner index
VEDA: Contract
VBPA: Partner
VBUV: Incompletion log
VBFA: SD document flows
VMVA: Matchcodes
STXH: Texts: Header
STXL: Texts: Line
NAST: Output
JSTO: PP status

Sales activities
VBKA Sales activity
VBUV: Incompletion log
VBPA: SD document: Partner
SADR: Address
VBFA: SD document flows
NAST: Output
STXH: Texts: Header
STXL: Texts: Lines

Logical database:
AK V: Sales documents

Bill of Material (BOM)
MAST Material assignment to BOM
EQST Equipment assignment to BOM
KDST Sales order assignment to BOM
DOST Document assignment to BOM
STST Standard object assignment to BOM
TPST Functional location assignment to BOM
STKO BOM header data
STZU Time-independent STL data
STAS BOM item selection
STPO BOM item data
STPU BOM sub-item data

Material
MARA General material data
MAKT Short texts
MARM Conversion factors
MVKE Sales data (for each sales organization and distribution channel)
MLAN Sales data (for each country)
MAEX Export licenses
MARC Plant data
MBEW Valuation data
MLGN Warehouse management inventory data
MLGT Warehouse management inventory type data
MVER Consumption data
MAPR Pointers for forecast data
MARD Storage location data
MCH1 Cross-plant batches
MCHA Batches
MCHB Batch stocks
KNMTK Header table
for increased performance
KNMT Data table

Logical databank for material master
CKM Material master
MSM Material master

Customer
KNA1 Customer master, general information
KNVK Contact person
KNVV Customer master, sales area
KNVA Unloading points
KNVI Tax indicators
KNVP Partner functions
KNVD Documents
KNVL Licenses
KNVS Shipping data

Sales and Distribution (SD)
VBFA Document flow (alg.)
VTFA Flow shipping documents

Sales order
VBAK Header data
VBAP Item data
VBPA Partners in sales order
VBKD Sales district data
VBEP Data related to line items, delivery lines

Billing document
VBRK header data
VBRP Item data

Shipping
VTTK Shipment header
VTTP Shipment item
VTTS Stage in transport
VTSP Stage in transport per shipment item
VTPA Shipment partners
VEKP Handling Unit - Header Table
VEPO Packing: Handling Unit Item (Contents)

Delivery
LIKP Delivery header
LIPS Delivery item

Pricing
KONH Conditions header
KONP Conditions items
KONV Procedure ( billing doc or sales order)
KOND contracts
VEDA Contract data

orginal link

SAP GUI 7.20 Download

This is a new release for SAP GUI compatible with Windows7 and Office2010. Please click the link and download the file directly.


The new SAP GUI release comes with a number of useful new features:
- Support for Windows 7 operating system & Office 2010 package (32bit version)
- SAP Logon: Hierarchical organization of items in an explorer like view and a tree like view.
- SAP Logon: With release 7.20, an administrator can define a central saplogon.ini which can be merged into the local user specific saplogon.ini.
- Options Dialog: Almost all options have been merged into a new user friendly dialog that replaces Tweak SAP GUI and the old options dialog.
- Security Enhancements: A set of maintainable security rules which allow administrators and users to prevent unwanted access to the client PCs from SAP systems have been defined.
- Animated Focus Frame: Improved visualization of the focus and its movement across the screen.
- High Contrast Theme for SAP Signature Design: Improved visual design for users with visual impairments, based on the successful SAP Signature Design.
- Better organization of local data: Downloaded files, traces, scripts and other local objects are stored in different folders (roaming and local) according to Windows standards.

Besides this SAP GUI for Windows 7.20 is fully compatible with older SAP GUI releases.

Since SAP GUI for Windows 6.20 will be out of maintenance as of 1st of January 2011 and SAP GUI for Windows 7.10 will be out of maintenance as of 13th of April 2011 we recommend to start planning the upgrade to release 7.20 as soon as possible.

Download link

Custom Transaction codes

If we develop some Module pool programs or Report Programs, to make these programs available to the end users. we create transaction codes for these programes."se93" is the transaction where one can create his own custom Transaction codes.
Custom Tcodes will start with Y* or Z*.
For performing any kind of task in the SAP R/3 or BW system, a transaction is used. SAP provides a standard set of transactions to manipulate i.e insert, update, delete and display data in the system. But sometimes, the need to create a customer specific transaction may arise due to the following reasons

--> Standard SAP may not support that task

--> A particular transaction needs to be customized to suit the customer requirements

A transaction is defined as a sequence of dynpros (sap term for screens) having input and output fields and corresponding processing logic behind them to perform a particular task.

We call an execution of an ABAP program using a transaction code a transaction . There are dialog , report, parameter, variant, and - as of Release 6.10 - OO transactions. A transaction is started by entering the transaction code in the input field on the standard toolbar or by means of the ABAP statements CALL TRANSACTION or LEAVE TO TRANSACTION. Transaction codes can also be linked to screen elements or menu entries. Selecting such an element will start the transaction.

BW3.0b Interview/Certification Questions

HI,

This material will be quite useful to many.

BW3.0b Questions

SAP NetWeaver 2004s (BI7)

This is a small presentation on SAP BI7, new features, improved abilities, arguments for upgradation etc. Think many will get a basic idea about new BI tool in NetWeaver.
http://www.esnips.com/doc/f29439b7-6cbd-4985-86df-bd7870f58791/SAP-BI7-arguments

Introduction

Hi,
I am a SAP Consultant and this blog is for all those fellows who are novice in this tool. This blog refers to all those frequent support issues, Implimentation problems, BW recent developments and Enhansements that i have come accross. I hope this will be quite helpful for all.

Obily B W