Skip to Content
0
Former Member
Feb 03, 2014 at 10:39 AM

Destination App help

23 Views

Hello Experts,

I am trying to get planned sales values from "SALES PLANNING" model, to "PRODUCTION PLANNING" model using "Destination App". Need your help in writing the the logic in the following scenario.

Product dimension in sales has three Products, which are to be clubbed as One Finished good in Production Planning model.

=> SALES MODEL (ACS-STD,ACS-NSTD,ACS-OMG) = PRODUCTION MODEL (FG_03).

=> I am trying to get values at plant level for all the products as one value of Finished Goods. PLANT1-> FG_003 ->2013.01->Plan->MT->6940

Sales Model Dimensions Production Planning Model Dimensions

------------------------------------ ----------------------------------------------------------

Account_Sales PP_ACCOUNT -> PP_0081

ACTIVITY_SALES -> ACT_112 UOM -> MT

Time Time

PLANT PLANT

RPTCURRENCY -> INR RPTCURRENCY -> LC

CATEGORY1 -> Plan CATEGORY -> Plan

P_ENTITY -> XYZ P_ENTITY -> XYZ

PRODUCT -> ACS-STD,

ACS-NSTD, PP_FG -> FG_03

ACS-OMG

DIVISION PP_RM -> RM_ALL

AUDITTRAIL -> Input PP_MG -> 301

FLOW -> Closing PP_SCHEDULLING-> PS_006

CUST_GROUP -> SG_NO

Products are grouped based on property called "FG" and Value "FG3".

Please find attachment of Sales model sample data

Thanks in advance

Praveen

Attachments