SAP SD complex instructions – Seite 7

29 03 2012

Mapping /SCWM/DE_MATID to /SAPAPO/MATKEY-MATID

sap-bar

Product ID is represeneted in a couple of different formats in SCM – and hence in EWM.

Table /SAPAPO/MATKEY contains a MATID (Internal Number (UID) for Product), which consists of 22 characters which is a mixture of upper and lower case letters as well as digits.

On the other hand in EWM most tables and references refer to materials via hexidecimal numbers with length 16 (32 characters).

Function module /SCMB/MDL_GUID_CONVERT can be used to convert between these two formats.

26 12 2011

SAP FAQ

Ruslan SAP SAP 1

> Transactions
> Tables

Q: Are There any User Exits to include new fields in the Sales Order?
A:Follow path : IMG->SD->System Modifications->User Exits. There you can click on the help document and it will show all the user exits with program name. Select the suitable one.
Q: What criteria does the delivery split based on?
A: As per standard SAP functionality delivery will split based on the following criteria:
– Shipping Point
– Ship to party
– Delivery Date
– Incoterms
– Unloading Point
– Route
P.S. SAP Delivers report „ZLE_ANALYZE_DELIVERY_SPLIT“ to analyze the reason for delivery split.
Q: How to open table for editing, &SAP_EDIT not working?
A: GD-EDIT and GD-SAPEDIT
Q: Where is the indicator that delivery was distributed or confirmed and so on?
A: Field LIKP-VLSTK:
Not Relevant
A Relevant
B Distributed
C Confirmed
D Planned for Distribution
E Delivery split was performed locally
F Change Management Switched Off
Q: Whenever I run SAP Netweaver Developer Studio 7.3 I get error JVM terminated Exit
A: The installer of SAP Netweaver Developer Studio was 32 bit and it required JVM to be 32 bit.
Q: Create physical inventory document for material, it has an error message „Storage location for material’s valuation type does not exit“
A: If you want to make a physical inventory for a material valuated separately, you have to proceed as follows: – make a goods receipt (MvT 561) and the stock segment will be created – make the reversal of the goods receipt – make the inventory.
Q: How to extend Field Catalog for Condition Tables?
A: Maintain fields in the Customizing view V_T681F with the following: Usage ‚A‘, Application ‚MS‘, Field Group ‚001‘. Then the fields will be available to create the conditions. In case of ZZ-fields, you have to add them first into structures KOMKBME and KOMB-structure’s incl.KOMBZ
Q: How to set default printer LOCLRUS for ME9F?
A: [MN05] – NEU – Purch/Doc vs Purchasing Org – NB / [Plant] – Funct-VN, Medium-1, Date/Time-3, Partner-empty. Save.
Q: What is correction delivery (LFKO)?
A: You correct cumulative quantities in scheduling agreements:
- In case of returns
- When there has been a processing error
- When there has been a year change
- When you are transferring initial quantities from a legacy system into the SAP System
To do this, you create a correction delivery within the delivery schedule itself. This delivery is not relevant for requirements planning, shipping, goods issue, or billing. Correct cumulative quantities only when the customer has not posted goods receipt.
Q: How to find roles by release code (BANF)?
A: Use table AGR_1251 and object M_EINK_FRG:
Q: Error: There is already a handling unit &1 posted for GR without stock
A: Just delete the HU using HU02.
Q: How to debug print forms?
A: Use brackpoints in modules FP_FUNCTION_MODULE_NAME, FP_JOB_OPEN and FP_JOB_CLOSE
Q: How to (re)generate Function Module for PDF-form?
A: Use program FP_GENERATE_FUNCTION_MODULE.
Q: ABAP regex to remove trailing zeroes with decimal point?
A:

data c_value type string. replace regex '[(\.$)?]?[0]+$' in c_value with ''.

1
2

data c_value type string.
replace regex '[(\.$)?]?[0]+$' in c_value with ''.

/i – удалить текущую сессию
/o – список сессий
/nend – выйти из системы
/nex – выйти из системы без подтверждения
Зажав Ctrl и щёлкнув правой кнопкой мышки над полем у которого нет истории – в появившемся контекстном меню появляется пункт „Активировать историю“.

Виды движений:
101 – приход
102 – сторно приход
201 – списание в брак (на МВЗ)
261 – backflush (декларирование производство)
262 – Сторнирование списания в производство
309 – Перевод из материала в материал
311 – трансфер со склада на склад

321 – QI to unrestricted
322 – unrestricted to QI

344 – unrestricted to blocked
343 – blocked to unrestricted

349 – blocked to QI
350 – QI to blocked

453 – returns to unrestricted
457 – returns to QI

701 и 702 – Инвентаризация
601 – отгрузка

Список движений

Кроме обычного соединения с SAP системой, можно сделать соединение с конкретным мандантом, конкретного пользователя и конкретной начальной транзакцией. Делается это через кнопку на панели инструментов SAP GUI. Появится экран, куда вы можете все прописать. При запуске такого ярлыка у вас будет запрашиваться только пароль для указанного пользователя (способ, как сохранить и пароль пользователю описан в SAP note #146173).
Меню пользователя с отображением технических имён транзакций – в меню Дополнительная информация – Параметры настройки отмечаем флаг „Отображать техническое имя“.

SAP GUI 7.30 для Linux перевыложен – скачать можно по этой ссылке:
http://www.sapiens.uj.edu.pl/download/PlatinGUI730Linux_3-20008877.JAR

Q: Как определить какой порт использует server SAP, чтобы соединиться к нему?
A: В стандартном порту 3200 последние две цифры замените номером системы (10 в примере ниже).

Q: Как в SAP GUI for Java создать соединение с необходимыми мандантом/группой/системой?
A: В expert-mode строке соединения
conn=/H/prd.eu.merben.com/S/3210&clnt=101/G/LogonGroup14/R/ITP
параметры означают следующее:
/H/prd.eu.merben.com – хост
clnt=101, 3210 – клиент, порт
/G/LogonGroup14 – группа
/R/ITP – система
(подробнее)

Button	Shortcut	Description
	Клавиша „Ввод“ (Enter)	Далее (Enter/Continue)
	Ctrl+S	Сохранить (Save)
	F3	Назад (Back)
	Shift+F3	Выход из задачи, системы (Exit)
	F12	Отмена (Cancel)
	Ctrl+P	Печать (Print)
	Ctrl+F	Поиск, найти (Search, Find)
	Ctrl+G	Искать далее (Continue search)
	PageUp	На страницу вверх
	Page Down	На страницу вниз
	Ctrl+Page Up	На самый верх документа (To top)
	Ctrl+Page Down	К последней странице документа (To last page of document)
	Ctrl и „+“	Запустить новую сессию (Create New Session доступно и из системного меню Alt+пробел)
	Ctrl+F6	Отобразить результаты (Display results)
	Alt+F12	Настройка внешнего вида (Customize local layout)
	F8	Запустить / исполнить (Execute)

17 03 2011

ALV & Internal table

Ruslan ABAP ABAP 0

INCLUDE ZDATAI_TOP:

TABLES:
  vbap,
  marc,
  sscrfields.

DATA: BEGIN OF sd_main OCCURS 0.
  data matnr like marc-matnr.
  data vbeln like vbap-vbeln.
  data arktx like vbap-arktx.
  data kdmat like vbap-kdmat.
  data stdpd like marc-stdpd.
DATA: END OF sd_main.

TABLES:

vbap,

marc,

sscrfields.

DATA: BEGIN OF sd_main OCCURS 0.

data matnr like marc-matnr.

data vbeln like vbap-vbeln.

data arktx like vbap-arktx.

data kdmat like vbap-kdmat.

data stdpd like marc-stdpd.

DATA: END OF sd_main.

INCLUDE ZSD_SEL:

SELECTION-SCREEN SKIP.
SELECTION-SCREEN BEGIN OF BLOCK selection WITH FRAME TITLE text-001.
SELECTION-SCREEN BEGIN OF LINE.
SELECTION-SCREEN COMMENT (32) text-a11 FOR FIELD p_datef.
PARAMETERS :     p_datef LIKE sy-datum DEFAULT space.  "OBLIGATORY.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN BEGIN OF LINE.
SELECTION-SCREEN COMMENT (32) text-a12 FOR FIELD p_datet.
PARAMETERS :     p_datet LIKE sy-datum DEFAULT sy-datum OBLIGATORY.
SELECTION-SCREEN END OF LINE.

SELECTION-SCREEN SKIP.
SELECTION-SCREEN BEGIN OF BLOCK dest WITH FRAME TITLE text-e10.
PARAMETERS :     dest LIKE rfcdisplay-rfcdest DEFAULT 'NONE'.
SELECTION-SCREEN END OF BLOCK dest.
SELECTION-SCREEN BEGIN OF BLOCK optional WITH FRAME TITLE d10.
SELECT-OPTIONS : s_matnr FOR vbap-matnr.
SELECT-OPTIONS : s_vbeln  FOR vbap-vbeln.              "Transaction Code
SELECTION-SCREEN END OF BLOCK optional.
SELECTION-SCREEN END OF BLOCK selection.

SELECTION-SCREEN SKIP.
SELECTION-SCREEN PUSHBUTTON 1(10) bt1 USER-COMMAND uc2.

AT SELECTION-SCREEN.
  CASE sscrfields-ucomm.
    WHEN 'UC2'.
      CLEAR: s_matnr, s_vbeln, p_datef, p_datet.
  ENDCASE.

SELECTION-SCREEN SKIP.

SELECTION-SCREEN BEGIN OF BLOCK selection WITH FRAME TITLE text-001.

SELECTION-SCREEN BEGIN OF LINE.

SELECTION-SCREEN COMMENT (32) text-a11 FOR FIELD p_datef.

PARAMETERS : p_datef LIKE sy-datum DEFAULT space. "OBLIGATORY.

SELECTION-SCREEN END OF LINE.

SELECTION-SCREEN BEGIN OF LINE.

SELECTION-SCREEN COMMENT (32) text-a12 FOR FIELD p_datet.

PARAMETERS : p_datet LIKE sy-datum DEFAULT sy-datum OBLIGATORY.

SELECTION-SCREEN END OF LINE.

SELECTION-SCREEN SKIP.

SELECTION-SCREEN BEGIN OF BLOCK dest WITH FRAME TITLE text-e10.

PARAMETERS : dest LIKE rfcdisplay-rfcdest DEFAULT 'NONE'.

SELECTION-SCREEN END OF BLOCK dest.

SELECTION-SCREEN BEGIN OF BLOCK optional WITH FRAME TITLE d10.

SELECT-OPTIONS : s_matnr FOR vbap-matnr.

SELECT-OPTIONS : s_vbeln FOR vbap-vbeln. "Transaction Code

SELECTION-SCREEN END OF BLOCK optional.

SELECTION-SCREEN END OF BLOCK selection.

SELECTION-SCREEN SKIP.

SELECTION-SCREEN PUSHBUTTON 1(10) bt1 USER-COMMAND uc2.

AT SELECTION-SCREEN.

CASE sscrfields-ucomm.

WHEN 'UC2'.

CLEAR: s_matnr, s_vbeln, p_datef, p_datet.

ENDCASE.

REPORT  Z_ITJX

INCLUDE zdatai_top.
INCLUDE zsd_sel.

TYPE-POOLS: slis.  " SLIS contains all the ALV data types

DATA: it_fieldcat  TYPE slis_t_fieldcat_alv,
      wa_fieldcat  TYPE slis_fieldcat_alv.

DATA: it_vbak LIKE sd_main OCCURS 0.
      
 SELECT * FROM vbap "UP TO 500 ROWS
   INNER JOIN marc
   ON  vbap~matnr EQ marc~matnr
"   AND vbak~vbeln EQ vbap~vbeln
   INTO  CORRESPONDING FIELDS OF TABLE sd_main
   WHERE vbap~matnr IN s_matnr.

  wa_fieldcat-fieldname  = 'VBELN'.    " Fieldname in the data table (sd_main)
  wa_fieldcat-seltext_m  = 'Sales document'.   " Column description in the output
  APPEND wa_fieldcat TO it_fieldcat.

  wa_fieldcat-fieldname  = 'KDMAT'.
  wa_fieldcat-seltext_m  = 'Client material'.
  APPEND wa_fieldcat TO it_fieldcat.

  wa_fieldcat-fieldname  = 'MATNR'.
  wa_fieldcat-seltext_m  = 'Material number'.
  APPEND wa_fieldcat TO it_fieldcat.

  wa_fieldcat-fieldname  = 'ARKTX'.
  wa_fieldcat-seltext_m  = 'Description'.
  APPEND wa_fieldcat TO it_fieldcat.

  wa_fieldcat-fieldname  = 'STDPD'.
  wa_fieldcat-seltext_m  = 'KMAT'.
  APPEND wa_fieldcat TO it_fieldcat.

*Pass data and field catalog to ALV function module to display ALV list
  CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
    EXPORTING
      it_fieldcat   = it_fieldcat
    TABLES
      t_outtab      = sd_main 
    EXCEPTIONS
      program_error = 1
      OTHERS        = 2.

REPORT Z_ITJX

INCLUDE zdatai_top.

INCLUDE zsd_sel.

TYPE-POOLS: slis. " SLIS contains all the ALV data types

DATA: it_fieldcat TYPE slis_t_fieldcat_alv,

wa_fieldcat TYPE slis_fieldcat_alv.

DATA: it_vbak LIKE sd_main OCCURS 0.

SELECT * FROM vbap "UP TO 500 ROWS

INNER JOIN marc

ON vbap~matnr EQ marc~matnr

" AND vbak~vbeln EQ vbap~vbeln

INTO CORRESPONDING FIELDS OF TABLE sd_main

WHERE vbap~matnr IN s_matnr.

wa_fieldcat-fieldname = 'VBELN'. " Fieldname in the data table (sd_main)

wa_fieldcat-seltext_m = 'Sales document'. " Column description in the output