Reply from deepak_update5 on Sep 23 at 9:28 AM Hi, friend for I cant find out your whole answer but there is some little program for display table names and its characters. I am sending the some sample program for displaying table and contents so Please you can find out your answer hopefully you will get the correct answer.
ABAP Program to Display SAP Dictionary Table Information
The SAP transaction SE11 displays all the field information in a great detail. If only we could download the information into a file... or be able to search for a string...
The ABAP program below fulfills the above wishes. It is basically a report so you can download the output and search for a specific string.
You can supply a single table name (e.g., KNA1) in the selection screen. You can also run this program against multiple tables but the table names should come from an external file. Double clicking on the highlighted table name takes you to SE11 on that table!
I have the following text elements defined:
TEXT-001 = Specify a single table name here, or hit F8 to specify a
TEXT-002 = file name containing table names.
ABAP Code
REPORT ZTBLINFO LINE-SIZE 80.
TABLES: DD02L,
DD02T,
DD03L,
DD04T.
DATA: BEGIN OF ITAB_TABLES OCCURS 0,
TABNAME LIKE DD02L-TABNAME,
END OF ITAB_TABLES.
DATA: FILEOPENCANCELLED.
SELECTION-SCREEN: COMMENT 1(80) TEXT-001, SKIP 1,
COMMENT 1(80) TEXT-002, SKIP 1.
PARAMETER: TBLNAME LIKE DD02L-TABNAME.
IF TBLNAME IS INITIAL.
CALL FUNCTION 'UPLOAD'
EXPORTING
FILENAME = 'tablenames.txt'
IMPORTING
CANCEL = FILEOPENCANCELLED
TABLES
DATA_TAB = ITAB_TABLES.
IF NOT FILEOPENCANCELLED IS INITIAL.
EXIT.
ENDIF.
ELSE.
CLEAR ITAB_TABLES. REFRESH ITAB_TABLES.
ITAB_TABLES-TABNAME = TBLNAME.
APPEND ITAB_TABLES.
ENDIF.
SORT ITAB_TABLES.
DELETE ADJACENT DUPLICATES FROM ITAB_TABLES.
TRANSLATE ITAB_TABLES-TABNAME TO UPPER CASE.
SELECT TABNAME DDTEXT FROM DD02T
INTO CORRESPONDING FIELDS OF DD02T
FOR ALL ENTRIES IN ITAB_TABLES
WHERE TABNAME = ITAB_TABLES-TABNAME AND
DDLANGUAGE = 'E'.
FORMAT COLOR COL_KEY.
WRITE: / 'N ' AS SYMBOL,
DD02T-TABNAME RIGHT-JUSTIFIED, '-', DD02T-DDTEXT,
'? ' AS SYMBOL.
HIDE DD02T-TABNAME.
FORMAT COLOR OFF.
SELECT FIELDNAME ROLLNAME DATATYPE LENG DOMNAME FROM DD03L
INTO CORRESPONDING FIELDS OF DD03L
WHERE TABNAME = DD02T-TABNAME.
SELECT DDTEXT FROM DD04T
INTO CORRESPONDING FIELDS OF DD04T
WHERE ROLLNAME = DD03L-ROLLNAME AND
DDLANGUAGE = 'E'.
WRITE: /
DD03L-FIELDNAME, DD03L-ROLLNAME,
DD03L-DATATYPE, DD03L-LENG NO-ZERO,
DD03L-DOMNAME, (35) DD04T-DDTEXT.
ENDSELECT.
ENDSELECT.
ULINE.
ENDSELECT.
CLEAR DD02T-TABNAME.
AT LINE-SELECTION.
IF NOT DD02T-TABNAME IS INITIAL.
call function 'RS_DD_DEF_SHOW'
EXPORTING
OBJNAME = DD02T-TABNAME.
ENDIF.
CLEAR DD02T-TABNAME.
| | | ---------------Original Message---------------
From: Robert van der Veen
Sent: Friday, September 21, 2012 10:38 AM
Subject: RE Table to Display Material, Batch, Batch Class Type Specific to 023 and Its Characteristics
Hello,
Use BAPI_OBJCL_GETCLASSES or CLAF_CLASSIFICATION_OF_OBJECTS for the
Characteristics</x>.
for stock use:
o Select from MARD:
LABST (unrestricted stock)
INSME (qi)
SPEME (blocked stock)
RETME (returns)
Kind Regards,
Robert
Op 09/21/12, Community_Member email@removed schreef:
>
>
>
>
>
> A, .slash {text-decoration:none; font-family:arial; color:#1867b6}
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Question from Claudine on Sep 21 at 8:57 AM
>
>
>
>
>
> Need help on what table to be include in a report to be able to display a material, batch, batch class type specific to 023 and a its characteristics including values.
>
> We need to create a program that will be able to display below data considering only from batch class type 023.
> material
> UOM
> batch
> Class Name
> Class Characteristics</x>
> Class Characteristic Values
> Unrestricted Stock
> Restricted Stock
> Blocked Qty
> Quality Stocks
>
> The developer has getting trouble with the needed table to be incorporate on this program. Your input is highly appreciated.
>
> Thanks in Advance
> Claudine
>
>
>
> Reply to this email to post your response. |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
