Relation ship between AUFK, AFKO, AFPO , MKPF, TCC02 and T132T tables

[Former Member]

Hi there,

Could any one provide the relations ship between the following tables

AUFK, AFKO, AFPO , MKPF, TCC02 and T132T tables

Actually we need to capture the some xxxx fileds from Production Order(CO03). by using the below realtion we can pull the data.

AUFK--->AFKO->AFPO-> MSEG--

---

>MKPF

(AUFNR) (AUFNR) (AUFNR) (AUFNR, MBLNR) (MBLNR)

But we need two more fileds System Status and User status from Production Order(CO03), we couldnt able to find these two fileds in any of the above mentioned tables. However we found that these two fileds are actually coming from TCC02 and T132T tables. so could any one please help in finding the relation between these tables.

Many thanks for your help.

[former_member226234 · Accepted solution]

Hi,

You can use the following

CAUFV (View of AUFK and AFKO)->Join on AUFNR and MATNR<-AFPO

CAUFV->Join on OBJNR<-JEST

JEST->Join on STAT<-TJ02T

This is the logic for production order status.

Use TCC01-STLTY = CAUFV-STLTY for ECH object texts

Regards,

Sandeep

[Former Member · Accepted solution]

Hi sandeep,

JEST->Join on STAT<-TJ02T

Couldn't able to find relation between these two tables JEST has STAT filed, but TJ02T ISTAT field.

I created a view basing on your inputs, However when I try to see the contents of the view, Its just executing, I couldnt able to see data in view.

Please help.

[Former Member · Accepted solution]

SVQI select tables AUFK, JEST, TJ02T, then define List fields and Selection fields

1. AUFK-OBJNR join JEST-OBJNR is proposed automatically

2. JEST-STAT join TJ02T-ISTAT must manually define linking, select JEST-STAT and drags on TJ02T-ISTAT

Put in the selection fields TJ02T-SPRAS, in Run fill it with value "your language", table Tj02T contains all status language.

Regards

Antonio

[former_member183990]

best to make a mapping diagram through a quick viewer

and you will get the relation between the tables

sqvi is the tcode for that

cheers

s.janagar

[Former Member]

Hello Janagar,

Thank you for your reply.

Could you please provide more information on make a mapping diagram through a quick viewer(SQVI).

I dont know how to get it.

[Former Member]

hi,

you can use SQVI tcode.

1. Go to transaction SQVI

2. Create a View

3. Enter title

4. Choose the Data source as Table Join

5. Go to insert table and add table as per your requirement.

regards,

sakshi

[Former Member]

You find status using function module STATUS_TEXT_EDIT or BAPI_BUS2002_GET_STATUS or access tables:

Table JEST - Individual Object Status

OBJNR Object number from AUFK-OBJNR

STAT Object status Exxxx-internal user status Ixxxx-internal code system status

INACT Flag: Status inactive use blank, X=inactive (previus status)

CHGNR Change number counter for Object

Table TJ02 & TJ02T : system status code internal - external and description

Table JSTO User Status object information

OBJNR Object number from AUFK-OBJNR

OBTYP Object type

STSMA Status profile

CHGKZ Indicator: Change documents are active

CHGNR Change number

Table TJ30T Texts for user status

STSMA J_STSMA from JSTO-STSMA

ESTAT J_ESTAT from JEST- STAT Exxxx-internal user status

SPRAS SPRAS

TXT04 J_TXT04 external code

TXT30 J_TXT30

LTEXT J_LANGTEXT

Regards

Antonio

Edited by: Antonio Mannarino on Feb 13, 2010 12:52 PM