on 11-14-2006 11:04 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
all the fields are stored in vbtyp,vbfa tables............
and dd7t store these values.........
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please check the below link it would answer most from the list.
If you browse around ABAP and Functional modules you would get the list of all tables.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Whatever may be the document type , the document resides in VBAK table only.
Regards,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
These values are assigned at the domain level . The domain being VBTYP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.