‎2005 Sep 23 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 .
‎2005 Sep 23 4:06 PM
‎2005 Sep 23 5:00 PM
please first put some self effort
and then post your code if you are facing some problem
thanks
‎2005 Sep 23 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.
‎2005 Sep 23 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
‎2005 Sep 23 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
‎2005 Sep 23 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