SAP SD complex instructions
Sales and Distribution
  • EDI und JIT
  • Java
  • ABAP
  • Contacts
0
Your cart is empty. Go to Shop.
17 03 2011

ALV & Internal table

Ruslan ABAP ABAP 0

INCLUDE ZDATAI_TOP:

1
2
3
4
5
6
7
8
9
10
11
12
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:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
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.

11 02 2011

SD Training Curriculum

Ruslan Exam, IMG, nützlich 1

Day 1

Overview

Introduction, SAP, GUI, Versions, Modules

Day 2

ASAP Methodology

Day 3

System Landscape

Day 4

Transports, Customization, Configuration

Day 5

General explanation of Inquiry to Cash Cycle, Enterprise Structure, Customer Master etc.

Day 6

Master data

Customer Master, Material Master, Customer Material Info Record

Day 7

Pricing

Day 8

Credit management, Accounts

Day 9

Outputs

Day 10

Text, Incompletion log

Day 11

Documents

Sales documents

Day 12

Delivery documents

Day 13

Billing documents

Day 14

Copy Control

Day 15

Item Categories, Schedule lines

Day 16

Processes

Standard ITC / QTC/ OTC Cycle

Day 17

Return Scenario, STO

Day 18

Availability Check, Transfer of Requirements

Day 19

Sales BOM, Intercompany, 3rd Party

Day 20

Consignments

Day 21

Technical

RICEFs

Day 22

IDOC/EDI

Day 23

OSS Notes

Day 24

SD Tables

Day 25

Routines, User Exits

Day 26

Getting Ready

Queries

Day 27

Online help – SAP help site, forums, SDN, BPX

Day 28

Resume templates

Day 29

Mock Interview / tips for technical screenings, face to face interviews

Day 30

Certificate of Completion

15 08 2010

1C vs SAP (холивар – 1С или SAP?)

Ruslan Fun, SAP 1C, SAP 36

THE DRAMA!!!11
Комментарии к этой статье несоизмеримо круче самой статьи! Рекомендуем ознакомиться и поучаствовать, иначе впечатление будет неполным.
(см. также Взгляд IT-специалиста на SAP ERP)
PDF-документы и текст пересохранены.

+Бонус! 1 (сохранено в развернутом виде с lnkd): 1C vs SAP
+Бонус! 2 (сохранено одной страницей с mist): SAP vs 1C

1CSAP
Пара брошюр по ERP системам:

ERP for Small Businesses: A Buyer’s Guide
Очень интересно было почитать. Но… в первую очередь рекомендую изучать народу 1С! Вот как надо делать раздатку и убеждать клиентов. Из краткого описания содержания этой работы некоторые куски нужно прямо вставлять в свои материалы!

А это вступительная статья – ERP Systems Buyer’s Guide. Несколько полезных тезисов есть и здесь.

03 05 0218

ABAP: rename file on Application server

Ruslan ABAP ABAP 0

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
form datei_umbenennen using lv_altpfad lv_neupfad type string.
  data: lv_eof_reached   type c,
        lv_buffer(20480),
        lv_buflen        type i.
 
  open dataset lv_altpfad for input in binary mode.
  if sy-subrc ne 0.
    raise open_input_file_failed.
  endif.
 
  open dataset lv_neupfad for output in binary mode.
  if sy-subrc ne 0.
    raise open_output_file_failed.
  endif.
 
  clear lv_eof_reached.
 
  do.
    clear lv_buffer.
 
    read dataset lv_altpfad
            into lv_buffer length lv_buflen.
 
    if sy-subrc = 4.
      lv_eof_reached = 'X'.
    elseif sy-subrc > 4.
      raise read_block_failed.
    endif.
 
    transfer lv_buffer to lv_neupfad
      length lv_buflen.
 
    if sy-subrc ne 0.
      raise write_block_failed.
    endif.
 
    if lv_eof_reached eq 'X'.
      exit.
    endif.
  enddo.
 
  close dataset lv_altpfad.
  close dataset lv_neupfad.
  if sy-subrc <> 0.
    raise close_output_file_failed.
  endif.
 
  delete dataset lv_altpfad.
endform.

«< 3 4 5 6 7

Neueste Beiträge

  • Geschützt: RFC Server C# for remote calls from ABAP
  • Geschützt: Convert spool list to internal table
  • Geschützt: ABAP: iterate field values and field names of unknown table
  • Setup Dangerous Goods
  • Debugger-Scripting

Recent Comments

  • Ruslan: method loeshmerkmal. check it_objek is not initial. data: w…
  • uchla: ZY-code search sap-blog.ru/ideja-skript-dlja-otladchika-poi…
  • uchla: SAP Dunning / SAP Mahnung - Что это? В SAP, ​​е…
  • Schellenberg Michael: Really nice document to understand the Creation of New Move…
  • Anthony: I'm enquiring on the opposite. I have unchecked "Generation…
SAP SD complex instructions
© 2003-2020, Uchla | Alle Rechte vorbehalten