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