2013-03-15 - 5910.100 - Spec - Contract #SalesDistribution
SPECIFICATIONS
5910.100 - Contract
Requirement Summary
1. Include time characteristics in contract cube and copy contract requested delivery date(0REQ_DATE) to its corresponding call offs.
2. Create new MultiProvider to meet requirement of some contract reports.
3. Create new Process Chain to load Contract InfoCube daily in NBQ & NBP.
4. Add separate Meta Chain to load Order Header Status DSO to Sales Order Process Chain.
Admin Info
Purpose
|
Change Contract Source and create new Multiprovider.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Chandramouli K
|
Spec Created Date
|
03/16/2013
|
Spec QA by
|
Uday Kumar P
|
Objects
|
Contract InfoCube(ZSD_CONTR) and MultiProvider (ZMP_OOCON),
Process Chain to load Contract InfoCube (ZPC_CONTRACT),
Process Chain to load Order Header DSO (ZPC_ORDER_STATUS).
|
Document Status
|
Complete
|
References
Prior Tickets
5910.600
4674.700
2012-09-27 - 4674.700 - Spec - BW Performance (Contract Infocube)
Documents
MultiProvider Fields ZMP_OOCON.xls
Functional Requirement
1. Need to include time characteristics in contract cube to meet the crystal report requirements.
2. Need to copy contract requested delivery date(0REQ_DATE) to its corresponding call offs to so that open contracts fall in correct fiscal year bucket in report.
3. Need to create new Multiprovider to meet the requirement of contract reports where we need to combine contract information with open orders.
4. Need to create a new Process Chain to load Contract InfoCube daily in NBQ & NBP.
5. Need to create a new Process Chain as Meta Chain to load Order Header Status DSO.
Solution Summary
1. Include time characteristics in contract cube and map these fields from requeted delivery date.
2. Include logic in start routine to copy contract's requested delivery date to its corresponding call offs.
3. Create a new MultiProvider with Open Order Cube and Contract Cube and related BEx queries.
4. Create a new Meta Chain to load Contract InfoCube and include this Meta Chain in Sales Order Process Chain(ZPC_SALES_ORDER).
5. Create a new Meta Chain to load Order Header Status DSO and include this Meta Chain in Sales Order Process Chain(ZPC_SALES_ORDER).
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check Fiscal Year, FiscalYear/Period and Posting Period values in contract cube.
|
Requested delivery date should be split into Year, Year /Period, Posting Period.
|
2
|
Check Requested Delivery Date of Contract copied to all its call offs.
|
Requested delivery date should be copied to all its call offs based on call off reference document, material and grid value OR Contract requested delivery date to all its call offs based on Reference Document Number and Item.
|
3
|
Check if the new meta chain is successfully loading data into contract infocube along wiht proper indexing.
|
New meta chain is successfully loading the contract infocube along with creating and deleting the infocube indexes.
|
4
|
Check if the new meta chain is successfully loading data into Order Header Status DSO.
|
New meta chain is successfully loading the Order Header Status DSO.
|
Solution Details
1. We have to include time characteristics(0FISCYEAR, 0FISCPER, 0FISCPER3 & 0CALDAY) in contract cube(ZSD_CONTR)
2. Map these new fields from requested delivery date(0REQ_DATE) in transformations of Sales Order DSO to Contract infocube.
3. We have to include logic in start routine to copy contract's requested delivery date(0REQ_DATE) to its corresponding call offs.
4. We have to create a new MultiProvider with Open Order Cube(ZSDC_OPN) and Contract Cube(ZSD_CONTR) and related BEx queries.
5. We have to create a new Meta Chain to load Contract Infocube and included this Meta Chain in Sales Order Process Chain(ZPC_SALES_ORDER).
6. We have to create a new Meta Chain to load Order Header Status DSO(ZSD_O09).
Issues
1. In R/3 side, NEC has to change the Requested Delivery Dates of Open Contracts to Current Year every year OR they need to change configuration settings, for this report requirement.
2. New Meta Chains cannot be tested in NBD, so need to be moved into NBQ for testing & performance analysis.