How to use BAPI or Function Module

January 13, 2015 Leave a comment

How to understand BAPI or Function Module is working? well, it’s difficult for abap programmer to understand how the transaction of function module is working, so for the first time we have to learn the manual transaction using standard transaction code. For example asset master creation (AS01), we have to learn all mandatory attribute for master creation and trying to create master manually.

After you can run manual transaction then it’s easy to run function module or BAPI using test function.

Function Module #1

Simple tips… good luck!!

Categories: Uncategorized

WBS settlement rule table in sap

April 30, 2013 Leave a comment

Dear, finally i found SAP table to store settlement rule of WBS (COBRB).

You can combaine table PRPS & COBRB with key object number (OBJNR).

GOOD LUCK.

Categories: TECHNICAL Tags:

AUC Settlement To Fixed Asset – how to get settlement data via database

April 30, 2013 Leave a comment

Some how we faced condition that big project with big amount procured by single AUC with LOT base not in detail. That’s big problem and to settle into fixed asset will need big effort. The first effort is to download total of AUC balance with detail breakdown of AUC settlement. The basic way to know the value of settlement AUC is using t-code AIAB but it’s one by one (need long time).

Know here i share how to download settlement AUC (tcode AIAB) using table ANEK-ANEP:

SELECT *
FROM ANEK AS A INNER JOIN ANEP AS B
ON  A~MANDT = B~MANDT
AND  A~BUKRS = B~BUKRS
AND  A~ANLN1 = B~ANLN1
AND  A~ANLN2 = B~ANLN2
AND  A~GJAHR = B~GJAHR
AND  A~LNRAN = B~LNRAN
WHERE  A~ANLN1 IN [YOUR AUC]
AND  B~AUGLN EQ SPACE

With above query you will get the value of settlement AUC, good luck.

Categories: TECHNICAL Tags:

Goods Receipt/Issue Slips Configuration

June 27, 2008 3 comments

In Inventory Management there are out put document such as goods receipt slip, issue slip, & etc that can be printed for every movement. You can print the form via t-code MB90 with output type as option to print. Output type is code to define what form you want to print.

Example:

Your client want to print goods issue slip with two different format. With this condition you have to create two output type code and attach the form into this output type.

Solution:

You have to configure difference output type for difference format slip, and create difference sap form for difference slip/form.

Read more…

Error while AUC settlement

April 28, 2008 4 comments

While my client settle AUC into new fiscal year which acquisition on old fiscal year, error “Settlement of Old Asset Data to Receiver Type G/L Not Allowed” happen. Full message from SAP you can see like below:

Message from SAP :

Settlement of Old Asset Data to Receiver Type G/L Not Allowed
Message no. AW607Diagnosis
You tried to settle values from the previous year to a receiver other than
an asset. This procedure is not supported by the system.

Procedure
Check your distribution rules and change the receiver.

I have been check the distribution rule of AUC, 80 % settle into fix asset and 20% settle into G/L expense. This problem happen only if the AUC settlement is running on different fiscal year (acquisition on old fiscal year, and settlement on new fiscal year). Based on the message I conscious that SAP configuration does not allow for this distribution in different fiscal year.

I’ve been think for an hours for this problem and finally I got idea for the solution. First, I change the distribution rule from fix asset and expense into AUC. And then run the settlement, after that the distribution rule change into fix asset and expense and run again the settlement…. Thanks God its working.

Categories: FUNCTIONAL Tags: , ,

Changing the SAP Standard – Transaction Variant

December 21, 2007 11 comments

In some business, sometime we need to adjust business transaction by hiding all information not relevant and displaying only the important information.As a case, asset master data maintenance only permitted to change only General data. In this case you have modify the screen of asset maintenance, for detail case see image below :

Standard : display screen of AS02.

Standart - AS02

Read more…

Categories: TECHNICAL Tags: , ,

Learning BAPI from Asheet Bephora

November 25, 2007 Leave a comment

Well, right now I produce many of BAPI for my client to handle interface between SAP with other system. In this Blog I just want to say thanks for Asheet as my instructor while learning BAPI on EISPL Singapore. I still remember while learning, always asking and asking because I’m new in ABAP experience. It’s about 2 years ago, so long…. and I hope we will meet again. Below my picture with Asheet :

Me and Asheet

And below is my testimonial on EISPL : http://www.eispl.com/testimonials/SAP_training_16.html

testimonial.jpg

Well, it’s only memorial article. Thanks for Asheet, thanks for Mas Adi – you give me night in Singapore.

Categories: ARTICLE Tags:

Finding Email address Customer and Vendor Master on SAP

November 8, 2007 8 comments

It’s not quite simple to find email address of Customer and Vendor Master on SAP. You need to activated SQL trace and change email on master to find where email address is stored. Here i share the result of tracing using SQL trace of email addess Customer and Vendor master.

For Customer :

select adr6-addrnumber (email) from table adr6 join table kna1 with key adr6-addrnumber = kna1-adrnr

For Vendor :

select adr6-addrnumber (email) from table adr6 join table lfa1 with key adr6-addrnumber = lfa1-adrnr

ABAP Version :

data : lv_email like adr6-addrnumber.

select addrnumber into lv_email from adr6 as a  inner join kna1 as b on a~addrnumber = b~adrnr.

Get comments texts from SAP

November 7, 2007 7 comments

In many transaction, SAP stores comments in different table. For example if you want to get comments texts on Item detail of Purchasing order , belive me you will not find on table EKPO (Item table of purchasing order). So you need a function and some object or id to get the comment. You can find object by entering table STXH-TDNAME with Purchasing order number plus asterisk (because STXH-TDNAME contains PO Number plus Item number of PO). STXH-TDNAME = ‘4500002131*’ will be bring back object, name, and id as parameter on function module READ_TEXT.

The following code is a function that will return PO Item text :

Read more…

Categories: TECHNICAL

Improving WIP Calculation

September 5, 2007 2 comments

My client has been decided to change the production strategy from discrete manufacturing to repetitive manufacturing. Discrete manufacturing produce production order,  and the problem is many production order pending (status is not closed).

As a result of the above condition, WIP calculation  performance is getting down from one hours become a day and finally WIP calculation is not run properly.

I found some note from SAP library, give me some tips how to improve WIP calculation performance. The note said that you can significantly improve the performance of WIP calculation by setting the status DLFL (Deletion flag)  for the following orders:

·         The order is delivered or technically completed

·         Variances have been calculated for the order

·         You do not anticipate any further follow-up costs for the order

Practically I do the following action above and finally the performance of WIP – calculation was improved significantly.

 

Appendix :

WIP : Work in process

Categories: FUNCTIONAL Tags: , ,