Need small information obb8 Where data is saving (sales Text)

[former_member196331]

I have small problem,

I need to fetch the data from the OBB8, So, i checked And found the Table names As.

T052,T052U And TVZBT.

But What i am facing the problem is

Own Explanation i was found in T052U ,  With the combination of Payment Terms and Day limit.

Sales text i was found in TVZBT,  With only payment Terms combination,

But Where  Sales text is going to Save  With combination Of  Payment Terms and Day limit.

[VeselinaPeykova · Accepted solution]

I am not completely sure what you are trying to achieve (probably you are working on invoice printout), but you can have a look at how the texts are determined in FM SD_PRINT_TERMS_OF_PAYMENT.

[former_member196331 · Accepted solution]

Hi, Thanks for your reply.

As per the Screen  Please have a look on below Example.

Payment terms	Day limit	Sales Text	Own Explanation
1	10	Sales Text1	Explanation1
1	20	Sales Text2	Explanation2

In the above How could i Capture Sales Text With Respect to the payment terms and Day limit.

Explanation has given with the payment terms and Day limit Combination.

I am developing a small report

[VeselinaPeykova · Accepted solution]

Did you have a look a the function module?

Payment term 0003:

I passed the dates from a document, language, payment terms and got this:

You are writing an ABAP report, so you can understand better than me by examining the code how they output such data with the FM.

[former_member196331 · Accepted solution]

Ok i will check it. Give me some time.

[former_member196331 · Accepted solution]

I checked the Function module. In the Function module I given payment terms only. then the data is coming it's means sales text.

I hope i am not irritating to you, I Explained Well. i am unable to check it in my system means.

Payment terms with two different day limit does not exists in my system. But i would like to know How others are fetching data from the Sap.

Ok.

Suppose if a payment terms having sales text  with two diff day limit

Example: Suppose in a office two persons are working Ramu, Again Ramu Ok, Some body came and asking the front office execute,

               (Ramu home town is newyork)(another Ramu home town is rome)

               i would like to meet Ramu. like

              Select * from office_Staff where emp_name eq 'Ramu'.   So, Two employees names will come.

             What you given the Function module,  Employee name is nothing but payment terms in your function module.

             Executive Told to visitor that, Which ramu you would like to meet. then immediately he reply Ramu he is from Rome.
             then

             Select  * from office_staff where emp name eq 'Ramu' and hometown eq 'Rome'.

             In your function module empname is Payment terms, and Where is Daylimit(hoemtown) . If selection screen(means Fm input parameters)
             Does not have the day limit how it will be fetch the data.
    

[VeselinaPeykova · Accepted solution]

What do you mean by day limits? TAGE from my second screenshot or something else?

The sequence of lines in the result is the same as in OBB8 if you look closely at the payment term definition.

If you meant TAGE or HDATUM,

Then you get:

And you already know how to get the sales text from TVZBT with the same payment term, just combine the whole info in one place.

[former_member196331 · Accepted solution]

Dear Madam,

Can You please Run the table T052U.

Why they given the field Day limit.

Can You please Run the Table TVZBT.

Why they have not given the field Day limit.

This is My Question.

[VeselinaPeykova · Accepted solution]

It is a very common case not to get all the information that you need for a report in a single table.

I am working for a SAP partner, so I cannot provide much insight how solution design is done in SAP AG, but it makes sense to me not to store in the database language-dependent texts valid for the header on item level.

It will be easier for you to understand the idea of the current solution and create the report if you ask your in-house FI functional consultant to explain to you payment terms configuration and how each field is used in more details.

[former_member196331 · Accepted solution]

Ok........