Shulou(Shulou.com)06/01 Report--

This article introduces the relevant knowledge of "what are the tables related to SAP ABAP features". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Both features and classifications in SAP are transformed by internal transformation in the system. The correlation table is as follows:

KLAH: conversion table of classification name (CL03) and internal number

KSML: properties assigned to the classification (CT04)

TCLA: the table corresponding to the class type, classification type (for example, 023 batch classification) (parameters necessary to call standard bapi)

CABN: conversion table of property name (CT04) and internal number

CABN: text of the property

AUSP: the property value corresponding to the object

Example:

SELECT INOB~OBJEK "item Code

CABN~ATINN "internal features

CABN~ATNAM "property name

AUSP~ATWRT property valu

INTO CORRESPONDING FIELDS OF TABLE ITAB_TX

FROM INOB

INNER JOIN AUSP ON INOB~CUOBJ = AUSP~OBJEK

INNER JOIN CABN ON CABN~ATINN = AUSP~ATINN

WHERE INOB~OBJEK in S_MATNR.

All the property values of a material are taken here. If you want to take a classification, you can use it with the KSML table.

You can also call BAPI:BAPI_OBJCL_GETDETAIL to get

Description of relevant parameters:

OBJECTKEY: item code

OBJECTTABLE: find the corresponding value from TCLA according to the classification type in the classification view

CLASSNUM: go to KLAH through classification

CLASSTYPE: classification typ

Here OBJECTKEY for different class types, parameter values corresponding to the format is not consistent, such as: material classification-material code, batch classification-material + batch. I am also confused about the specific format, and I can only rely on experience.

The above method only takes out the information maintained in the "classification" view, but there is a NB project that uses variant materials through the data maintained in the "configuration variables" in the "MRP3" view, so that the maintained data cannot be taken out in the above way. I spent the whole morning over the weekend to find the corresponding related table and share it together.

MRAC: material factory data sheet, which is mainly associated with other tables through CUOBJ (internal object number).

IBIN: intermediate translation table, mainly through INSTANCE conversion

IBINVALUES: record the list of features maintained

IBSYMBOL: a table that stores specific property values (similar to AUSP)

Example:

SELECT MARC~MATNR AS OBJEK "item Code

CABN~ATINN "internal features

CABN~ATNAM "property name

IBSYMBOL~ATWRT property valu

APPENDING CORRESPONDING FIELDS OF TABLE ITAB_TX

FROM MARC

INNER JOIN IBIN ON IBIN~INSTANCE = MARC~CUOBJ

INNER JOIN IBINVALUES ON IBINVALUES~IN_RECNO = IBIN~IN_RECNO

INNER JOIN IBSYMBOL ON IBSYMBOL~SYMBOL_ID = IBINVALUES~SYMBOL_ID

INNER JOIN CABN ON CABN~ATINN = IBSYMBOL~ATINN

WHERE MARC~MATNR IN S_MATNR.

This is the end of the "what are the tables related to SAP ABAP features"? thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.