Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

In which table contract number is stored ?

former_member1349771
Participant
0 Kudos

In which table contract number is stored with respect to Purchase order.

Which table contains contract related out line and service number.

Culd u plz guide its urgent

Regards,

Vibhuti

1 ACCEPTED SOLUTION

varma_narayana
Active Contributor
0 Kudos

Hi

Contract No is also stored in Table EKKO-EBELN field (Purchasing doc no).

SELECT * FROM EKKO WHERE EBTYP = 'K'. "Contracts.

reward if Helpful.

7 REPLIES 7

Former Member
0 Kudos

<b>GoTo -> SE84, In the Left Panel: ABAP Dictionary fields --> Table fields -->Give your field description and Execute ( F8) it ..</b>

varma_narayana
Active Contributor
0 Kudos

Hi

Contract No is also stored in Table EKKO-EBELN field (Purchasing doc no).

SELECT * FROM EKKO WHERE EBTYP = 'K'. "Contracts.

reward if Helpful.

Former Member
0 Kudos

Hi,

You can find the field in the Pirchase order transaction, from there you can find the table, please use the below link to find the table name for the screen field

/people/community.user/blog/2006/12/29/useful-tips-to-find-out-the-table-for-screen-field

Regards

Sudheer

Former Member
0 Kudos

I think u can check with tables VEDA and VEDAPO

Message was edited by:

Saran

Message was edited by:

Saran

Former Member
0 Kudos

Hi,

you can use this:

  • Bestellungen (Kontrakte)

SELECT * FROM EKKO WHERE BSTYP = 'K'.

*

...

SELECT * FROM EKPO WHERE EBELN = EKKO-EBELN.

*

...

CALL FUNCTION 'ME_READ_RELEASE_DOCU'

EXPORTING

BUKRS = P_BUKRS

EBELN = EKKO-EBELN

EBELP = EKPO-EBELP

WAERS = EKKO-WAERS

WKURS = EKKO-WKURS

IMPORTING

SUWRT = KTWRT

TABLES

XADO = ADO

XADOS = ADOS.

*

...

*

ENDSELECT.

*

ENDSELECT.

Regards, Dieter

0 Kudos

which tables ?

XADO = ADO

XADOS = ADOS

plz specify

regards,

vibhuti

0 Kudos

Hi,

take both tables.

ADO are single lines, ADOS are sum of the ADO.

Regards, Dieter