Monday, 22 March 2021

Necessary Changes in S/4 HANA MM Point of View( Interview Q & A )

 SAP ECC Vs SAP S/4 HANA ( MM point of View ):-

There some Major changes in SAP S/4 HANA.

  1. Material code Length is increased from 18 to 40 digit or in word.
  2. Material ledger is a new things.
  3. Vendor master, Customer master data creation, changes & display transaction code has been obsoleted  instead of that only one T-code has been given in S/4 HANA which is T-code - BP( Business Partner ).
  4. Material document table has been added a new table which is MATDOC.
  5. you will get real time inventory.
  6. New table PRCD_ELEMENTS is replacing the KONV table.
  7. KONV is empty in S/4 HANA. Unlike MKPF, BKPF which are still populated for new transactions in S/4 HANA along with MATDOC and ACDOCA tables, KONV/KONP are not populated at all, neither for the old data nor for new transaction data. PRCD_ELEMENTS is the single source of truth for condition records.
  8. The database layer is now clearly separated. Access to it has to be channeled through newly provided APIs and a CDS view.
  9. Material movement transaction code has been obsoleted.All the material movement will be done through MIGO only.
  10.  we can Maintain Multiple currency in a single ledger.
Material Ledger:-

Material Ledger is a tool used to manage your inventory in multiple currencies and/ or perform multiple inventory valuation. It allows the client to manage its inventory in three currencies which is previously (when Material Ledger is not activated) being manged in only one currency with legal valuation.

Configuration step of Material Ledger:-

Activation of Material Ledger is mandatory on S/3 HANA due change in the data design for Inventory valuation but activation of actual costing is not mandatory on SAP S/4 HANA.

Below mentioned screen shot prescribes traditional Inventory management Vs S/4 HANA Inventory management based on Material ledger.

sdad

Material Valuation in SAP S/4 HANA allows Up to 3 currencies,

  • Tracking historic rates in Material master.
  • Local legal valuation & e.g hard or trading currency.

Actual Costing:

  • Optional revaluation of stock and COGS
  • Leverage Actual cost component

Activate Material Ledger

as

ADVERTISEMENT
REPORT THIS AD

We activate the Material ledger for one or more valuation areas, if the material ledger is active for a particular valuation area, all materials in the valuation area are valuated using the material ledger.

But SAP recommends if you activate the material ledger for a plant, you should also activate it for all the other plants in the company code. This ensures that the accounts in Financial Accounting and Materials Management are reconciled.

Activate Valuation Area’s for Material Ledger:

ax

In this activity, you can specify in each valuation area that a planned price is activated as the valuation price upon the first goods movement in a new posting period as long as the validity date of the planned price has been reached.

The planned prices are handled by the system with the following priority:

  • Marked standard cost estimates
  • Future valuation prices

Actual Costing:

Inventory and material movements are generally valuated either at Standard price (S) which is constant over a period of time or Moving average price (MAP) which gets adjusted (calculated) automatically based on every Goods receipt or Invoice receipt. Both of these two methods have their own pros and cons. Actual costing combines the advantages of standard price with advantages of using MAP.

ML captures all price variances (like purchase price variances, production variances etc) and allows (as optional period end activity) revaluation of ending inventories at period end and releases it as standard price (generally) for next period. Actual costing is optional in S/4 HANA.

Activate Actual Costing:

2016-08-01_105428

2016-08-01_105341

Depending on which activation type is chosen

  • Actual consumption is updated in the quantity structure but not considered by price determination.

You can use this setting if you simply want information about the complete actual quantity structure. You can assign variances between the plan price of the cost center/activity type or process, and the actual price calculated at period end to the particular cost object at period-end closing using the function ‘Revaluation at Actual Prices’.

  • Actual consumption is updated in the quantity structure and taken into account for the price determination.

If you choose this setting, the variances between the plan price and the actual price are adjusted subsequently. The cost center or the process is then credited and the material associated with the consumption is debited. In the context of multi-level price determination, these variances can be rolled up through the production structure up to the finished product in the same way that material price variances are rolled up.

If you choose this setting, you cannot use the function ‘Revaluation at Actual Prices’ at period closing in Cost Object Controlling, as the variances from the cost centers/processes are debited to the material direct. If you do use the function ‘Revaluation at Actual Prices’ at period closing, the cost centers/processes are credited twice and the materials are debited twice.

We have to keep below mentioned points during Migration of Material Ledger Customizing:

Key Points:

  • The material ledger is required if you are using SAP S/4 HANA Materials Management – Inventory Management (Simplified Logistics).
  • You need to migrate the material ledger even if you are already using SAP Simple Finance (that is, you are migrating from SAP Simple Finance to SAP S/4 HANA Inventory Management).
  • You need to migrate the material ledger even if you are already using the material ledger in your source system.

Business Partner:-
  1. Define BP Role
IMG menuSPRO-Cross-Application Components ® SAP Business Partner ® Business Partner ® Basic Settings ® Business Partner Roles ® Define BP Roles
Transaction code FI_APAR_SEPA_CUST or BUCG

 

BP RoleTitleDescription
000000Business Partner (Gen.)Business Partner (Gen.)
FLVN00FI Vendor *Business Partner Vendor
FLVN01Purchase Vendor *Business Partner Supplier

Check if not exist, create. Normally even though 000000 is a standard not exist.

These are like our ECC General data, Company code data and Purchasing data

*Note: Change the Title description as per your need. We changed text for easy understanding

  1. Define Number Ranges for BP Group
IMG menuSPRO-Cross-Application Components ® SAP Business Partner ® Business Partner ® Basic Settings ® Number Ranges and Groupings ® Define Number Ranges
Transaction codeBUCF

 

NoFrom No.To NumberExt
0100100000000019999999
020020000000029999999
03CZA000001CZA999999X
04G0001GZZZZX

Here we assign number ranges for each BP Group (like Local / Foreign Vendor). Same we did in ECC.

Note: Define number ranges as per your business requirement. I have taken only Four. As per business need we can keep internal or external without any clash

  1. Define Groupings and Assign Number Ranges
IMG menuSPRO-Cross-Application Components ® SAP Business Partner ® Business Partner ® Basic Settings ® Number Ranges and Groupings ® Define Groupings and Assign Number Ranges
Transaction codeBUC2

                                 

Field NameEntry 1 Entry 2
GroupingBP01BP02
Short NameLocal VendorForeign Vendor
DescriptionInternal Local VendorInternal Foreign Vendor
Number range0102
Externalleave emptyLeave Empty
Int. Std. Grpingleave emptyleave empty
Ext. Std. Grpingleave emptyleave empty
Hideleave emptyleave empty

 

Field NameEntry 1 Entry 2
GroupingBP03BP04
Short NameLocal Emp  VendForign Emp Vend
DescriptionExternal  Local Employee VendorExternal Foreign Employee Vendor
Number range0303
ExternalXX
Int. Std. Grpingleave emptyleave empty
Ext. Std. Grpingleave emptyleave empty
Hideleave emptyleave empty

Likewise, as per business requirement make no. ranges and assign as shown if you more requirement.

Note:i).  Internal Std. Grouping can be done for ONE role only. Whatever role you select here as Internal Std. Grouping, that role will be selected automatically at the time of BP Creation (in Master data creation- transaction) if you didn’t select any role.

Note :ii) As Standard SAP, at least ONE internal std. grouping to be defined. SAP note: 2344905– BP cannot be created from Customer due to error R11124

This means that Standard group will be default if we didn’t select any value.

  1.  Configure field attributes per client
IMG MenuCross-Application Components ® SAP Business Partner ® Business Partner ® Basic Settings ® Field Groupings ® Configure Field Attributes per Client
Transaction CodeS_A2C_40000180

 

Double-click Configure Field Attributes for Each Client.

On the Change View “Field Grouping Client-Wide”: Overview screen, create the following settings:

Create the following settings:

Configure Field Attributes per BP Role: BP Role : BUPA
Double click BUPA à Double click Central Data

  • Set Organization: Name 1 to Req.entry
  • Set Person: Last Name to Req.entry

  1. Configure field attributes per BP Role
IMG menuCross-Application Components ® SAP Business Partner ® Business Partner ® Basic Settings ® Field Groupings ® Configure Field Attributes per BP Role
Transaction codeBUCG

 

Double-click Configure Field Attributes for Each Role Category:  FLVN00 and FLVN01

On the Change View “Field Group BP Role”: Overview screen, choose data correct data set

We made following fields as mandatory.

FLVN00 >>Vendor: General Company Code >> make mandatory fields : Reconciliation acct, Sort key and check Double Invoice

FLVN01 >> Vendor: Purchasing>> make mandatory fields : Vendor: Purchase Order Currency, Vendor: Terms of Payment

Likewise, you can do as per your requirement in other roles and data sets

Each field is assigned with field group no. Even though some data set description not showing it has field groups assigned to it.

 

  1. Bringing non visible fields in BP Role screen and making mandatory

Sometimes we didn’t find fields in BUCG screen. Like Schema Vendor Group (Schema Group Supplier- LFM1-KALSK) is not visible in screen. It is hidden / missing in FLVN01 BP role. Follow below steps to bring that field on screen

BUCG initial screen

Above missing Field group description and Data set description missing can be done based on Note: 2332494 – Field Groups and Data sets Description missing for the fields developed for customer and vendor functionality

Step A:  Define Field group description in BUS2. Click on New entries

Step B: In BUS2

Please make sure ‘Not a req. field’-flag is not set. After that the customizing in SPRO can be made for the required field

Select 3352 field group >> Field Group -> Fields

Step C: Define data set description in BUS23

Step D : In BUCG make that field mandatory

 

  1. If field group is assigned two fields and want to make one field mandatory

2032 field group is common for GR-Based Invoice Verification (LFM1-WEBRE) and Free Goods (LFM1-NRGEW)

If requirement is GR Based Invoice verification is to be made mandatory, but Free goods is not mandatory.

Step A: in BUS2 do setting as shown

Step  B: BUCG do mandatory as shown

 

  1. Maintain form of address
IMG PATHCross-Application Components ® SAP Business Partner ® Business Partner ® Basic Settings ® Forms of Address ® Maintain Forms of Address
T-CODES_ABA_72000037

 

User ActionKeyTitlePersonOrg.Grp.Gender
Create0001Ms.XX2 Female
Create0002Mr.XX1 Male
Create0003CompanyXGender not known
Create0004Mr. and Mrs.XGender not known
Create0005Mrs.XX2 Female

 

  1. Define Identification types
IMG MenuCross-Application Components ® SAP Business Partner ® Business Partner ® Basic Settings ® Identification Numbers ® Define Identification Types
Transaction CodeS_A2C_40000110

 

On the Change View “Identification Types”: Details screen, create the following settings, if not exists. Normally all will exist.

  1. ERP Customer / Vendor Account group settings

 

Here we will map BP with our ERP vendor

IMG PATHFinancial Accounting (New) ® Accounts Receivable and Accounts Payable ® Vendor Accounts ® Master Data ® Preparations for Creating Vendor Master Data ® Create Number Ranges for Vendor Accounts
TCODES_ALR_87003103

 

Here we will make all vendor no. ranges as external. Take the same number range which we defined at BP Group no. ranges BUCF

This is the same what we are doing in ECC

 

  1. Define Account groups with screen layout (Vendors)
IMG PATHFinancial Accounting (New) ® Accounts Receivable and Accounts Payable ® Vendor Accounts ® Master Data ® Preparations for Creating Vendor Master Data ® Define Account Groups with Screen Layout (Vendors)
TCODES_ALR_87003126

 

Account GroupNameOne-time accountField Status
Z001Local VendorSet for all fields the status to “Optional entry”
Z002Foreign VendorSet for all fields the status to “Optional entry”
Z003Employee Vendor LocalSet for all fields the status to “Optional entry”
Z004Employee Vendor ExpatriateSet for all fields the status to “Optional entry”

 

  1. Assign No. range to Vendor account groups
IMG PATHFinancial Accounting (New) ® Accounts Receivable and Accounts Payable ® Vendor Accounts ® Master Data ® Preparations for Creating Vendor Master Data ® Assign Number Ranges to Vendor Account Groups
TCODES_ALR_87003201

 

GroupNameNumer range
Z001Local Vendor01
Z002Foreign Vendor02
Z003Employee Vendor Local03
Z004Employee Vendor Expatriate04

 

  1. Activation Switch for Functions
IMG MenuCross-Application Components ® SAP Business Partner ® Activation Switch for Functions
Transaction CodeS_ABA_72000243

 

User ActionDevelopmentActiveDescription
Set to activeBUT020XTime Dependency BP Addresses
Set to activeBUT0BKXTime Dependency BP Bank Data
Set to activeBUT100XTime Dependency BP Roles

 

 

  1. Activate Function Modules
IMG MenuCross-Application Components ® SAP Business Partner ® Data Distribution ® Activate Function Modules
Transaction CodeS_ABA_72000207

 

User ActionEvenetObjectItemFunction moduleCall
CreateMERGEBUPA1000000MERGE_BUPA_CENTRALX
CreateMERGEBUPA2000000MERGE_BUPA_FINSERVX
CreateMERGEBUPR1000000MERGE_BUPR_CENTRALX
CreateBPOUTBUPX1000000MDS_BUPA_OUTBOUNDX

 

  1. Activate PPO Requests for Platform Objects in the Dialog

 

IMG PATHCross-Application Components ® Master Data Synchronization ® Synchronization Control ® Synchronization Control ® Activate PPO Requests for Platform Objects in the Dialog
TCODES_PAB_09000016

 

User ActionSyn. ObjectPPO Active
CreateBPX

 

  1. Activate Creation of Postprocessing Orders

 

IMG MenuCross-Application Components ® General Application Functions ® Postprocessing Office ® Business Processes ® Activate Creation of Postprocessing Orders
Transaction Code/SAPPO/72000178

On the Change View “Activate Creation of Postprocessing Orders”:Overview screen, create the following settings:

User ActionComponentBusiness ProcessAct.
CreateAP-MDCVI_03X
CreateAP-MDCVI_04X

 

  1. Activate Synchronization Options
IMG MenuCross-Application Components ® Master Data Synchronization ® Synchronization Control ® Synchronization Control ® Activate Synchronization Options
Transaction CodeS_PAB_09000018

 

User ActionComponentBusiness ProcessAct.
CreateBPCUSTOMERX
CreateBPVENDORX

  1. Define No. assignment for Direction BP to Vendor

 

IMG PATHCross-Application Components ® Master Data Synchronization ® Customer/Vendor Integration ® Business Partner Settings ® Settings for Vendor Integration ® Field Assignment for Vendor Integration ® Assign Keys ® Define Number Assignment for Direction BP to Vendor
TCODES_ALN_01002326

 

User ActionBP GroupingShort NameVendor Account GroupNameSame Number
CreateBP01Local VendorZ001Local VendorX
CreateBP02Foreign VendorZ002Foreign VendorX
CreateBP03Employee vendorZ003Employee Vendor LocalX
CreateBP04Emp Vendor ExpaZ004Employee Vendor ExpatriateX

Here we assign BP Group and Vendor account group.

 

  1. Set BP Role Category for Direction BP to Vendor
IMG MenuCross-Application Components ® Master Data Synchronization ® Customer/Vendor Integration ® Business Partner Settings ® Settings for Vendor Integration ® Set BP Role Category for Direction BP to Vendor
Transaction CodeS_ALN_01002328

 

Field NameEntry ValueComment
BP Role Cat.FLVN01
DescriptionBusiness Partner Vendor (FS: BP)
Vendor-BasedX
Optional for Vendorleave empty
Role Control Settingleave empty
Default Settingsleave empty

  1. Define Tax Categories
IMG PATH

SPRO -> Cross-Application components -> SAP Business Partner -> Business Partner ->Basic Settings -> Tax Number -> Maintain Tax Categories

 

TCODES_AEC_66000043

 

 

In the note 775919, you can find all the standard tax categories. You could also define the customized ones. This is addressed in note 201073.

 

Below are the tax number categories that SAP delivers:

AE0    UAE: VAT Registration Number

BG0   Bulgaria: Vat Registration Number
BG1   Bulgaria: Unified ID Code
BG2   Bulgaria: Personal ID

DE0   Germany: VAT Registration Number
DE1   Germany: Income Tax Number
DE2   Germany: VAT Number

  1. Tax Number Categories of Business Partner

 

Go to >>SM30 :V_TFKTAXNUMTYPE

 

The function module for those tax number types ends with ‘0’ (eg. DE0, AT0) is VAT_REGISTRATION_NUMBER_CHECK.
For the others, assign the function module BUPA_TAX_NUMBER_CHECK.

 

  1. Tax Categories system messages

T.Code: SM31 : Table/View ‘T100s’

Field NameEntry 1
Application AreaBUPA_TAX
Message no400
AllowedWEIS-
StandardI
Switch Off

 

  1. Define Tax Category message control

With this we can control entering same tax number twice in system for ay vendor

T.Code: OBA5

Field NameEntry 1
Application AreaBUPA_TAX
Message400
OnlineE
BatchE

 

  1. Postal code mandatory can be done in OY07 transaction
  2. Partner Roles, Assigning Vendor Account Group, Partner Schemas, Assign Partner Schemas to Vendor Account Groups is same as we do in ECC

 

  1. Following standard like: Maintain Industry Systems and Industries,Assign Industries, Maintain Legal Forms, Define Departments, Define Functions, Define Contact Person Functions, Define Authority, Define VIP Entries, Maintain Authorization Groups,and their Assignment is common or Business requirement so not discussed

 

  1. For Mass upload of BP, new transaction Migration cockpit like LTMC. SAP has delivered some standard objects. All templates available on transaction download fill and upload then proceed. You need to map the fields.

 

If we want to add new fields go to transaction LTMOM

If you face any issue, use CALL FUNCTION ‘RFC_CVI_EI_INBOUND_MAIN’and make program of your own.

 

You also can use XK99 standard Vendor Mass Maintenance

 

We can use Rapid Data Migration tool also

  1. Note that there is no reports on BP in SAP GUI. In Fiori we get more reports.I hope covered all the topics which requires for Business Partner (Vendor) Customization, Mass uploads. I try to mention comparing with ECC, so that it can be understood easily. I mentioned along with screen shots also which will be much helpful. I try to cover many points which I didn’t find in blogs. I mentioned relevant SAP notes where ever required. 

    Hope you will more insight to Business Partner and will be much helpful.

Material Number length Configuration:-

1. Activation of the Extended Material Number Functionality

 

IMG — Cross-Application Components — General Application Functions — Field length extension — Activate extended fields.

Alternative:

           

Transaction FLETS (For the table maintenance the authorization group FLE [authorization object S_TABU_DIS] is required).


2. Changing the Material Number Format.


Transaction OMSL allows a customer-specific settings regarding the material number field length. Here the settings need to be adapted to allow a field length of more than 18 characters


Define Output Format of Material Number can be accessed via — IMG (Logistics General — Material Master — Basic Settings).



No comments:

Best Q & A for Interview

Closed MM period reopened in SAP MM

Sometimes, the Client requirement comes to reopen the MM closed period which is not possible directly through the MMPV t-code but We have on...

100% Success Factor