Posts

Showing posts with the label SELECT DISTINCT in SAP ABAP

BAPI for material storage location Add

 We can add material storage location plant wise using third party app or web. BAPI names : BAPI_MATERIAL_MAINTAINDATA_RT Import parameters: HEADDATA: Material Tables: STORAGELOCATIONDATA: Material: Plant: STGE_LOC:   STORAGELOCATIONDATAX: Material: Plant: STGE_LOC:   use below code after completing steps. CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'.        

SELECT DISTINCT in SAP ABAP

SELECT DISTINCT in SAP ABAP: Select Distinct is a sql query, which is used to get distinct value of a column from database table.Its remove duplicate value of a column of a table. Syntax: SELECT DISTINCT COLUMN_NAME FROM DBTABLE INTO TABLE ITAB(Internal Table)  WHERE <CONDITION>.