Skip to Content
0
Former Member
Mar 04, 2009 at 09:55 AM

GDS

61 Views

Dear All,

I need to create a GDS having following requirement.

EKKO-KNUMV=KONV-KNUMV

Refer to the field KSCHL, match with the condition types as given against each attribute and fetch the value from the field KWERT

a. Total Excise Value (MTD/YTD) u2013considering BED(EXBED)AED(EXAED)ECS(ECS)+SECESS(EXADDTAX1) all from the table J_1IPART2

b. Total Tax Value (MTD/YTD)u2014BSEG-WMWST

c. Total Freight Value (MTD/YTD)u2014FRA1/FRB1/FRC1

d. Total CHA Charges (MTD/YTD)--ZCHA

e. Total Port Charges (MTD/YTD)- ZPOR

f. Total Custom Duty Value (MTD/YTD)--JCDB/JCDS/ZOA1/ZOB1/ZOC1

That means I have to use 4 tables: KONV,EKKO,BSEG,J_1IPART2

But KONV,BSEG are cluster tables therefore I cant use view for GDS.

Please advise how to create GDS.

Regards

Shweta