Friday, November 23, 2007

SAP MODULE WISE TABLES

Name

Description

Uses

LIKP

Shipped Lines header


LIPS

Shipped Lines detail


VBAK

Order header

Every order (unless archiving)

VBAP

Table fields

Every line item (unless archiving)

VBBE

Open sales order line items

Great file, but be careful. Contents don't reflect orders that do not affect purchasing (go figure).

VBFA

Document flow

Let's you move from order to shipping document to invoice.

VBUK

Order status


VBUP

Line item detail status


Material Management

Name

Description

Uses

MARA

Inventory Master


MARC

Plant Data


MARD

Current Inventory


MAKT

Descriptions


MBEW

Material Valuation


T179

Product Hierarchy


MVKE

Sales data (materials)


MKPF

Material document

Status code 'R' in VBFA

Purchasing

Name

Description

Uses

EINA

Purchasing inforecord

by MATNR/LIFNR contains things like vendor material number and access key for EINE

EINE

Purchasing inforecord detail

Contains minimum purchase, group, currency

EKPO

Purchase orders


EKET

Scheduled lines


EKES

Vendor confirmed lines





Service Management

Name

Description

Uses

CAUFV

Service order header


AFPO

Service order line

Holds items that will create "reservations"

RESB

SM Reservations

Materials needed for line


Customer Data

KNAI

Customer Master


KNVV

Sales information


KNVP

Partners (ship-to, etc)











System tables

Name

Description

Uses

DD02T

Table texts


DD03L

Table fields

Lists the fields in a table

DD04T

Data element texts


USR02

Valid user names


Config tables (normally begin with "T")

Name

Description

Uses

T001

Client table


T002

Languages


T005

Region (Country)


TCURR

Currency and exchange rates


TVAK

Order type


TVSB

Shipping condition


TVAGT

Rejected reason for order line


Other tables

Name

Description

Uses

STXH

Text header


STXL

Text detail


No comments:

Blog Archive