09-23-2005 2:11 PM
I am having 6 TABLE <b>payr, bkpf, bseg,covp,bsid,bsad</b>.
i need profit center group, payment date and transaction date field exactly from these table .
09-23-2005 4:06 PM
09-23-2005 5:00 PM
please first put some self effort
and then post your code if you are facing some problem
thanks
09-23-2005 5:46 PM
i couldn't find out fields from these table, pls give some solutions for this problem since after selecting this field only i can go for coding.
09-23-2005 5:55 PM
open all the tables in se11
and try if you can fined them, look into description of fields
if found try where used list button so see how it is used
hope this help
regards
09-23-2005 5:56 PM
Hi
payment date is the date in which payment is posted: field AUGDT (BSEG/BSAD-AUGDT),
Transaction date: what does it mean? which document? Invoice or Payment? Perhaps it's posting date (field BUDAT, BSEG/BSAD/BSID-BUDAT)! Perhasp it's entrying date CPUDT
Profit center you can't find in customer but in general account (BSIS/BSAS).
Max
09-23-2005 6:34 PM
For Profit centre Group ( SETLEAF-SETNAME )
Select BSEG-BUKRS / BSEG-PRCTR from BSEG.
SELECT SINGLE SETNAME INTO WA_SETNAME
FROM SETLEAF
WHERE SETCALSS = '0106'
AND SUBCLASS = BSEG-BUKRS
AND VALFROM = BSEG-PRCTR .
This was tricky . Hope this helps.
Cheers