topic Re: Billing table and tax code database table linking in Application Development and Automation Discussions

Billing table and tax code database table linking

ajimon — Wed, 09 Jun 2021 06:51:21 GMT

Hello,

I need to link Billing table [VBAK/VBRP] eith tax code table [T007S]. Anyone have the idea where I can find the linking information to generate Tax code wise sales report....

Thanks in advance...

Re: Billing table and tax code database table linking

FredericGirod — Wed, 09 Jun 2021 07:10:53 GMT

VBRP-MWSKZ did you search ?

Re: Billing table and tax code database table linking

ajimon — Wed, 09 Jun 2021 07:28:50 GMT

Hi frdric.girod

I already checked and see below data..I need MWSKZ filed to be included in report..

Re: Billing table and tax code database table linking

ajimon — Wed, 09 Jun 2021 08:17:56 GMT

Hi frdric.girod

Said field is blank in table VBRP.

Thank you.

Re: Billing table and tax code database table linking

FredericGirod — Wed, 09 Jun 2021 08:22:05 GMT

Don't loose your time, try to put a SQL trace /buffer trace using transaction ST05 it will gives you the access to this table with the value, you will be able to set a break point and go in the call stack to catch the link

Re: Billing table and tax code database table linking

ajimon — Wed, 09 Jun 2021 10:56:13 GMT

Hi,

I found relation in condition table - KONP -> MWSK1 ..

Thank you