Make your own free website on Tripod.com
SAP Functional, ABAP Programming and Basis Components Books


Define Account Assignment Group

Field found in Material Master Sales Organization 2.

To define the General Leger 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 happend 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.

Back to Previous

Return to SAP Hints and Tips on Configuration and ABAP/4 Programming