topic fields in table in Application Development and Automation Discussions

fields in table

Former Member — Fri, 23 Sep 2005 13:11:09 GMT

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 .

Re: fields in table

Former Member — Fri, 23 Sep 2005 15:06:37 GMT

Was this a question or a statement?

Re: fields in table

Former Member — Fri, 23 Sep 2005 16:00:49 GMT

please first put some self effort

and then post your code if you are facing some problem

thanks

Re: fields in table

Former Member — Fri, 23 Sep 2005 16:46:25 GMT

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.

Re: fields in table

Former Member — Fri, 23 Sep 2005 16:55:17 GMT

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

Re: fields in table

Former Member — Fri, 23 Sep 2005 16:56:55 GMT

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

Re: fields in table

Former Member — Fri, 23 Sep 2005 17:34:29 GMT

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