Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

which bapi works for this

Former Member
0 Likes
989

hi gurus,

i am supposed to extract the material master data from sap regarding one plant.

the following fields are to be extracted.

is there any bapi, which gives out these fields or do i have to do a lot of selects with inner joins.

Material

PLANT

Valuation Area

SALES_ORG

Matl Description

Base UM

MATERIAL GROUP

Gen Item Cat Group

Authorization Group

Gross Weight

Net Weight

Basic Material

Ind_Std_Description

Delivering Plant

Item Category

Material group 1

Material group 2

MATERIAL GROUP 3

MATERIAL GROUP 4

MATERIAL GROUP 5

Product_Hierarchy

MATERIAL FREIGHT GROUP

Profit Center

Comm/Imp Code No

Purchasing_Group

ABC Indicator

MRP TYPE

Planning Time Fence

Issue Storage Loc

MRP Controller

Procurement type

Special Procurement Key

In-house production

Scheduling Margin Key

Safety Stock

Safety time Ind

Temperature Conditions

Repetitive Manufacturing

REM Profile

STORAGE LOC EXP

Insp Stock

Valuation class

Standard Price

rgds.

sanju.

hi gurus,

i am supposed to extract the material master data from sap regarding one plant.

the following fields are to be extracted.

is there any bapi, which gives out these fields or do i have to do a lot of selects with inner joins.

Material

PLANT

Valuation Area

SALES_ORG

Matl Description

Base UM

MATERIAL GROUP

Gen Item Cat Group

Authorization Group

Gross Weight

Net Weight

Basic Material

Ind_Std_Description

Delivering Plant

Item Category

Material group 1

Material group 2

MATERIAL GROUP 3

MATERIAL GROUP 4

MATERIAL GROUP 5

Product_Hierarchy

MATERIAL FREIGHT GROUP

Profit Center

Comm/Imp Code No

Purchasing_Group

ABC Indicator

MRP TYPE

Planning Time Fence

Issue Storage Loc

MRP Controller

Procurement type

Special Procurement Key

In-house production

Scheduling Margin Key

Safety Stock

Safety time Ind

Temperature Conditions

Repetitive Manufacturing

REM Profile

STORAGE LOC EXP

Insp Stock

Valuation class

Standard Price

rgds.

sanju.

5 REPLIES 5
Read only

amit_khare
Active Contributor
0 Likes
880

BAPI_MATERIAL_GET_ALL and BAPI_MATERIAL_GET_DETAIL

Read only

0 Likes
880

hi amit,

thank you for the reply,

actually, i need to transfer material from one plant to another,

when i searched in the sdn i found idocs is the best way,

but i cannot use it bocs, before, i transfer it into new plant, client wants to verify and do some changes, to the data extractd so, i cannot use idocs,

when i input the plant number i need to extract all the material from that plant, using the tcode cs12 i need to find out if there are any sub level matnrs to that matnr,

if yes i need to put them below this matnr.

first step

should i be putting a

select matnr from marc plant = P_werks.

or is there a good bapi to do this.

thanks.

Read only

0 Likes
880

thanks ravi,

before i close this thread, i want to know

the program when copy pasted, is giving the error forthe below stmt:

WRITE:/ BAPI_HEAD, BAPI_MARC1.

BAPI_MARC1 is not charecter type.

do i have to loop around it to display.

thanks

Read only

Former Member
0 Likes
880

Going from BAPI to flat file is a big design change. Are you sure that you have thought both of your options through for before choosing one? (Look at different aspects like business requirements, error reporting, data volumes, data security, robustness required for the process etc)

It is possible to use a BAPI for ALE, i am not sure of the exact details though.