Report to fetch the text information from customer master sales data

[Former Member]

Dear Experts,

We have come up with a requirement where the business want a report/list of the customers for whom a particular text is not maintained in customer master -sales data.

There are many Z text id are configured and are maintained in Sales data- extras- text. In addition, business also need some key fields from the customer master such as name, city, delv plant, payment terms, sales off, sales grp etc.

I could not get any standard table where the text is maintained with the customer numbers. Table STXH can give the customer numbers for a particular text id type but what is maintained against the given text id is not fetched from the table.

So we need the valuable inputs to realize the requirement.

As an proposal, we are aiming to develop custom Z report with the FM READ_TEXT to get the text information with the customer no ( object type KNVV and text id ). But for the additional information, what should be the actual logic for fetching the data. say if this FM is used, what should be the sequence of the logic and ideal selection parameters.

In addition, we aim to use BAPI BAPI_CUSTOMER_GETDETAIL2 to fetch some of the customer ifnormation but many fields are not found in this . can we use some other bapi which can provide the complete general/sales data of customer ( delv plant, sales off, sales grp, custo grp, incoterms, payment terms etc)

Kindly suggest accordingly.

Many thanks in advance.

[Former Member]

Thanks. Done.

[Former Member]

Hi Dharmendra Kumar,

I guess the best would be to check in ABAP General forum on the READ_TEXT sequence/ logic etc..

For customer details, the available BAPIs are:

BAPI_CUSTOMER_GETDETAIL

BAPI_CUSTOMER_GETDETAIL1

BAPI_CUSTOMER_GETDETAIL2

However, you might have to check classes in SE24 to find any existing classes and its method yo give you all the information of a customer. Also check this thread: [;

Regards,

Raghu.