topic Re: Finding table field. in Application Development and Automation Discussions

Finding table field.

Former Member — Wed, 20 Jul 2011 13:08:27 GMT

Can anybody suggest me table to get plant by using Vendor and Accounting document no. as it is not maintained in BSIK and BSAK table also the Accounting tables like BSEG,BSIS,BKPF etc.

Thanks IN advance!!!!!

Re: Finding table field.

Former Member — Wed, 20 Jul 2011 13:35:28 GMT

Start with VBFA.

Rob

Re: Finding table field.

Former Member — Thu, 21 Jul 2011 06:57:09 GMT

Hi,

But the thing is that VBFA does not content PLANT.

can u suggest me another table which contains any of following,

PRCTR,WERKS.

Selection parameteres should be LIFNR,BELNR from BSIK and BSAK Tables.

Re: Finding table field.

Former Member — Thu, 21 Jul 2011 07:45:48 GMT

Hi,

Use MSEG table you can get LIFNR,PRCTR,WERKS.

Pass the (BSIKand BSAK) Having field XBLNR number pass to mseg (MBLNR,MJAHR).

the XBLNR contains MBLNR,MJAHR combine thing.

Regards

Dhina..

Hi,

dont consider above one.

Best way is first pass the LIFNR and BELNR to BSIK and BSAK table

You can get BUKRS,BELNR and GJAHR and paas the Internal table to

BSEG with condition of BUKRS,BELNR and GJAHR in BSEG table contains

all the field PLANT,PRCTR,WERKS.

Hope is help full for you.

Regards,

DHina...

Edited by: Dhina DMD on Jul 21, 2011 9:57 AM

Re: Finding table field.

Former Member — Thu, 21 Jul 2011 13:21:39 GMT

You have the accounting document number, so you go to VBFA to get the material document and then to MSEG.

Rob