Hi all, Does any body know if there is a BAPI to update the characteristic values in the Material master? SAP MM Business Analyst. OldYgg Posted June 21. Switching back to the 'Values' Tab, the characteristics and its values must be selected and copied, then the mass change may be carried out (F8). Please note, once the 'Copy char. Values' button has been clicked, the characteristic values will not be highlighted anymore as shown below. Updating VC characteristic values is some what tricky in this case BAPIOBJCLCHANGE BAPI will not support.In this blog i will explain how to update VC characterist values Using Function Modules step by step. Below Function Modules used to Update the Variant Characteristic Values. To Set the Config Values. If you assign a characteristic value for the sales document item to the same variant class as the standard network, then the system copies this characteristic value assignment into the network created from the standard network. If you want the characteristic values to be assigned separately, the variant classes must be different. You are trying to Mass update Region Field with blank values in the Taxes tab of Materials. But, the system is giving the error, Update not possible; specified data for SUPPLIER-DEVIANTTAXCLASSIFICATION with key COUNTRYCODE = `XX` AND TAXNUMBERTYPECODE-CON does.
Purpose:
The Purpose of this blog to provide step by step procedure to auto update the Inspection results values to batch characteristics.
Introduction:
Most of PP/QM consultant get the requirement to update the QM inspection results to batch characteristics, especially when they work for Pharmaceutical projects. To Perform MQC, QM inspection results should be updated at batch level that means it is like prerequisite. This blog explains the step by step procedure to auto update the Inspection results values.
Business scenario:
Business want to update the assay, LOD and Potency (potency based on assay & LOD) values to batch characteristics so we must create Master inspection characteristics like Assay, LOD and potency with refence to batch class characteristics. These MICs to be update in Inspection plan of the materials so that these MICs will become part of inspection lot where QM team enter the results so the entered results will be populated in material batch characteristics after performing of usage decision for the inspection lot.
Step-1 Create Batch Characteristics:
We must create of Batch characteristics through Transaction-CT04. This characteristic will be assigning to Batch class and it will be used for creation of MIC.
Step-2 Creation of batch class:
Create the batch class by using class type 023 through transaction CL01 and assign the required batch characteristics to this batch class as shown below
Step-3 Assigning batch class to material in classification view:
We must assign this batch class in classification tab of Material master while creation of material (T-Code MM01).
Sap Mass Update Characteristic Values 2020
Step-4 Create MIC with Batch Characteristics:
Now we must create the Master inspection characteristics with reference to Batch characteristics through transaction QS21.
Enter T-code QS21 and press enter then system will open the below screen. Enter plant, MIC, Valid from and Class characteristic.
Press enter or click on continue. Now system open next screen. Since we entered class characteristic in initial screen, system automatically select “X Reference Characteristic”
Enter the description and search filed values and then click on control indicator
Here we select the “Calc.formula” control indicator and save it.
Step-5 Create Inspection plan with normal MIC as well as with Batch Characteristics MIC:
After Creation of MICs with reference to batch characteristics (LOD, assay & Potency), we must assign these MICs in the inspection plan through transaction QP01.
Here initially we need to enter the normal MIC from where values should be captured to Batch characteristics MICs then we must enter the batch characteristics MIC. Once you enter Batch Characteristic MIC, System will ask for Formula since we select the “Calc.formula” control indicator.
LOD value should be get from “LOSONDRY” MIC value. Since LOSONDRY is 0010 item in the inspection plan so we must enter C0010.
ASSAY value should get from “ANHASSAY” MIC value. Since ANHASSY is 0020 item in the inspection plan so we must enter C0020
Same as LOD and ASSAY, we must provide the formula for POTENCY Based on Business requirement. Here Business following formula i.e. Potency: (Assay-LOD)/10000 so we must maintain formula accordingly in formula field for Potency
Step-6 Goods receipt for material against purchase order:
Logistics team need to do goods receipt so that stock will be posted to QI stock and system will generate the inspection lot
Step-7 Results recording for the inspection lot:
We must enter the results for only Loss on Dry and Assay by HPLC (Which are not batch characteristics MIC). Based on values we entered, system automatically calculate the results for batch characteristic inspection characteristics.
Step-8 Usage decision for inspection lot:
After result recording, we must do the usage decision for the inspection lot. Once usage decision performed, Inspection results will be auto populated to Batch characteristics of that batch.
Step-9 Display batch:
Go to MSC3N, Enter Material, Batch & plant and click on classification so that we can see the values which were auto calculated during results recording.
Conclusion:
By following above steps, we can successfully update the inspection results to batch.
This article will cover How Sap Classification is handled.
It starts with SAP Characteristics and Classes Customizing to get an overview of Classification.
The second part is more technical and covers the Master Data for Classification (ex: AUSP).
The last part explains how to handle Characteristics in ABAP Coding: How to read and Update Characteristics.
You will find a link to ABAP Program Update characteristic value in Sap: how to update the SAP Customer Classification.
SAP Characteristics Customizing
Let’s start by the SAP Characteristics Customizing.
The main Tcode for Characteristics Customizing in SAP is CT04 and CL02 for Class Customizing.
Step by Step SAP Class & Characteristic Customizing
The path to customize Characteristics is:
- CT04: Customizing of SAP Characteristics
- CL02: Customizing of SAP Classes
You can access the Customizing Tcodes directly from Standard SAP Menu under:
SAP Men > Cross-Application Components > Classification System > Master Data
Fill a new for the new Characteristic. Then Choose the Data Type.
Characteristic can have the following type:
- Character Format (fill the numbers with characters),
- Currency Format,
- Date Format,
- Numeric Format
- Or Time Format.
Choose the Value Assignment: Single Value or Multiple Values
Set the list of SAP Characteristic Values depending on your scenario to :
- A fixed list,
- for check table,
- for function module
- Or from Catalog Char.
The list of Value can be found in table CAWN.
SAP Classification: Retrieve and Update
Once the Class and its Characteristics are defined in SAP, let’s move how to assign how to assign SAP Classification to SAP object.
In order to illustrate, we will take some real life sample.
The first example deals about handling Customer Classification in SAP.
Moreover, it will explain how to assign Customer Classification in SAP. Then how to retrieve and update SAP Customer Classification’s Characteristics values.
The next example will cover SAP Material Classification.
Customer Classification in SAP
To access Customer classification, go to XD02/3, then to Extra and Classification.
Read SAP Customer Classification
To read Classification, you can use this standard BAPI BAPI_OBJCL_GETDETAIL.
The class type and the class number can be read from the XD02/3 classification screen:
Update SAP Classification Characteristic
Classification Update can be managed by the standard bapi BAPI_OBJCL_CHANGE.
Don’t forget to call a BAPI_TRANSACTION_COMMIT after the update.
Material classification in SAP
Material Classification in SAP is the same process and access path for Vendor Classification in SAP.
SAP Material Characteristics Table in sap
In order to retrieve Sap Material classification, make a join between MARA-MATNR and AUSP-OBJEK.
SAP Classification Tables
Main SAP Classification Tables & Fields
The most importing SAP classification Tables are
AUSP: this table saves the value of characteristic for a single business object (Customer, material, …)
The AUSP-OBJEK refers to business object key for example Customer ID in table KNA1-KUNNR or Material Number from MARA-MATNR.
The value of the Characteristic can be found in AUSP-ATWRT (neutral value).
CABN: This Table contains the property of the Characteristic. It pilots the type, description … of the characteristic.
KLAH: The Class of Characteristic is a kind of grouping/set of Characteristics.
Sap Mass Update Characteristic Values 2019
When working in ABAP Code with Characteristic, the most important fields to help out extract classification values:
List of related SAP Classification Tables
Find the relevant list for SAP Classification Tables with more information.
Sap Mass Update Characteristic Values List
The List of Important SAP Classification Tables is:
SAP Classification Query
Useless to try an SQVI for Classification. Actually the AUSP-OBJEK has hardly the same kind and length as the MARA-MATNR or KNA1-KUNNR.
A new view between AUSP and KNA1 or MARA can solved the problem.
To make your life easier, here the join to do in order to retrieve Characteristic data in any ABAP Code.
Join between CABN, AUST and KNA1 can be :
- AUSP-ATINN = CABN-ATINN
- CABNT-ATINN = CABN-ATINN
- KNA1-KUNNR = AUSP-OBJEK
SAP Characteristics Tables and Fields
Characteristic Descriptions can be found at table CABN / CABNT in the field CABNT-ATBEZ
Characteristic Values can be found at table AUSP in the field AUSP-ATWRT for Characteristic Value and AUSP-ATFLV for Data Values.
The field AUSP-OBJEK is Key of Object for Characteristic (Material, Customer, …)
Sample SAP Customer Classification Update code
Here a Sample ABAP Program to maintain customer classification in sap.
Please check this link for a sample code to create or update a characteristic.