지니 loves 소은

1) AKO (Expense/Revenue from Material Consumption)

위탁자재(Vendor Consignment)를 생산에 투입하거나 일정기간 경과 후 회사재고로 소유권을 이동할 때 Standard Price 를 사용하는 경우 Vendor Consignment Price 와 Material Master상의 Standard Price 의 차이분을 처리 

① Consignment 입고 : 회계전표 없음

   Consignment Price 1,010

② 생산에 소비 ③ 소유권 이전

   재료비(GBB-VBR) 1000        /     A/P-위탁자재(KON) 1010

   손실-소모차(AKO) 10         /

2) AUM (Expense/Revenue from Stock Transfer)

Plant 간 자재이동이 일어날 때 Standard Price 의 차이로 인해 발생한 차액을 기표

Price Type(S) 재고자산(BSX) 80        /     재고자산(BSX) 100

               재고이동차(AUM) 20    /

Price Type(V) 재고자산(BSX) 100 /     재고자산(BSX) 100

3) BO1 (Rebates)

Vendor 로부터 Volume-Based Rebate 계약을 체결하고 구매할 때 예상 Rebate 금액을 

미수 Rebate 로 기표 처리

재고자산(BSX) 97    /     GR/IR Clearing(WRX) 100

미수Rebate(BO1) 3  /

4) BO2 (Volume Rebate Income)-Subsequent Settlement of Conditions

Vendor 와의 Volume-Based Rebate에 근거하여 계약기간 종료 후 Rebate 정산기표시

미수 Rebate 와 실제 Rebate 사이의 차액을 수익으로 기표

Rebate 수익(BO2) 3  / 미수 Rebate(BO1) 3

A/P               4 / Rebate 수익(BO2) 4

5) BSV(Change in Stock Account)

무상사급(Subcontracting) 자재의 입고, 반품된 자재의 처리시 사용되는 상대계정

① 원재료 불출 : 회계전표 없음

② 반제품 입고

 반제품(BSX) 1000   /     반제품대체(BSV) 1000

 원재료비(GBB-VBO) 800   /     원재료(BSV) 800

 외주가공비(FRL) 200       /     GR/IR Clearing(WRX) 200

6)  BSX(Inventory Posting)

자재의 입출고로 인한 재고자산의 변동시 사용하는 재고자산 계정을 지정

원재료(BSX) 100     /     GR/IR Clearing(WRX) 100

7) DIF(Material Management Small Differences)

Invoice Verification 시 Balance 가 Zero가 되지않으나 그 차이금액이 미리 설정한 허용 한도 내에 있을 경우 자동으로 Balance를 맞추어주기 위한 대차조정계정

(GR/IR과 I/V 시점차이로 인한 단가 차이와는 성격이 다름)

① P/O 생성시 설정한 구매단가로 G/R

재고자산(BSX) 1001    /     GR/IR(WRX) 1001

② I/V시 확정단가(1000)

GR/IR 1001       /     A/P 1000

/      Small Price Difference(DIF) 1

8) EIN(Purchasing Account)-Purchase Account Active 시

프랑스, 스페인 등 특정국가에서 재고자산의 순수한 구매량을 원계정과는 별도의 계정 (Purchase Account)과 이에 대한 상대계정(Offsetting Purchase Account)으로 구분하여 관리하려고 하는데 이 Transaction Event Key는 재고자산에 대응되는 계정을 지정하여 이 계정은 P+L 계정임.

자재입고시

재고자산(BSX) 100           /        GR/IR(WRX) 100

Purchase Account(EIN) 100   /   Offsetting Purchase Account(EKG) 100

9) EKG(Offsetting Purchasing Account)-Purchase Account Active 시 

EIN 참조

10) FR1(Freight Clearing)

MM에서 Delivery Cost를 처리하는 경우

① 매입과 관련된 운반비, 관세 등의 매입부대비용을 처리

② 매입부대비용은 재고자산의 취득원가에 산입해야 함 (MAP 사용시)

③ 예상매입부대비(Planned Delivery Cost)는 P/O 생성시에 설정한다.

-     G/R시                       재고자산(BSX) 1000 / GR/IR(WRX) 800

                                                      / Freight Clearing(FR1) 50

                                                      / Customer Clearing(FR3) 150

-     물대에 대한 I/V시                GR/IR(WRX) 800 / A/P(물대 Vendor) 800

-     부대비에 대한 I/V시       Freight Clearing(FR1) 50 / A/P 50

                           Customer Clearing(FR3) 150 / A/P 150

④ 실발생 부대비가 표준부대비와 차이가 있는 경우

-     입고후 I/V 처리                       Freight Clearing(FR1) 50 / A/P 60

                                                  재고자산(BSX) 10 /

-     I/V가 먼저 일어나는 경우               Freight Clearing(FR1) 60 / A/P 60

-     G/R이 이후에 일어나는 경우             재고자산(BSX) 60 / Freight Clearing(FR1) 60

11) FR2(Freight Provisions)

일반적으로 매입부대비를 나타내는 Condition Type은 Condition Category가 "B:Delivery Costs"로 

설정되며 FR1은 이에 준한 Procedure임. 그러나 부대비 관련 Condition Type의 Condition Category를 "F:Freight"로 설정하면 G/R시 자동 설정된 Freight Clearing 계정이 I/V 시에는 차변에 나타나지 않는다. 즉, 그러한 Condition Type 으로 설정된 부대비에 대해서는 I/V 시 Planned Delivery Cost로 나타나지 않으며 실발생비용을 기표하기 위해서는 I/V 또는 FI에서 수작업기표 해야함.

-  G/R 시

재고자산(BSX) 1000    /     GR/IR Clearing(WRX) 900

                       /      Freight Clearing(FR1) 40

                       /      Freight Provision(FR2) 60

- I/V시 (Planned Delivery Cost 를 이용)

GR/IR Clearing(WRX) 900     /     A/P(물대) 900

Freight Clearing(FR1) 40       /      A/P(부대비) 40

- I/V 또는 FI에서 실 발생비용 처리(수작업처리)

재고자산 또는 비용 60  /     A/P 60

12) FR3 (Other Freight Costs)

FR1 참조

13) FR4 (Special Freight Charges)

 기타 부대비를 처리하며 처리흐름은 FR2와 동일

14) FRE (Purchasing Freight Account)-Purchase Account Active 시

Purchase Account(EIN,EKG) 처리시 별도로 운송료를 기표할 필요가 있을 때 지정

재고자산(BSX) 1020  /     GR/IR(WRX) 1000

Freight(FRE) 20      /     Freight Clearing(FR1) 20

Purchase(EIN) 1000  /     Purchase Offsetting(EKG) 1020

15) FRL(External Activity)

무상사급(Subcontracting) 자재의 입고시 가공비를 처리하기 위한 계정 지정

BSV 참조

16) FRN (Incidental Costs of Activities)

무상사급(Subcontracting) 자재의 입고시 부수적으로 발생한 비용(Delivery Cost)을 처리하기 위한 

계정 지정

① 원재료 불출 → 회계전표 없음

② 반제품 입고

반제품(BSX) 1000          /  반제품대체(BSV) 1000

원재료비(GBB-VBO) 800   /   원재료(BSX) 800

외주가공비(FRL) 200       /  GR/IR Clearing(WRX) 200

외주가공-운반비(FRN) 20  /   Freight Clearing(FR1) 20

17) GBB(Offsetting Entry for Inventory Posting)-AUA(For Order Settlement)

Production Order를 Settle 할 때 사용되는 상대계정으로 Settle 시 AUF에 지정된 계정에 우선한다.

-     기본데이타 : Component → S 25$ , material → S 100$

-     Create Production Order(Component 10개로 10개 생산)

-     Release Production Order

-     Goods Issue Components to Production Order

  Component 10개 출고

  재료비(GBB-VBR) 250 / 재고자산-Components(BSX) 250

-     Goods Receipt Material With Reference to P/O

  재고자산-Material(BSX) 1000 / Factory Output(GBB-AUF) 1000

-     Settle Production Order

  Factory Output-Settle(GBB-AUA) 750 / Price Variance(PRD) 750

18) GBB(Offsetting Entry for Invemtory Posting)-AUF(G/R for Assigned Orders/Order Settlement)

Production Order 로부터 생산완료 후 제품입고가 일어날 경우 제품에 대한 상대계정이며

Produntion Order를 Settle 할 때 사용되는 상대계정

GBB-AUA 참조

19) GBB(Offsetting Entry for Inventory Posting)-BSA(Initial Entry of Stock Balances)

기초 재고를 설정하기 위한 계정지정

재고자산(BSX) 100 / 초기재고(GBB-BSA) 100

20) GBB(Offsetting Entry for Inventory Posting)-INV(Order/Income from Inventory Differences)

실지 재고조사에 의해 수량차이를 Posting 하기 위한 계정 지정을 처리하며 실사수량을 입력하면 

장부상의 재고수량과 비교하여 차이분을 기표처리

-  부족시

   수량차(GBB-INV) 100    /     재고자산(BSX) 100

-  과잉시

재고자산(BSX) 100      /     수량차(GBB-INV) 100

21) GBB (Offsetting Entry for Inventory Posting) - VAX (G/I for Customer Orders Without Account Assignment)

SD에서 Delivery 시 매출원가계정을 지정하기 위한 것으로 Sales Order 를 참조하지 않는 경우이다.

매출원가(GBB-VAX) 100 / 재고자산 (BSX) 100

22) GBB (Offsetting Entry for Inventory Posting) - VAY (G/I for Customer Order with Account Assignment)

SD에서 Delivery 시 매출원가계정을 지정하기 위한 것으로 Sales Order 를 참조하는 일반적인 경우이다.

23) GBB (Offsetting Entry for Inventory Posting) - VBO (Consumption from Material Stock Provided to Vendor)

BSV 참조

24) GBB (Offsetting Entry for Inventory Posting) - VBR (Consumption for Internal Goods Issues)

Cost Center, Production Order, Project 등 Cost Object 로 자재가 출고되어 소비되는 경우의 계정 지정

- 기본데이타 : Component → S 25$, Material → S 100$

- Create Production Order ( Component 10개로 10개 생산)

- Release Production Order

- Goods Issue Components to Production Order

  Component 10개 출고

  재료비(GBB-VBR) 250 / 재고자산-Components(BSX) 250

- Goods Receipt Material With Reference to P/O

  재고자산-Material(BSX) 1000 / Factory Output(GBB-AUF) 1000

- Settle Production Order

  Factory Output-Settle(GBB-AUA) 750 / Price Variance(PRD) 750

25) GBB(Offsetting Entry for Inventory Posting) - VKA (Consumption Customer Order Without SD)

Sales Order 로 직접 원가를 귀속하는 자재의 출고시 원가계정 지정(SD의 Delivery 사용 않는 경우)

재료비(GBB-VKA) 100 / 재고 자산(BSX) 100

26) GBB(Offsetting Entry for Inventory Posting) - VNG (Scrapping/Destruction)

Scrap 으로 자재가 출고되는 경우 계정 지정

재료비-Scrap(GBB-VNG) 100 / 재고자산(BSX) 100

27) GBB(Offsetting Entry for Inventory Posting) - VQP(Sampling without Account Assignment)

품질검사를 위한 Sample을 출고하는 경우의 계정 지정

제비용(GBB-VQP) 100 / 재고자산(BSX) 100

28) GBB(Offsetting Entry for Inventory Posting) - VQY(Sampling with Account Assignment)

품질검사를 위한 Sample을 CO Object 로 출고하는 경우 계정 지정

견본비(GBB-VQY) 100 / 재고자산(BSX) 100

29) GBB(Offsetting Entry for Inventory Posting) - ZOB(Goods Receip w/o Purchase Order)

Purchase Order 없이 자재입고시 사용하는 계정으로 주문수량 외에 Vendor 가 추가로 제공하는 자재를 처리하는 경우

재고자산(BSX) 100 / 영업외수익(GBB-ZOB) 100

30) GBB(Offsetting Entry for Inventory Posting) - ZOF(Goods Receipt without Production Order)

Production Order 없이 자재를 입고할 경우 사용하는 계정으로 부산물(BY-Product)등의 입출고시 사용

재고자산-부산물(BSK) 100 / Inventory Change(ZOF) 100

31) KBS(Account-Assigned Purchase Order)

일반적으로 Purchase Order를 통해 입고 처리하게 되면 차변에 재고자산 계정(BSX)이 기표되는데, 만일 이를 다른 계정으로 바꾸고자 한다면(비용계정, 고정자산등) P/O 생성시 Account Assignment Category 필드를 별도 지정함 (A, K, P 등)

32) KDM(Materials Management Exchange Rate Differences)

G/R 과 I/V 시점차이에 의해 발생하는 환차손익 기표계정 지정

- G/R 시점(1$=1000원)

  재고자산(BSX) \1000 / GR/IR(WRX) \1000

- I/V 시점(1$=1500원)

  GR/IR \1000 / A/P \1500

  환차손(KDM) \500 /

33) KDR(Material Management Exchange Rate Rounding Differences)

Transaction Currecy 와 Local Currency 의 소수점 이하 허용 자리수 제한(System에서 Default로 소수점 이하 2자리로 규정)으로 반올림시 발생하는 금액차이를 처리하는 계정 지정

Local Currency : DEM

Transaction Currecy : GBP

Exchange Rate : 1.995

Price : 1GBP / 1 ITEM

- Transaction Currency 전표

  현금 1.00GBP / AP 2.00GBP

  현금 1.00GBP / 외환차익(KDR) 0.00GBP

- Local Currecy 전표

     현금 2.00DEM / A/P 3.99DEM

  현금 2.00DEM / 외환차익(KDR) 0.01DEM

34) KON (Consignment Payables)

AKO 참조

35) KTR(Price Difference Offsetting Entry (Cost Object)

PRK Process 의 상대 계정

- 비용처리

  영업외비용(PRK) 100 / Factory Output(KTR) 100

- 수익처리

  Factory Output(KTR) 100 / 영업외수익(PRK) 100

36) PRD (Cost(Price) Differences))

Standard Price 를 사용하는 경우

모든 재고자산의 이동에서 발생한 가격차이를 처리하기 위한 계정 지정.

예) 입고시 참조한 Purchase Order 상의 단가와 Master상의 표준원가가 다를 때

 및 I/V시 입고단가와 확정단가가 다를 때 그 차이 분을 기표

재고자산(BSX) 980 / GR/IR(WRX) 1000

Price Difference(PRD) 20 /

Moving Average Price 를 사용하는 경우

Stock 100PCS @ 1.20/PC

P/O 100PCS @ 1.30/PC

G/R for P/O : 100PCS

Goods Withdrawal : 120PCS

Invoice : 100PCS @ 1.40/PC

37) PPK(Price Differences (Cost Object Hierarchy))

PRD와 같은 역할을 하지만 Cost Object Hierarchy 상에서 발생한 경우에 사용

- 비용처리

  영업외비용(PPK) 100 / Factory Output(KTR) 100

- 수익처리

Factory Output(KTR) 100 / 영업외수입(PRK) 100

38) PRY-Cost (Price) Differences(Material Ledger)

Moving Average Price 를 사용하는 자재의 경우 Purchase Order 상의 단가와 수량을 곱한 금액과 Material Master 상의 단가와 수량을 곱한 금액의 차이를 거래건별 전표로 기표함으로써 표준 원가와 실제 원가의 차이를 나타냄

자재입고시

(1) 원재료(BSX) 95 / GR/IR(WRX) 100

    가격차(PRD) 5 /

(2) 원재료(BSX) 5 / 가격차(PRY) 5

    Standard Price 를 사용하는 제품, 상품 등의 경우는 월말에 Material ledger Settlement 시 

    일괄 전표 처리함.

가격차(PRY) 100 / 재고자산(BSX) 100

39) UMB(Revenue/expense from revaluation)

재고자산의 Standard Price 를 변경하거나 전월분 기표를 하는 경우의 계정 지정

(차) 재고자산 300 (대) 가격차 300

(BSX)               (UMB)

40) WRX(Goods receipt/inv.receipt clearing acct)

자재의 입고시점과 매입채무 확정시점의 차이로 인해 실시간으로 정확한 데이터가 FI에 반영되지 못하므로 이를 보전하는데 필요한 조정계정 지정

-입고시(GR)

(차) 재고자산 200  (대)GR/IR Clearing 200

(BSX)            (WRX)

-매입채무 확정시(IV)

(차) GR/IR Clearing 200 (대) AP 200

 (WRX)

Goods Receipt

자재(Material)을 조달하기 위해 Purchase order를 생성했다면 입고시에 purchase order번호를 참조하여 입고처리를 한다.

예를 들면 material 운송품목이 주문품목과 같은지 check하거나 입고량과 주문량의 비교,부폐하기

쉬운 상품에 대해서 유효일 check등 시스템이 purchase order와 입고정보를 check한다.

purchase order를 참조하여 입고되면 입고내역이 purchase order history에 update되어 purchase order history만 조회하면 그동안의 purcase order에 대해 입고된 내역이 비교된다.

구매발주(PO)를 낸 자재를 입고(Goods Receipt)하는 법

- Purchase Order를 참조하여 Goods Receipt를 Post할 수 있다.

입고처리가 완료되면 두 가지의 문서(document)가 생성되는 데

하나는 입고처리를 나타내는 Material Document와 material valuation에 관련되어 stock value를 나타내는 accouning document가 생성된다.

이 밖에도 Purchase order history가 delivery결과에 따라 update되고 지연된 delivery에 대해서

vendor에게 reminder를 보낼 수 있다.(reminder는 vendor master에서 미리 setting되어야 한다.)

Movement Type은 자재(material)의 이동(movement)가 발생할 모든 경우 사용되어 진다.

즉 자재의 입고(receipts),출고(Goods issue),이동(transfer posting)시에 movement type을 입력된다.

이 Movement type은 Inventory Management에서 중요한 control을 하는 기능이 있다.

movement type에 따라 account(계정)이 자동 결정되어 지며 stock이나 consumption(폐기)

account를 결정할 수 있다. 또한 document가 언제 입력하고 어떻게 수량이 update되어지는 지

그 format을 결정한다.

Create_Goods_Receipt2.ppt

https://www.consolut.com/en/s/sap-ides-access/d/s/doc/B-ABENNEWS-740_SP05-OPEN_SQL

Include 이용하여 Internal Table등을 선언할때 

Renaming with suffix 라는 명령어를 사용하면 기존의 이름 뒤에 이름을 붙여주는 기능이네요.

잘 사용하면 편리할것 같습니다.

TYPES BEGIN OF ty_data.
  INCLUDE TYPE jcds AS status_change RENAMING WITH SUFFIX _change.
  INCLUDE TYPE tj02t AS status_text RENAMING WITH SUFFIX _text.
TYPES END OF ty_data.

DATA: lt_status TYPE STANDARD TABLE OF ty_data.
SELECT  jcds~*,
           tj02t~*
  FROM  jcds INNER JOIN tj02t
    ON  jcds~stat = tj02t~istat
 WHERE  tj02t~spras = @sy-langu
  INTO  TABLE @lt_status
UP TO 100 ROWS.

IF sy-subrc = 0.
  cl_demo_output=>display_data(
  EXPORTING
  value = lt_status
  name = 'New AGE SQL : 9' ).
ENDIF.

따로 변수 선언같은거 없이 check 가 가능하네요.

편리할것 같고 빠른것은 별 차이가 없을것 같고요.

*&---------------------------------------------------------------------*
*& Report  ZTEST_SOURAV_EXCEL
*&
*&---------------------------------------------------------------------*
*& Sourav Bhaduri 02-Dec-2008
*&---------------------------------------------------------------------*
 
REPORT  ztest_sourav_excel NO STANDARD PAGE HEADING.
 
DATA:
oref_container   TYPE REF TO cl_gui_custom_container,
iref_control     TYPE REF TO i_oi_container_control,
iref_document    TYPE REF TO i_oi_document_proxy,
iref_spreadsheet TYPE REF TO i_oi_spreadsheet,
iref_error       TYPE REF TO i_oi_error.
 
DATA:
v_document_url TYPE c LENGTH 256,
i_sheets TYPE soi_sheets_table,
wa_sheets TYPE soi_sheets,
i_data        TYPE soi_generic_table,
wa_data       TYPE soi_generic_item,
i_ranges      TYPE soi_range_list.
 
PARAMETERS:
p_file  TYPE  localfile OBLIGATORY,
p_rows TYPE i DEFAULT 100 OBLIGATORY, "Rows (Maximum 65536)
p_cols TYPE i DEFAULT 10 OBLIGATORY.    "Columns (Maximum 256)
 
INITIALIZATION.
 
  CALL METHOD c_oi_container_control_creator=>get_container_control
     IMPORTING
       control = iref_control
       error   = iref_error
*      retcode =
      .
  IF iref_error->has_failed = 'X'.
    CALL METHOD iref_error->raise_message
      EXPORTING
        type = 'E'.
  ENDIF.
 
 
  CREATE OBJECT oref_container
    EXPORTING
*      parent                      =
       container_name              = 'CONT'
*      style                       =
*      lifetime                    = lifetime_default
*      repid                       =
*      dynnr                       =
*      no_autodef_progid_dynnr     =
    EXCEPTIONS
       cntl_error                  = 1
       cntl_system_error           = 2
       create_error                = 3
       lifetime_error              = 4
       lifetime_dynpro_dynpro_link = 5
       OTHERS                      = 6.
  IF sy-subrc <> 0.
    MESSAGE e001(00) WITH 'Error while creating container'.
  ENDIF.
 
  CALL METHOD iref_control->init_control
    EXPORTING
*      dynpro_nr                = SY-DYNNR
*      gui_container            = ' '
       inplace_enabled          = 'X'
*      inplace_mode             = 0
*      inplace_resize_documents = ' '
*      inplace_scroll_documents = ' '
*      inplace_show_toolbars    = 'X'
*      no_flush                 = ' '
*      parent_id                = cl_gui_cfw=>dynpro_0
       r3_application_name      = 'EXCEL CONTAINER'
*      register_on_close_event  = ' '
*      register_on_custom_event = ' '
*      rep_id                   = SY-REPID
*      shell_style              = 1384185856
       parent                   = oref_container
*      name                     =
*      autoalign                = 'x'
    IMPORTING
       error                    = iref_error
*      retcode                  =
    EXCEPTIONS
       javabeannotsupported     = 1
       OTHERS                   = 2
          .
  IF iref_error->has_failed = 'X'.
    CALL METHOD iref_error->raise_message
      EXPORTING
        type = 'E'.
  ENDIF.
 
  CALL METHOD iref_control->get_document_proxy
    EXPORTING
*     document_format    = 'NATIVE'
      document_type      = soi_doctype_excel_sheet
*     no_flush           = ' '
*     register_container = ' '
     IMPORTING
       document_proxy     = iref_document
       error              = iref_error
*    retcode            =
      .
  IF iref_error->has_failed = 'X'.
    CALL METHOD iref_error->raise_message
      EXPORTING
        type = 'E'.
  ENDIF.
 
AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.
 
* To provide F4 help for the file
  PERFORM sub_file_f4.
 
START-OF-SELECTION.
 
  CONCATENATE 'FILE://' p_file INTO v_document_url.
 
  CALL METHOD iref_document->open_document
    EXPORTING
      document_title   = 'Excel'
      document_url     = v_document_url
*     no_flush         = ' '
      open_inplace     = 'X'
*     open_readonly    = ' '
*     protect_document = ' '
*     onsave_macro     = ' '
*     startup_macro    = ''
*     user_info        =
    IMPORTING
      error            = iref_error
*     retcode          =
      .
  IF iref_error->has_failed = 'X'.
    CALL METHOD iref_error->raise_message
      EXPORTING
        type = 'I'.
    LEAVE LIST-PROCESSING.
  ENDIF.
 
  CALL METHOD iref_document->get_spreadsheet_interface
     EXPORTING
       no_flush        = ' '
    IMPORTING
      error           = iref_error
      sheet_interface = iref_spreadsheet
*     retcode         =
      .
 
  IF iref_error->has_failed = 'X'.
    CALL METHOD iref_error->raise_message
      EXPORTING
        type = 'I'.
    LEAVE LIST-PROCESSING.
  ENDIF.
 
  CALL METHOD iref_spreadsheet->get_sheets
      EXPORTING
       no_flush = ' '
*      updating = -1
     IMPORTING
       sheets   = i_sheets
       error    = iref_error
*      retcode  =
      .
  IF iref_error->has_failed = 'X'.
    CALL METHOD iref_error->raise_message
      EXPORTING
        type = 'I'.
    LEAVE LIST-PROCESSING.
  ENDIF.
  LOOP AT i_sheets INTO wa_sheets.
    CALL METHOD iref_spreadsheet->select_sheet
       EXPORTING
          name     = wa_sheets-sheet_name
*         no_flush = ' '
      IMPORTING
          error    = iref_error
*         retcode  =
            .
    IF iref_error->has_failed = 'X'.
      EXIT.
*      call method iref_error->raise_message
*        exporting
*          type = 'E'.
    ENDIF.
    CALL METHOD iref_spreadsheet->set_selection
      EXPORTING
        top     = 1
        left    = 1
        rows    = p_rows
        columns = p_cols.
 
    CALL METHOD iref_spreadsheet->insert_range
      EXPORTING
        name     = 'Test'
        rows     = p_rows
        columns  = p_cols
        no_flush = ''
      IMPORTING
        error    = iref_error.
    IF iref_error->has_failed = 'X'.
      EXIT.
*      call method iref_error->raise_message
*        exporting
*          type = 'E'.
    ENDIF.
 
    REFRESH i_data.
 
    CALL METHOD iref_spreadsheet->get_ranges_data
       EXPORTING
*        no_flush  = ' '
         all       = 'X'
*        updating  = -1
*        rangesdef =
       IMPORTING
         contents  = i_data
         error     = iref_error
*        retcode   =
       CHANGING
         ranges    = i_ranges
  
* Remove ranges not to be processed else the data keeps on adding up
        call method iref_spreadsheet->delete_ranges
          exporting
            ranges = i_ranges
 
 
             .
    DELETE i_data WHERE value IS INITIAL OR value = space.
    ULINE.
    WRITE:/1 wa_sheets-sheet_name COLOR 3.
    ULINE.
 
    LOOP AT i_data INTO wa_data.
      WRITE:(50) wa_data-value.
      AT END OF row.
        NEW-LINE.
      ENDAT.
    ENDLOOP.
  ENDLOOP.
 
  CALL METHOD iref_document->close_document
*  EXPORTING
*    do_save     = ' '
*    no_flush    = ' '
     IMPORTING
       error       = iref_error
*    has_changed =
*    retcode     =
      .
  IF iref_error->has_failed = 'X'.
    CALL METHOD iref_error->raise_message
      EXPORTING
        type = 'I'.
    LEAVE LIST-PROCESSING.
  ENDIF.
  CALL METHOD iref_document->release_document
*  EXPORTING
*    no_flush = ' '
     IMPORTING
       error    = iref_error
*    retcode  =
      .
  IF iref_error->has_failed = 'X'.
    CALL METHOD iref_error->raise_message
      EXPORTING
        type = 'I'.
    LEAVE LIST-PROCESSING.
  ENDIF.
 
*&---------------------------------------------------------------------*
*&      Form  SUB_FILE_F4
*&---------------------------------------------------------------------*
*       F4 help for file path
*----------------------------------------------------------------------*
FORM sub_file_f4 .
  DATA:
  l_desktop       TYPE string,
  l_i_files       TYPE filetable,
  l_wa_files      TYPE file_table,
  l_rcode         TYPE int4.
 
* Finding desktop
  CALL METHOD cl_gui_frontend_services=>get_desktop_directory
    CHANGING
      desktop_directory    = l_desktop
    EXCEPTIONS
      cntl_error           = 1
      error_no_gui         = 2
      not_supported_by_gui = 3
      OTHERS               = 4.
  IF sy-subrc <> 0.
    MESSAGE e001(00) WITH
        'Desktop not found'.
  ENDIF.
 
* Update View
  CALL METHOD cl_gui_cfw=>update_view
    EXCEPTIONS
      cntl_system_error = 1
      cntl_error        = 2
      OTHERS            = 3.
 
  CALL METHOD cl_gui_frontend_services=>file_open_dialog
     EXPORTING
       window_title            = 'Select Excel file'
       default_extension       = '.xls'
*      default_filename        =
       file_filter             = '.xls'
*      with_encoding           =
       initial_directory       = l_desktop
*      multiselection          =
    CHANGING
      file_table              = l_i_files
      rc                      = l_rcode
*     user_action             =
*     file_encoding           =
    EXCEPTIONS
      file_open_dialog_failed = 1
      cntl_error              = 2
      error_no_gui            = 3
      not_supported_by_gui    = 4
      OTHERS                  = 5
          .
  IF sy-subrc <> 0.
    MESSAGE e001(00) WITH 'Error while opening file'.
  ENDIF.
 
  READ TABLE l_i_files INDEX 1 INTO l_wa_files.
  IF sy-subrc = 0.
    p_file = l_wa_files-filename.
  ELSE.
    MESSAGE e001(00) WITH 'Error while opening file'.
  ENDIF.
 
ENDFORM.                    " SUB_FILE_F4

ME01                 Maintain Source List                  

ME03                 Display Source List                   

ME04                 Changes to Source List                

ME05                 Generate Source List                  

ME06                 Analyze Source List                   

ME07                 Reorganize Source List                

ME08                 Send Source List                      

ME0M                Source List for Material              

ME11                 Create Purchasing Info Record         

ME12                 Change Purchasing Info Record         

ME13                 Display Purchasing Info Record        

ME14                 Changes to Purchasing Info Record     

ME15                 Flag Purch. Info Rec. for Deletion    

ME16                 Purchasing Info Recs. for Deletion    

ME17                 Archive Info Records                  

ME18                 Send Purchasing Info Record           

ME1A                 Archived Purchasing Info Records      

ME1B                 Redetermine Info Record Price         

ME1E                 Quotation Price History               

ME1L                 Info Records Per Vendor               

ME1M                Info Records per Material             

ME1P                 Purchase Order Price History          

ME1W                Info Records Per Material Group       

ME1X                 Buyer's Negotiation Sheet for Vendor  

ME1Y                 Buyer's Negotiat. Sheet for Material  

ME21                 Create Purchase Order                 

ME21N               Create Purchase Order                              

ME22                 Change Purchase Order                              

ME22N               Change Purchase Order                              

ME23                 Display Purchase Order                             

ME23N               Display Purchase Order                             

ME24                 Maintain Purchase Order Supplement                 

ME25                 Create PO with Source Determination                

ME26                 Display PO Supplement (IR)                         

ME27                 Create Stock Transport Order                       

ME28                 Release Purchase Order                             

ME29N                Release purchase order                             

ME2A                 Monitor Confirmations                              

ME2B                 POs by Requirement Tracking Number                 

ME2C                 Purchase Orders by Material Group                  

ME2J                 Purchase Orders for Project                        

ME2K                 Purch. Orders by Account Assignment                

ME2L                 Purchase Orders by Vendor                          

ME2M                 Purchase Orders by Material                        

ME2N                 Purchase Orders by PO Number                       

ME2O                 SC Stock Monitoring (Vendor)                       

ME2S                 Services per Purchase Order                        

ME2V                 Goods Receipt Forecast                             

ME2W                 Purchase Orders for Supplying Plant                

ME308                Send Contracts with Conditions                     

ME31                 Create Outline Agreement                           

ME31K                Create Contract                                    

ME31L                Create Scheduling Agreement                        

ME32                 Change Outline Agreement                           

ME32K                Change Contract                                    

ME32L                Change Scheduling Agreement                        

ME33                 Display Outline Agreement                          

ME33K                Display Contract                                   

ME33L                Display Scheduling Agreement                       

ME34                 Maintain Outl. Agreement Supplement                

ME34K                Maintain Contract Supplement                       

ME34L                Maintain Sched. Agreement Supplement               

ME35                 Release Outline Agreement                          

ME35K                Release Contract                                   

ME35L                Release Scheduling Agreement                       

ME36                 Display Agreement Supplement (IR)                  

ME37                 Create Transport Scheduling Agmt.                  

ME38                 Maintain Sched. Agreement Schedule                 

ME39                 Display Sched. Agmt. Schedule (TEST)               

ME3A                 Transm. Release Documentation Record               

ME3B                 Outl. Agreements per Requirement No.               

ME3C                 Outline Agreements by Material Group               

ME3J                 Outline Agreements per Project                     

ME3K                 Outl. Agreements by Acct. Assignment               

ME3L                 Outline Agreements per Vendor                      

ME3M                 Outline Agreements by Material                     

ME3N                 Outline Agreements by Agreement No.                

ME3P                 Recalculate Contract Price                         

ME3R                 Recalculate Sched. Agreement Price                 

ME3S                 Service List for Contract                          

ME41                 Create Request For Quotation                       

ME42                 Change Request For Quotation                       

ME43                 Display Request For Quotation                      

ME44                 Maintain RFQ Supplement                            

ME45                 Release RFQ                                        

ME47                 Create Quotation                                   

ME48                 Display Quotation                                  

ME49                 Price Comparison List                              

ME4B                 RFQs by Requirement Tracking Number                

ME4C                 RFQs by Material Group                             

ME4L                 RFQs by Vendor                                     

ME4M                 RFQs by Material                                   

ME4N                 RFQs by RFQ Number                                 

ME4S                 RFQs by Collective Number                          

ME51                 Create Purchase Requisition                        

ME51N                Create Purchase Requisition                        

ME52                 Change Purchase Requisition                        

ME52N                Change Purchase Requisition                        

ME52NB               Buyer Approval: Purchase Requisition               

ME53                 Display Purchase Requisition                       

ME53N                Display Purchase Requisition                       

ME54                 Release Purchase Requisition                       

ME54N                Release Purchase Requisition                       

ME55                 Collective Release of Purchase Reqs.               

ME56                 Assign Source to Purch. Requisition                

ME57                 Assign and Process Requisitions                    

ME58                 Ordering: Assigned Requisitions                    

ME59                 Automatic Generation of POs                        

ME59N                Automatic generation of POs                        

ME5A                 Purchase Requisitions: List Display                

ME5F                 Release Reminder: Purch. Requisition               

ME5J                 Purchase Requisitions for Project                  

ME5K                 Requisitions by Account Assignment                 

ME5R                 Archived Purchase Requisitions                     

ME5W                 Resubmission of Purch. Requisitions                

ME61                 Maintain Vendor Evaluation                         

ME62                 Display Vendor Evaluation                          

ME63                 Evaluation of Automatic Subcriteria                

ME64                 Evaluation Comparison                              

ME65                 Evaluation Lists                                   

ME6A                 Changes to Vendor Evaluation                       

ME6B                 Display Vendor Evaln. for Material                 

ME6C                 Vendors Without Evaluation                         

ME6D                 Vendors Not Evaluated Since...                     

ME6E                 Evaluation Records Without Weighting               

ME6F                 Print                                              

ME6G                 Vendor Evaluation in the Background                

ME6H                 Standard Analysis: Vendor Evaluation               

ME6Z                 Transport Vendor Evaluation Tables                 

ME80                 Purchasing Reporting                               

ME80A               Purchasing Reporting: RFQs                        

ME80AN             General Analyses (A)                              

ME80F                Purchasing Reporting: POs                         

ME80FN              General Analyses (F)                              

ME80R                Purchasing Reporting: Outline Agmts.              

ME80RN               General Analyses (L,K)                            

ME81                 Analysis of Order Values                          

ME81N                Analysis of Order Values                          

ME82                 Archived Purchasing Documents                     

ME84                 Generation of Sched. Agmt. Releases               

ME84A                Individual Display of SA Release                  

ME85                 Renumber Schedule Lines                           

ME86                 Aggregate Schedule Lines                          

ME87                 Aggregate PO History                              

ME88                 Set Agr. Cum. Qty./Reconcil. Date

JAVA, Java script, HTML, Swift 등 여려가지 Language를 배울수 있는 site.

http://tryhelloworld.co.kr/

salv가 class alv 보다 화면에 display 되는 속도가 빠르거나 하지는 않다.

하지만 salv 로 개발하면 몇줄 코딩하지 않고 간단하게 alv grid 를 만들수 있다.

물론 detail 한 control(Edit, on_changed event 등)을 하려면 class alv로 개발하는것이 맞다.

SALV도 Edit 작업은 가능하지만 굳이 edit 기능을 사용해야 한다면 class ALV로 작업하는게

맞다고 생각한다.

Long Text ID, Object 찾는 방법 2

1. 해당 Text 를 조회한 뒤에 Detail button을 눌러서 detail 화면으로 들어간다.

2. Detail 화면에서 메뉴에 들어가서 Header click 한다.

3. 그러면 위의 그림과 같이 Text ID, Text object를 확인할 수 있다.

Text ID와 Text Object를 알고 있을때 

어떤 object의 어떤 text 인지 확인 하는 방법

1. T-Code SE75에서 Text Objects and IDs 선택.

2. 원하는 Object를 Double click 해서 detail 화면으로 이동.

3. Text ID 확인.