Consequences of using existing QVW add new SAP raw data file

[paulyeo11]

Hi All

I have QVW file running fine. all raw data now currently are from syspro accounting software. In 1 Aug my account data will be from SAP. So all customer ID from syspro will need to change to SAP format. My question is if i make use of the existing QVW file to add SAP raw data. So that i have all the history data and new data from SAP.

Some of you may have experience before , kindly share your though on this.

Paul Yeo

[kakani87]

Will you be able to share some sample data from the two tables

[paulyeo11]

Hi Kakani

(1) OSAP is using SAP HANA, not SQL Server. To explore the fields you may go to bellows link.

1. a.       For Sales Order – Header (ORDR) - http://www.saptables.net/?schema=BusinessOne9.2&table=ORDR
2. b.      For Sales Order – Details (RDR1) - http://www.saptables.net/?schema=BusinessOne9.2&table=RDR1

(2) Below is the my existing sales order table from syspro accounting software :-

@314:343T as [desc],

@314:343T as [desc_key],

@43:48T as [inv],

@65:78T as [iDSE],

@50:60T as [date],

@107:120T as [quantity],

@121:133T as [cost],

@1:10T as [cust_id],

@1:10T as [CUST_ID],

@207:240T as [PRO_CLASS],

@97:100T as [pro_cls],

@150:166T as [PRODUCT_CODE],

@241:243T as [sign],

@299:306T as [gROUP],

@307:312T as [grouping],

@61:64T as [oDSE],

@83:86T as [sub_seg],

@79:82T as [sEG],

@344:354T as [date_sales],

@355:361T as [DO_NO],