03-11-2009 3:22 PM
Hi gurus,
my customer would like to see the contract nr. and the contract type populated in PO and possibly RFQ.
What fields (and tables) can I use, any clues or suggestions?
Thx
RM
03-11-2009 3:27 PM
Hi,
Contract number is sotred in the table EKKO with the filed EBELN .
contract type is EBTYP = "K' ( for contracts...)
select EBELN
FROM EKKO,
WHERE EBTYP = 'K' " contracts
hope it helps you.
Thanks!
03-11-2009 3:25 PM
03-11-2009 3:27 PM
Hi,
Contract number is sotred in the table EKKO with the filed EBELN .
contract type is EBTYP = "K' ( for contracts...)
select EBELN
FROM EKKO,
WHERE EBTYP = 'K' " contracts
hope it helps you.
Thanks!
03-11-2009 3:34 PM
for Service Contracts: VBAK , AUART (order type) check what order types they want to display and query on VBAK for those Order types.
AUART: "likely to change..
AC Quotation f.Contra
CD Contract Handling
CE Quantity Contract
GQ Master Contract