LET US ABAP: Jul 1, 2008

Tuesday, July 1, 2008

SAP Plant Storage Location Data

SAP Plant Storage Location Data

To extract SAP Plant and Storage Location Data the following Function Module can be used

SAP ABAP Function Module to extract PLANT and STORAGE Location Data.

ITOB_CHECK_PLANT_STORAGE

_______________________________________________

Important SAP MASTER Tables associated with this Function Module are as follows.

TVKO                    SAP Sales organization
TVTW                    SAP Distribution channel
TVST                     SAP Shipping point/receiving point
LFA1                     SAP Vendor's account number
KNA1                    SAP Account number of customer
T001W                SAP Plant
TSPA                     SAP Division

______________________________________________________

Import Parameters for the above mentioned Function Module are as follows

T001L-LGORT                 Storage location
T001L-WERKS                 Plant
SY-BINPT                        Batch input, program running under batch input (Dialog Mode)
SY-BINPT                        Batch input, program running under batch input (Dialog Cursor)
DD03D-FIELDNAME       Field name
SY-STEPL                        Screens, current table line index
SY-BINPT                        Batch input, program running under batch input (Initial Message Data)
SY-MSGTY                      Messages, message type

_______________________________________________________

The following fields are outputted

Plant, Storage location, Description of storage location, Division, Negative stocks allowed in storage location, Freezing book inventory bal., allowed in stor. loc., Storage location MRP indicator, Storage location authorization for goods movements active, Storage location is allocated to resource (storage resource), Handling unit requirement, Partner storage location of the handling unit, Sales organization, Distribution channel, Shipping point/receiving point, Vendor's account number, Account number of customer.

_______________________________________________________

Code is given below.

REPORT ZEX_ITOBPLANTSTORAGELOC.

Parameter: p_werks like T001L-WERKS,
           p_lgort like T001L-LGORT.

Data: wa_T001L type T001L.

CALL FUNCTION 'ITOB_CHECK_PLANT_STORAGE'
   EXPORTING
     LAGER_IMP               = p_werks
     WERK_IMP                = p_lgort
    USE_BUF                 = 'X'
    DIALOG_MODE             = 'X'
    DIALOG_CURSOR           = ' '
    DIALOG_STEPL            = 0
    INIT_MESSAGE_DATA       = 'X'
    X_MESS_TYPE             = 'E'
IMPORTING
    T001L_EXP               = wa_T001L
EXCEPTIONS
    EMPTY_KEY               = 1
    APPLICATION_ERROR       = 2
    OTHERS                  = 3
           .
IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

SAP Plant Details Company code and Controlling Area for a Plant

SAP Plant Details Company code and Controlling Area for a Plant

To extract the Plant Details, Company Code details and Controlling area details for a Plant the following Function Module can be used.

ITOB_CHECK_PLANT

The above mentioned function module extracts all the details from the table T001W Plants/Branches, it also extracts details from the following fields.

T001K-BUKRS Company Code
TKA01-KOKRS Controlling Area

Following are the Input Parameters

T001W-WERKS                     PLANT
SY-BINPT                              Batch input, program running under batch input
TKA02-GSBER                      Business Area
SY-BINPT                              Batch input, program running under batch input DIALOG_MODE
SY-BINPT                              Batch input, program running under batch input DIALOG_CURSOR
DD03D-FIELDNAME             Field name
SY-STEPL                           Screens, current table line index
SY-BINPT                           Batch input, program running under batch input
SY-MSGTY                           Messages, message type

Find the program below.

REPORT ZEX_ITOBCHECKPLANT .

Parameter: p_werks like T001W-WERKS.

Data: wa_plant type T001W,
      d_bukrs like T001K-BUKRS,
      d_kokrs like TKA01-KOKRS.

CALL FUNCTION 'ITOB_CHECK_PLANT'
EXPORTING
    WERK_IMP                = p_werks
   DETERMINE_MODE          = 'X'
*   GSBER_IMP               =
   USE_BUF                 = 'X'
   DIALOG_MODE             = 'X'
   DIALOG_CURSOR           = ' '
   DIALOG_STEPL            = 0
   INIT_MESSAGE_DATA       = 'X'
   X_MESS_TYPE             = 'E'
IMPORTING
   T001W_EXP               = wa_plant
   BUKRS_EXP               = d_bukrs
   KOKRS_EXP               = d_kokrs
EXCEPTIONS
   EMPTY_KEY               = 1
   APPLICATION_ERROR       = 2
   OTHERS                  = 3
          .
IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

This site is owned and operated by G Rajesh. All product names are trademarks of their respective companies. This site is in no way affiliated with SAP AG. Use information on this site at your own risk. © The articles are copyrighted to G Rajesh and can only be reproduced given the author's permission. You can contact me on abap.sap.friend@gmail.com. Your privacy on the Internet is of the utmost importance to us.We want to make your online experience satisfying and safe. Because we gather certain types of information about our users, we feel you should fully understand our policy and the terms and conditions surrounding the capture and use of that information. This privacy statement discloses what information we gather and how we use it.

Information we gathers through aggregated tracking information derived mainly by tallying page views throughout our sites. This information allows us to better tailor our content to readers’ needs and to help our advertisers and sponsors better understand the demographics of our audience. Under no circumstances we divulge any information about an individual user to a third party.

Cookie Tracking: We may place a text file called a “cookie” in the browser files of your computer. The cookie itself does not contain Personal Information although it will enable us to relate your use of this site to information that you have specifically and knowingly provided. But the only personal information a cookie can contain is information you supply yourself. A cookie can’t read data off your hard disk or read cookie files created by other sites. We may use cookies to track user traffic patterns (as described above).

We allow third-party advertising companies (like Google Adsense) to serve ads when you visit our Web site. If you would like more information about this practice and to know your choices about not having this information used by these companies, Visit This.http://www.google.com/privacy_ads.html * Google, as a third party vendor, uses cookies to serve ads on your site. * Google's use of the DART cookie enables it to serve ads to your users based on their visit to your sites and other sites on the Internet. * Users may opt out of the use of the DART cookie by visiting the Google ad and content network privacy policy.

Tuesday, July 1, 2008

SAP Plant Storage Location Data

SAP Plant Details Company code and Controlling Area for a Plant

ABAP Friend

Blog Archive

Privacy Policy