Aprende en Comunidad
Avalados por :
Creación de informe de valores característicos en SAP para material class
- Creado 01/03/2024
- Modificado 01/03/2024
- 14 Vistas
0
Cargando...
I'm starting the SAP blog page with a report. In this report, we will try to show the characteristic values entered under the material class in the material master data to the user in the form of a report.
I am working as an ABAP developer in a company that uses SAP. The reason why we need this report is that our production planning department wants to see the characteristics they defined for the materials collectively. Material characteristics can be obtained with the CLAF_CLASSIFICATION_OF_OBJECTS function. Since we will query the materials collectively, we will read directly from the tables to gain performance.
In our report, we will query the characteristics in the "Material Class" class.
The values we will query are the values in the "General" tab of the screen below.
As seen in the screens above, it is a problem to go around the materials in order to see the characteristics entered in the material master data. As a solution to this problem, taking the following entry;
As a result, we will write the report that outputs as follows.
As a first step, let's make the variables and definitions that we will use in our report.
I am working as an ABAP developer in a company that uses SAP. The reason why we need this report is that our production planning department wants to see the characteristics they defined for the materials collectively. Material characteristics can be obtained with the CLAF_CLASSIFICATION_OF_OBJECTS function. Since we will query the materials collectively, we will read directly from the tables to gain performance.
In our report, we will query the characteristics in the "Material Class" class.
The values we will query are the values in the "General" tab of the screen below.
As seen in the screens above, it is a problem to go around the materials in order to see the characteristics entered in the material master data. As a solution to this problem, taking the following entry;
As a result, we will write the report that outputs as follows.
As a first step, let's make the variables and definitions that we will use in our report.
TYPE-POOLS: SLIS.
TABLES: MARA, MAKT, CABNT, CABN, T006A, AUSP.
DATA: BEGIN OF GT_METADATAS OCCURS 0,
MATNR LIKE MARA-MATNR, " material no.
MAKTX LIKE MAKT-MAKTX, " Material description
atinn LIKE AUSP-ATINN, " characteristic
ATBEZ LIKE CABNT-ATBEZ, " Characteristic description
MSEHI LIKE CABN-MSEHI, " Measurement unit
ATWRT LIKE AUSP-ATWRT, " Character characteristic value
ATFLV LIKE AUSP-ATFLV, " Numeric Lower value
ATFLB LIKE AUSP-ATFLB, " numeric upper value
MSEH6 LIKE T006A-MSEH6, " Unit of measure technical definition
SPRAS LIKE T006A-SPRAS, " language
ATFOR LIKE CABN-ATFOR, " data type
ANZST LIKE CABN-ANZST, " character length
ANZDZ LIKE CABN-ANZDZ, " number of decimal characters
VAL1
Pedro Pascal
Se unió el 07/03/2018
Facebook
Twitter
Pinterest
Telegram
Linkedin
Whatsapp
Sin respuestas
No hay respuestas para mostrar
Se el primero en responder
contacto@primeinstitute.com
(+51) 1641 9379
(+57) 1489 6964
© 2024 Copyright. Todos los derechos reservados.
Desarrollado por Prime Institute
Hola ¿Puedo ayudarte?