SAP Reports / Programs
J_1AMLBS SAP ABAP Report - Display Warehouse Stock
J_1AMLBS is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Use this report to display the total quantity and value of stock at plant, storage location and valuation type level...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.
If you would like to execute this report or see the full code listing simply enter J_1AMLBS into the relevant SAP transactions such as SE38 or SE80
Transaction Code(s):
Below is a list of transaction codes which are relevant to this SAP report
J1A5 - MM Warehouse stock report (Arg.)
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT J_1AMLBS. "Basic submit
SUBMIT J_1AMLBS AND RETURN. "Return to original report after report execution complete
SUBMIT J_1AMLBS VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Selection Text: UPDATE = Update
Selection Text: P_ZEBRA = Striped Pattern
Selection Text: P_VARI = Layout
Selection Text: P_SUBSUM = Subtotal
Selection Text: P_COLOPT = Optimize Columns
Selection Text: MATKLA = Material Group
Selection Text: MATART = Material Type
Selection Text: I_MKPR = Use Market Price
Selection Text: I_BUKRS = Company Code
Selection Text: EKGRUP = Purchasing Group
Selection Text: DATE_TO = To
Selection Text: DATE_FRM = From
Selection Text: BWTAR = Valuation Type
Title: Display Warehouse Stock
Text Symbol: 117 = Display Source
Text Symbol: 118 = Update Mode
Text Symbol: 116 = To
Text Symbol: 115 = From
Text Symbol: 114 = Invoices
Text Symbol: 113 = Info Records
Text Symbol: 112 = Contracts
Text Symbol: 111 = Select Purchase Orders
Text Symbol: 110 = Use Market Price
Text Symbol: 100 = Settings for Market Price Evaluation
Text Symbol: 080 = Settings
Text Symbol: 070 = Scope of List
Text Symbol: 062 = Info Record:
Text Symbol: 061 = Contract:
Text Symbol: 060 = Purchase Order:
Text Symbol: 059 = Invoice
Text Symbol: 240 = Inflation Method
Text Symbol: 500 = Company Code
Text Symbol: 300 = Display Options
INCLUDES used within this REPORT J_1AMLBS
INCLUDE: MM07MABC,
RM07MSQL.
INCLUDE: RM07MUSR,
RM07MEND.
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
FI_PERIOD_DETERMINE CALL FUNCTION 'FI_PERIOD_DETERMINE'" getting fiscal year EXPORTING I_BUDAT = DATETO * I_BUKRS = ' ' * I_PERIV = ' ' * I_GJAHR = 0000 * I_MONAT = 00 * X_XMO16 = ' ' IMPORTING E_GJAHR = BYEAR .
G_POSTING_DATE_OF_YEAR_GET CALL FUNCTION 'G_POSTING_DATE_OF_YEAR_GET' EXPORTING VARIANT = T001-PERIV YEAR = GYEAR IMPORTING FROM_DATE = FIRST_DAY_YEAR * LAST_NORMAL_PERIOD = TO_DATE = LAST_DAY_YEAR .
DATE_TO_PERIOD_CONVERT CALL FUNCTION 'DATE_TO_PERIOD_CONVERT' EXPORTING I_DATE = DATETO I_PERIV = T001-PERIV IMPORTING E_BUPER = GPERI * e_gjahr = bis-gjahr EXCEPTIONS OTHERS = 1.
J_1A_GET_MARKET_PRICE CALL FUNCTION 'J_1A_GET_MARKET_PRICE' EXPORTING I_BUKRS = I_BUKRS I_DATE_FROM = DATE_FROM I_DATE_TO = DATE_TILL * I_EXCHANGE_RATE_STRAT = 'A' " do not change default 'A' I_INVOICE = SEL_ZUG I_PO = SEL_BEST I_CONTRACT = SEL_KONT I_INFO_REC = SEL_INFO I_VAL_METH = '3' " either I_VAL_METH * I_VAL_METH_FROM_MATERIAL = " or I_VAL_METH_FROM_MATERIAL TABLES T_MATERIAL_RANGE = MS_MATNR T_VAL_AREA_RANGE = MS_WERKS T_MAT_TYPE_RANGE = MS_CHARG T_VAL_TYPE_RANGE = BWTAR " Corrected 1997-06-24 T_MARKET_PRICE_INFO = MARKET_PRICE_INFO T_ERROR_MSGM2TAB = MSGMTAB_MARKET EXCEPTIONS FUNCTION_NOT_READY = 1 FROM_DATE_INITIAL = 2" Corrected 1997-06-24 TO_DATE_INITIAL = 3" Corrected 1997-06-24 EXCH_STRAT_INVALID = 4" Corrected 1997-06-24 NO_VAL_METH = 5" Corrected 1997-06-24 VAL_METH_INVALID = 6" Corrected 1997-06-24 INVALID_VAL_LEVEL = 7" Corrected 1997-06-24 OTHERS = 8. " Corrected 1997-06-24
ENQUEUE_EJ_1AT16 * CALL FUNCTION 'ENQUEUE_EJ_1AT16' " * EXPORTING " * MODE_J_1AINFT16 = 'E' " * MANDT = SY-MANDT " ** MATNR = " ** BWKEY = " ** BWTAR = " ** GJAHR = " ** X_MATNR = ' ' " ** X_BWKEY = ' ' " ** X_BWTAR = ' ' " ** X_GJAHR = ' ' " ** _SCOPE = '2' " ** _WAIT = ' ' " ** _COLLECT = ' ' " * EXCEPTIONS " * FOREIGN_LOCK = 1 " * SYSTEM_FAILURE = 2 " * OTHERS = 3. "
DEQUEUE_EJ_1AT16 * CALL FUNCTION 'DEQUEUE_EJ_1AT16' * EXPORTING * MODE_J_1AINFT16 = 'E' * MANDT = SY-MANDT ** MATNR = ** BWKEY = ** BWTAR = ** GJAHR = ** X_MATNR = ' ' ** X_BWKEY = ' ' ** X_BWTAR = ' ' ** X_GJAHR = ' ' ** _SCOPE = '3' ** _SYNCHRON = ' ' ** _COLLECT = ' ' * EXCEPTIONS * OTHERS = 1.
ENQUEUE_EJ_1AT16 CALL FUNCTION 'ENQUEUE_EJ_1AT16' EXPORTING MODE_J_1AINFT16 = 'E' MANDT = SY-MANDT * MATNR = * BWKEY = * BWTAR = * GJAHR = * X_MATNR = ' ' * X_BWKEY = ' ' * X_BWTAR = ' ' * X_GJAHR = ' ' * _SCOPE = '2' * _WAIT = ' ' * _COLLECT = ' ' EXCEPTIONS FOREIGN_LOCK = 1 SYSTEM_FAILURE = 2 OTHERS = 3.
J_1A_INFLATION_CALCULATION_FI CALL FUNCTION 'J_1A_INFLATION_CALCULATION_FI' EXPORTING AMOUNT = MARKET_PRICE_IN ORIGIN_TBEP = J_1AINFMET-J_1ATBFISC ORIGIN_DATE = ORIGIN_DATE FINAL_TBEP = J_1AINFMET-J_1ATBFISC FINAL_DATE = FIN_DATE COUNTRY = T001-LAND1 SPECIFIC_INDEX = J_1AINFMET-J_1AINDXF * SPECIFIC_VERSION = * PROV_SPECIFIC = * GENERAL_INDEX = * GENERAL_VERSION = * PROV_GENERAL = * TRACE = IMPORTING ADJ_AMOUNT = MARKET_PRICE_OUT.
CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING DATE = DATETO1 FOREIGN_AMOUNT = MARKET_PRICE_INFO-J_1AMPRICE FOREIGN_CURRENCY = MARKET_PRICE_INFO-WAERS LOCAL_CURRENCY = T001-WAERS * RATE = 0 * TYPE_OF_RATE = 'M' IMPORTING * EXCHANGE_RATE = * FOREIGN_FACTOR = LOCAL_AMOUNT = MARKET_PRICE_INFO-J_1AADJPR .
DEQUEUE_EJ_1AT16 CALL FUNCTION 'DEQUEUE_EJ_1AT16' EXPORTING MODE_J_1AINFT16 = 'E' MANDT = SY-MANDT * MATNR = * BWKEY = * BWTAR = * GJAHR = * X_MATNR = ' ' * X_BWKEY = ' ' * X_BWTAR = ' ' * X_GJAHR = ' ' * _SCOPE = '3' * _SYNCHRON = ' ' * _COLLECT = ' ' EXCEPTIONS OTHERS = 1.
DATE_TO_PERIOD_CONVERT CALL FUNCTION 'DATE_TO_PERIOD_CONVERT' EXPORTING I_DATE = DATETO I_PERIV = T001-PERIV IMPORTING E_BUPER = GPERI * e_gjahr = bis-gjahr EXCEPTIONS OTHERS = 1.
J_1AM_GET_LAST_MARKET_PRICE * CALL FUNCTION 'J_1AM_GET_LAST_MARKET_PRICE' * EXPORTING P_BUKRS = T001K-BUKRS * P_VON_DAT = X_FDATE * P_BIS_DAT = SEL_DATE * P_BEST = SEL_BEST * P_KONT = SEL_KONT * P_INFO = SEL_INFO * P_ZUG = SEL_ZUG * P_MATNR = F_MATNR * P_BWTTY = F_BWTTY * P_BWKEY = F_BWKEY * P_BWTAR = F_BWTAR * P_MEINS = F_MEINS * IMPORTING E_DATE = X_DATE * E_NIWE_PREIS = F_NEW_PRICE * E_TYPE = X_BELTP * E_BELNR = X_BELNR * E_ZEILE = X_BUZEI * EXCEPTIONS NO_PRICE_FOUND = 1.
J_1AF_INFLATION_CALCULATION * CALL FUNCTION 'J_1AF_INFLATION_CALCULATION' * EXPORTING AMOUNT = F_NEW_PRICE * APPL = 'M' * COMPANYCODE = T001K-BUKRS * FIDATE = X_DATE2 * INDEX = F_J_1AINDX * INTEREST = SPACE * METHOD = 'S' * ORDATE = X_DATE1 * WAERS = F_WAERS * IMPORTING REI = X_REI * RT = X_RT.
J_1A_INF_INT_ALV CALL FUNCTION 'J_1A_INF_INT_ALV' EXPORTING I_DATE_LOW = U_DATE_LOW I_DATE_HIGH = U_DATE_HIGH I_UPDATE = U_UPDATE I_PROVRUN = '0' I_PROCESSING_LINES = L_MBEW_LINES I_CALLBACK_PROGRAM = L_REP_NAME I_VARI = U_P_VARI I_ZEBRA = U_P_ZEBRA I_COLOPT = U_P_COLOPT I_TITLE = L_TITLE I_SUBSUM = U_P_SUBSUM I_BUKRS = U_P_BUKRS TABLES T_OUTTAB_HEADER = UT_HEADER T_OUTTAB_ITEM = UT_ITEM T_MSG = LT_MSG.
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name J_1AMLBS or its description.