FI - Raghav - 2016-09-01 - 23923 - Spec - North America Retail inter company postings (Babu by 2016-09-30) #FICOSupport #Pending

SPECIFICATIONS

23923-Spec-North America Retail inter-company postings


Purpose

North America retail inter-company posting

Admin Info

Purpose
 North America retail inter-company posting
Requested By
 Babu
Spec Created By
 Raghav
Spec Created Date
 09/02/2016
Spec QA by
 Raghav
Objects
 ZFI_NAPYMT
ZFI_NACOM_CUS
ZFI_NACOM_PYMT
TDDAT
TVDIR
ZFI_NACOM_CUSS
ZFI_NACOM_PYMTS
ZFI_NA_INTERCOMPANY
Document Status
 WIP


Estimates


Sl.No
 Activity
 Estimation in Hours
1
 Research
 08
2
 Documentation
 06
3
 Development/ Config
 40
4
 Unit test in DEV
 30
5
 Unit test in QUA
 20
6
 Other activity

TOTAL

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]



Documents

[Attach any document(s) received for the requirement(s)]

Adjustment.xml


Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.
 Change Details
 Requested By
 Requested On
 Notes if any
1
 Add customer no. in reference field
 Babu
 11/08/2016
2
 Program should post the individual items as per the UPC given and UPC value should maintain in item text
 Babu
 11/08/2016
3
 Add AL11 path and background run to the program
 Babu
 11/15/2016










Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]

North America retail company code 0010 material doc posting to COGS A/c 518000 where the same value have to reverse in company code 0011 and transferred to company code 0010 or cocd 0020 with GL account 518000 as per the cost center available in XML file.

In Scope:

[List the activities to be included in scope]

Out of Scope:

[Out of scope activities]

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

Process flow for the posting the value from NA retail inter company from 0011 to 0010 or 0020 and from 0021 to 0010 or 0021

Record F-02

S. no.
 Fields pulled from XML
 Logic
1
 Company code
 Pick cost center from field doc_reason_code in XMl and input in table CSKS-KOSTL and get the company code CSKS-BUKRS
2
 Material
 Input UPC from XML in table MEAN-EAN11 to get material MEAN-MATNR
3
 Standard cost of material
 Input material in MBEW-MATNR and valuation area(if cocd0010 then 0110 and if cocd0020 then 0210) to pull the standard price MBEW-STPRS
4
 Material quantity and value
 Multiply the standard cost of material with orig_value(quantity) from XML to get the COGS value must calculate for all items




SAP input fields in F-02
5
 SAP Transaction for posting
 F-02
6
 Document date and posting date
 Give document and posting date from XML post_date
7
 Document type
 Document type always SA
8
 Company code
 Company code from point 1
9
 Currency
 Currency default to Company code currency
10
 Posting key and Gl account
 Screen 1 posting key should be 40 and gl account hard code as 518000
11
 Amount
 Total calculation of the amount from point 4
12
 Cost center
 Input cost center from doc_reason_code in XML
13
 Posting key, Gl account and Company code
 Posting key should be 50 and gl account 518000 and new co cd is 0011 hard code
14
 Amount
 Amount same as point 4 and 12
Maintain path in program ZFI_NA_INTERCOMPANY
/usr/sap/NEP/RETAIL/IN/ to automatically process all the files and move to archive.

Test Plan

[List test scenarios/cases to be executed here]


Inter company posting have to process as the company code, store id and subsidary no.
Test ID
 Test Scenario
 Expected Results
FI-001
 Retail inter company postings from 0011 to 0010 or 0020
 As per the input XML file value of material in cocd 0011 or 0021 should post to 0010 and 0020 as per the store and subsidery number.
All file in directory should run at once in background
FI-001
 Retail inter company postings from 0021 to 0020
 As per the input XML file value of material in cocd 0011 or 0021 should post to 0010 and 0020 as per the store and subsidery number.
All file in directory should run at once in background
Inter company file should be archive once processed in background
Test ID
 Test Scenario
 Expected Results
FI-001
 Retail inter company postings from 0011/0021 to 0010 or 0020 with input path in selection screen and all file run in background
 As per the input XML file value of material in cocd 0011 or 0021 should post to 0010 and 0020 as per the store and subsidery number.
All file in directory should run at once in background and move to archive
FI-002
 Retail inter company postings from 0011/0021 to 0010 or 0020 with singlle file input path in selection screen and file run in background
 As per the input XML file value of material in cocd 0011 or 0021 should post to 0010 and 0020 as per the store and subsidery number.
File in directory should run in background as per the input and archhive

Solution Details

[Provide complete technical details for configuration or programming here]



Issues

[List Issues / Bugs identified in configuration or development]