Tuesday, May 6, 2008

LIST of TABLES

Sales orders

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