HOW TO CREATE SAP BW DATA SOURCES FOR TDS REPORT?

[Former Member]

Hi All,

How to create generic data source for these fields?

I have TDS report these names and field.

Pls anyone guide me..

PAN NUMBER		J_1IPANNO
VENDOR NAME (accont type - k)		LIFNR
POSTING DATE		BUDAT
WITHHOLDING TAX  BASE		WT_QSSHH
WITHHOLDING TAX  AMOUNT		WT_QBSHH
NAME OF WITHHOLD TAX TYPE		WITHT

[RamanKorrapati · Accepted solution]

With help of functional team find tables for those fields.

later based on tables/views you can create a data source at RSO2.

even you can think about function module based data source also.

About generic data source you can explore more with help of google search.

[Former Member · Accepted solution]

Hi ,

Thanks for giving info.

How to add different tables in generic data source?

PAN NUMBER	J_1IPANNO	J_1IMOVEND
VENDOR NAME (accont type - k)		LIFNR	J_1IMOVEND
POSTING DATE	BUDAT	RBKP
WITHHOLDING TAX  BASE	WT_QSSHH	WITH_ITEM
WITHHOLDING TAX  AMOUNT	WT_QBSHH	WITH_ITEM
NAME OF WITHHOLD TAX TYPE		WITHT	WITH_ITEM

[RamanKorrapati · Accepted solution]

Hi,

how many tables fields you want?

thru view based data source we can club multiple tables if those have relations.

Other wise you can create  function module based generic data source.

Need abap expert to build required logic.

Have you gone thru existing generic data source concept on google?

Thanks

[Former Member · Accepted solution]

Thanks, I got it