2010 May 06 6:32 AM
Hi All.
In receipt entry for order there is field named Balance whose data element is wertv8, i need to know the relevant database tables for the same field so that i can pick up the value. I tried to find out but didn't get any table..
Thanks.
2010 May 06 6:56 AM
Hi,
To find the relevant tables for the field, you can take help of 'Where Used' option in SAP.
Some of the tables you from get there are :-
INV_PYMT_DATA CRM: Invoice Payment Details for Billing Document
FKCRM_PYMTDETAILS Payment Data for CRM Invoice
MMCOM Communication Between MM and Variant Configuration
FIN_ICM_INV_PYMT_DATA CRM: Invoice Payment Details for Billing Document
SDCOM Communication between SD and Variant Configuration
TKE_DIST_SRC_VF COPA Distribution: Value Field Assignment
Just try that once your self, you might find something useful.
Hope it helps.
Thanks,
Daya
2010 May 06 7:28 AM
Hi,
Actually i know where used option but as i said i am not finding the relevant table...
tables which you have mentioned are not helpful for me..
Thanks.
2010 May 06 11:20 AM
Hi ,
I think it is TKE_DIST_SRC_VF - COPA Distribution: Value Field Assignment
Regards,
Pravin
2010 May 06 11:29 AM
Hi,
goto that table> put cursor on the data element> click on where used list in datbase tables
from there u can find all the related tables.
Thanks
2010 May 10 6:42 AM
i know that but i am not getting any table or view name ...if someone know the table or view name please provide it ..
Thanks.
2010 May 10 7:13 AM
Please tell us the t-code you are using to view/change receipt entry; that will make it easier to find the database table.
Regards
2010 May 10 7:33 AM