FICO - Raghav - 2017-07-06 - 46163 - Spec - ABAP SAP ordes replinish inventory to retail stores post to clearing accounts (Babu by 2017-08-25) #wipdoc

SPECIFICATIONS

46163-Spec-SAP ordes replinish inventory to retail stores post to clearing accounts


Purpose


Free of charge orders will fulfill the inventory (replenish inventory) to the retail stores, deliveries shipments in SAP to retail store to post to retail clearing account.

Admin Info


Purpose
SAP ordes replinish inventory to retail stores post to clearing accounts
Requested By
Babu
Spec Created By
Raghav
Spec Created Date
07/06/2017
Spec QA by
Raghav
Objects

Document Status
WIP

Estimates


Sl.No
Activity
Estimation in Hours
1
Research
08
2
Documentation
08
3
Development/ Config
40
4
Unit test in DEV
40
5
Unit test in QUA
40
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)]



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

























Functional Requirement


Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]
Free of charge orders will fulfill the inventory (replenish inventory) to the retail stores, deliveries shipments in SAP to retail store to post to retail clearing account.

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]

Steps
Getting Data
Logic
Step 1
Custom program Screen
GL Account (mandate) must be used for clearing account


Screen input field Customer (Optional) if only customer is given then logic is from step 3


Delivery creation date (Optional only if customer is given)


Delivery number (Optional) Logic will be from step 4 point 2



Step 2
Material documents
Input creation date in MKPF-CPUDT and pick material documents MKPF-MBLNR and year MKPF-MJAHR



Step 3
Material documents as per customer
Input material documents MKPF-MBLNR and year MKPF-MJAHR in MSEG-MBLNR and MSEG-MJAHR and Customer in MSEG-KUNNR to pick the customer relevant material documents



Step 4
FI DOC
1) Pass GR+fiscal year(MKPF-MBLNR + MKPF-MJAHR) in reference key BKPF-AWKEY to get the FI DOC BKPF-BELNR and CoCd BKPF-BUKRS


2) If delivery doc is given in selection screen then pass it to Reference field BKPF-XBLNR to get the FI DOC BKPF-BELNR and CoCd BKPF-BUKRS



Step 5
SAP COGS value
Input FI doc BKPF-BELNR, FY BKPF-GJAHR and CoCd BKPF-BUKRS in FI doc BSEG-BELNR, FY BSEG-GJAHR and CoCd BSEG-BUKRS to get the COGS value BSEG-WRBTR with gl account 510000 BSEG-HKONT and check debit/credit firld BSEG-SHKZG



Step 6
Reversal Post with custom program
Post the G/L document in FB50 with FI doc BSEG-BELNR, FY BSEG-GJAHR and CoCd BSEG-BUKRS to get the COGS value BSEG-DMBTR with gl account 510000 BSEG-HKONT if the debit/credit field BSEG-SHKZG is 'H' then in FB50 post as 'S' else vise varsa and reversal clearing GL will be from selection screen

Note:-
To avoid duplicate postings input BKPF-BELNR + BKPF-BUKRS + BKPF-GJAHR(2 digits)) in reference BKPF-XBLNR (for Eg: Reference = FI doc no.(10)+company code(4)+yearYY(2)) from step 4 while posting clearing account, then at step 4 validate the account document+cocd+year with the reference document if available then skip the entry else post the entry

Test Plan

[List test scenarios/cases to be executed here]
Test ID
Test Scenario
Expected Results







Solution Details


[Provide complete technical details for configuration or programming here]


Issues


[List Issues / Bugs identified in configuration or development]