FI AP- Master Data

download FI AP- Master Data

of 16

Transcript of FI AP- Master Data

  • 8/18/2019 FI AP- Master Data

    1/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    ACCOUNT PAYABLEMASTER DATA

  • 8/18/2019 FI AP- Master Data

    2/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    ContentsOverview ......................................................................................................................................... 3 

    1. Vendor master data creation ...................................................................................................... 3 

    1.1 Vendor master data creation (Client level) ............................................................................... 3 

    Result ...................................................................................................................................... 6 

    1.2 Vendors master data creation Company code data: ................................................................ 7 

    Procedure ................................................................................................................................ 7 

    Indicator for withholding tax type ........................................................................................... 10 

    Result .................................................................................................................................... 10 2. Updating Vendor Master Data .................................................................................................. 11

    2.1 Change Vendor master data: ................................................................................................. 11 

    Result .................................................................................................................................... 12 

    2.2 Block/ Unblock Vendor ........................................................................................................... 12

    Use ........................................................................................................................................ 12 

    Procedure .............................................................................................................................. 12 

    Result .................................................................................................................................... 13 

    2.3Set Deletion Indicator For Vendor ........................................................................................... 14

    Use ........................................................................................................................................ 14 

    Procedure .............................................................................................................................. 14  Appendix ....................................................................................................................................... 16 

    Miscellaneous Steps ............................................................................................................. 16 

  • 8/18/2019 FI AP- Master Data

    3/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    OverviewThe master records of Vendors consist of general data section and a company codespecific section.Vendor master record contain the data generally on the client view and the specific dataon company code view are such as reconciliation account, payment methods andpayment terms.

    1. Vendor master data creation1.1 Vendor master data creation (Client level)

    Transaction code

    FK01 - Create vendor master data

    Use

    Vendor master data creation.

    Procedure

    1. Access the transaction choosing one of the following navigation options:

    SAP ECC menu  Accounting   Accounts Payable  Master Records  Create

    Transaction code FK01 

  • 8/18/2019 FI AP- Master Data

    4/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    2. On the List : Initial Screen, make the following entries:

    Field name DescriptionUser action

    and valuesComment

     Account group Vendor accountgroup

    Example: EGY

    egy vendor

    account group

    The account group is a

    classifying feature within

    vendor master records. 

    3. Press enter and update the following:-

  • 8/18/2019 FI AP- Master Data

    5/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    Field name Description User action and values Comment

    Title Enter the Title of the vendor Example: Company

    Name Enter Vendor Name Example: Ahmed Shalaby

    Search Term Enter Search Term Example: Kafafy

    Street Enter Address Example:

    Country Country of Vendor Example: EG

    Telephone Vendor Telephone Number Example:

    Fax Vendor Fax Number Example:

    Press

  • 8/18/2019 FI AP- Master Data

    6/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    Field

    nameDescription

    User action and

    valuesComment

    Customer Customernumber

    Example: Company Enter Customer number if this vendor is a

    customer at the same time 

    Tax Office Tax Office Example: xxxxxxxxضيببط قة

    TaxNumber 2

    Tax Number 2 Example: xxxxxxxxسجل تج رى

    Press

    Enter Vendor bank details in this screen just for information then press save .

    Result

    Now the vendor master data created centrally (General data)

  • 8/18/2019 FI AP- Master Data

    7/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    1.2 Vendors master data creation Company code data:

    Procedure

    1. Access the transaction choosing one of the following navigation options:

    SAP ECC menu  Accounting  Financial Accounting  accounts payable  Master

    Records  Create

    Transactioncode

    FK01 - Create

    2. On the List : Initial Screen, make the following entries:

    Field name DescriptionUser action and

    valuesComment

    Vendor Vendor account numberExample:

    100000076

    The vendor

    number created

    at the general

    level

    Company

    code

    Enter company number1010

    2. press create and update the following:

  • 8/18/2019 FI AP- Master Data

    8/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    Field name Description User action and values Comment

    Recon. Account  AP. General Ledger Account 28000000 Required

    Head Office Vendor Head Office Account No. Optional

    Sort Key Used to Sort Posted Line Items Optional

    Cash Mgmt. Group Used in Cash Management Reports K1 Required

    Press and update the following:

    Field name Description User action and values Comment

    Term of paymentKey for defining payment termscomposed of cash discountpercentages and payment periods 

    0001 Required

  • 8/18/2019 FI AP- Master Data

    9/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    Press and update the following:

    Field name DescriptionUser action and

    valuesComment

    WH Tax

    CountryWithholding Tax country

    Example: EG

    001

    Wth.t.typeIndicator for withholding tax type Example: 01

    W/taxcode Withholding tax code  Example: 01

    Liable Indicator: Subject to withholding tax Flag the check

    box

  • 8/18/2019 FI AP- Master Data

    10/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    6. Press save 

    Result

    The Vendor master data was created at the company code level.

  • 8/18/2019 FI AP- Master Data

    11/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    2. Updating Vendor Master Data

    2.1 Change Vendor Master Data

    SAP ECC menu  Accounting  Financial Accounting   Accounts payable  Master

    Records  Changes

    Transaction code FK02 - In Chart of Accounts & Company Code

  • 8/18/2019 FI AP- Master Data

    12/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    Select the tab you need to change at the General level.

    Select the tab you need to change at the company code level.

    Result

    The Customer Master record changes are done, and applied.

    2.2 Block/ Unblock Vendor

    Use

    This Transaction Code is used to set, or remove the blocking indicator per vendor accountnumber either per the selected company code, or all over the company codes the account iscreated for.

    Procedure

    1. Access the transaction choosing one of the following navigation options:

    SAP ECC menu  Accounting   Accounts Payable  Master Records  Block /

    Unbolock

    Transaction

    code

    FK05

  • 8/18/2019 FI AP- Master Data

    13/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    2. Enter  the Vendor Account Number, and the Company Code to be ‘Block/ Unblocked’ for.  

    3. Press ‘Enter’ to proceed to the next screen Vendor Block/Unblock: Details Accounting. 

    4. Select the Blocking/ Unblocking level to be considered, and Press the ‘Save’ button 

    The Blocking indicator is used to block and prohibit the posting of transactions to thevendor account.

    Result

    The Vendor Master record blocking is done, and applied.

  • 8/18/2019 FI AP- Master Data

    14/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    2.3 Set Deletion Indicator for Customer

    Use

    This Transaction Code is used to set, or remove the deletion indicator per vendor accountnumber.

    Procedure

    1. Access the transaction choosing one of the following navigation options:

    SAP ECC menu  Accounting   Accounts Payable  Master Records  Set Deletion

    Indicator

    Transaction code FK06

    Setting the deletion flag is to be used for identifying the master records to be archivedthrough and archiving program run for the master records that have no dependent data.

    Setting the deletion flag is to be used for identifying the master records to be deletedthrough the master data deletion program ONLY in a test environment.

  • 8/18/2019 FI AP- Master Data

    15/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    Deletion Flags

      All Areas: Identifies that all the vendor created data views; i.e. General Data, andCompany Code Data are to be deleted. 

      Selected Company Code: Identifies that ONLY the selected company codeCompany Code Data is to be deleted. 

    Deletion Blocks 

      General Data: Identifies that the General Data may not be deleted.

      Selected Company Code Incl. General Data: Identifies that the both the CompanyCode Data and General Data may not be deleted.

    2. Apply the required changes, and Press the ‘Save’ button for them to take effect. 

  • 8/18/2019 FI AP- Master Data

    16/16

     

    Corniche El Maadi,7 El MOhandseen Towers, floor 22 Beside Al nile Badrawi 

    SAP Courses

    Tel:01011989971 - 01275758729

    [email protected]

    www.alliedconsulting.com.eg

    Appendix

    Miscellaneous StepsIn the following section, you can find the most common steps, which you can take in some of theactivities described in this document.

     

    Function Description

    Transaction code ( SAP GUI) FK03

    Comments Display vendor master data

    Funct ion Description 

    Transaction code ( SAP GUI) 

    Comments