cancel
Showing results for 
Search instead for 
Did you mean: 

Tables

0 Kudos

Hi all,

I need relevant database tables for the following document types :

A Inquiry

B Quotation

C Order

D Item proposal

E Scheduling agreement

F Scheduling agreement with external service agent

G Contract

H Returns

I Order w/o charge

J Delivery

K Credit memo request

L Debit memo request

M Invoice

N Storno Rechnung

O Credit Not

P Debit Note

Q WMS transfer order

R Goods movement

S Storno Gutschrift

T Returns delivery for order

U Proformarechnung

V Purchase order

W Independent reqts plan

X Shipping unit

0 Master contract

1 Sales activities (CAS)

2 Proof of delivery

3 Invoice list

4 Credit memo list

5 Interne Verrechnung (Rechnung)

6 Intercompany credit memo

7 Delivery/shipping notification

8 Shipment

a Freight charges

g Rough Goods Receipt (only IS-Retail)

h Cancel goods issue

i Goods receipt

j JIT call

Eg: for type C - orders table is VBAK.

-


santhosh

Accepted Solutions (0)

Answers (7)

Answers (7)

Former Member
0 Kudos

Scheduling agreement with external service agent:KNKK,KNMT,KNKA,VBEP

Contract : KNKK,KNMT,KNKA,s116.

scheduling agreement:KNKK,KNMT,KNKA,VBEP

shipping VTTK,VTTP,VTTS,VTPA

delivery LIKP,LIPS

inquiry:KNA1,KNB1,KNVV,KNVS

quotation:KNB1,KNA1,KNVV,VBAK

order:VBAK,VBAP,VBUK,VBUP,VBEP,VBPA.

item proposal:

purchase order:EKKO,EKPO,EINA,EINE

Former Member
0 Kudos

hi santosh,

these are the tables

a. inquiry:KNA1,KNB1,KNVV,KNVS

B.quotation:KNB1,KNA1,KNVV,VBAK

c.order:VBAK,VBAP,VBUK,VBUP,VBEP,VBPA.

D. item proposal:

E.scheduling agreement:KNKK,KNMT,KNKA,VBEP

F.Scheduling agreement with external service agent:KNKK,KNMT,KNKA,VBEP

G Contract : KNKK,KNMT,KNKA,s116.

shipping VTTK,VTTP,VTTS,VTPA

delivery LIKP,LIPS

purchase order:EKKO,EKPO,EINA,EINE

Former Member
0 Kudos

hi,

all the fields are stored in vbtyp,vbfa tables............

and dd7t store these values.........

Former Member
0 Kudos

Please check the below link it would answer most from the list.

www.erpgenie.com

If you browse around ABAP and Functional modules you would get the list of all tables.

former_member181962
Active Contributor
0 Kudos

Whatever may be the document type , the document resides in VBAK table only.

Regards,

Ravi

Former Member
0 Kudos

Table DD07T stored these values your require for the domain VBTYP. All you need to do is look at the table VBFA to see how the field is defined.

Former Member
0 Kudos

These values are assigned at the domain level . The domain being VBTYP.