cancel
Showing results for 
Search instead for 
Did you mean: 

Record in BSEG

Former Member
0 Kudos

Hi everyone,

I'm using a logical database for BSEG and populating a internal table with this information. then I copy that internal table into another and then I loop thru the first one to get a customer record that is not cleared and loop thru the second internal table to get the tax records that belong to the first record in the first loop base on the description and then the hard coded account number in my where condition of the second loop.

My question is, how can I relate my tax records with my customer record without using the text field?, and I have to mention that I'm looping thru records/items that are not cleared.

Thanks in advanced,

Gregorio

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

First I am making the assumption that you have two different data types and you don't have the common data types available. If true then when you create your internal table move the text field to a field "like" the customer. You'll need to first move it then shift it right then overlay with zeroes to get the two formats the same.

pls assign points as a way to say thanks.

Former Member
0 Kudos

Hi Dave,

Thanks for your help, but let me explain what I really need.

In my internal table I already have all the info that I need

The customer lines (Items) and the Tax lines (Items)

but If I have a document with, lets say, 28 records/lines/items and within those records I have 3 different customer records and there rest of the records are not customer records including the tax records.

How will I know which tax records belong to the corresponding customer record without using the text/description field?

Regards,

Gregorio

dominic_holdstock
Active Contributor
0 Kudos

Hi Gregorio,

If you only want the customer records that are currently not cleared, use Table BSID to select the records.

If you have a document with 3 different customer records which is tax relevant,there will not be a direct relationship between the customer and the tax record especially if the same tax code was used.The standard is to summarise the tax based on the code used.

regards