Online Tutorials & Training Materials | STechies.com
Register Login

Define Account Assignment Group

|| 2

Define Account Assignment Group
Stechies

Field found in Material Master Sales Organization 2.

To define the General Ledger Posting:-

IMG -> Sales and Distribution -> Account Assignment/Costing -> Revenue Account Determination -> Assign G/L Accounts

With this link, the material that used this account assignment group will be posted with the desired G/L accounts during Billing.

User will not be able to Release the billing document to Accounting if this is not setup.

If you happened to assign it via Cust.Grp/MaterialGrp/AcctKey, then you can let your user use this report to check the material assignment.

* Transaction code VKOA

REPORT ZMATNR_AC_ASSIGN LINE-SIZE 132 NO STANDARD PAGE HEADING LINE-COUNT 044(001).

TABLES: MARA, 

        MVKE,    "Sales Data for Material 

        C001.    "Cust.Grp/MaterialGrp/AcctKey 


SELECT-OPTIONS: S_MTART FOR MARA-MTART DEFAULT 'DIEN', 

           S_MATNR FOR MARA-MATNR, 

           S_VKORG FOR MVKE-VKORG DEFAULT 'ALL'. 


SELECT * FROM MARA WHERE MTART IN S_MTART 

                     AND MATNR IN S_MATNR. 

   CLEAR MVKE. 

   SELECT SINGLE * FROM MVKE WHERE MATNR =  MARA-MATNR 

                               AND VKORG IN S_VKORG. 


   CLEAR C001. 

   SELECT SINGLE * FROM C001 WHERE KTGRM = MVKE-KTGRM. 

   WRITE:/ MVKE-MATNR UNDER 'Material', 

           C001-KTGRD UNDER 'Cust Grp', 

           MVKE-KTGRM UNDER 'Matl Grp', 

           C001-KVSL1 UNDER 'Acct Key', 

           C001-SAKN1 UNDER 'G/L From', 

           C001-SAKN2 UNDER 'G/L To  '. 


ENDSELECT. 

TOP-OF-PAGE. 

FORMAT COLOR COL_TOTAL. 

    WRITE: / SY-DATUM, SY-UZEIT, SY-REPID, 

            050 'Material Sales Account Assignment', 

            120 SY-UNAME, SY-PAGNO. 

    SKIP. 

    WRITE: /001 'Material', 

            020 'Cust Grp', 

            030 'Matl Grp', 

            040 'Acct Key', 

            050 'G/L From', 

            060 'G/L To  '. 

    SKIP.


Comments

  • 05 Apr 2010 6:12 am
    Its very good and helpful for SD Trainee.
  • 08 Oct 2010 8:24 am
    very nice.....