BDC for FI Transaction - F-51, F-02

BDC is required when you want to post the several document.

Follow the link -

http://scn.sap.com/docs/DOC-43723

Function Module to Get the Vendor Deposit Documents

 1 - Create the Structure as ZSP_VEND_DEPOSIT with the following fields -

LIFNR
BELNR
BUDAT
WRBTR
DMBTR
ZUONR
SGTXT

2 - Import Parameters Enter the following fields-

     I_LIFNR    TYPE    LIFNR

3 - Copy the code in Source Code -

FUNCTION ZSP_VEND_DEPOSIT.
*"----------------------------------------------------------------------
*"*"Local Interface:
*"  IMPORTING
*"     VALUE(I_LIFNR) TYPE  LIFNR
*"  TABLES
*"      ITAB STRUCTURE  ZSP_VEND_DEPOSIT
*"----------------------------------------------------------------------


DATA: IT_BSIK TYPE STANDARD TABLE OF ZSP_VEND_DEPOSIT WITH HEADER LINE.
DATA: WA_BSIK like LINE OF IT_BSIK.

DATA: IT_BSAK TYPE STANDARD TABLE OF ZSP_VEND_DEPOSIT WITH HEADER LINE.
DATA: WA_BSAK like LINE OF IT_BSAK.


SELECT * INTO CORRESPONDING FIELDS OF TABLE IT_BSIK
FROM BSIK WHERE
  BUKRS = 'Your Company Code' AND
  LIFNR = I_LIFNR AND
  UMSKZ IN (Your Special GL Indicator).

SELECT * INTO CORRESPONDING FIELDS OF TABLE IT_BSAK
FROM BSAK WHERE
   BUKRS = 'Your Company Code' AND
   LIFNR = I_LIFNR AND
   UMSKZ IN (Your Special GL Indicator).

LOOP AT IT_BSIK.
APPEND WA_BSIK TO ITAB.
ENDLOOP.

LOOP AT IT_BSAK.
APPEND IT_BSAK TO ITAB.
ENDLOOP.

ENDFUNCTION.

Vendor Payment Document Posting Date Wise

1- Create Structure ZSP_VEND_PAYMENT by T-Code SE11.

Enter the field –

LIFNR

BELNR

BUDAT

GJAHR

WRBTR

ZUONR

SGTXT

EBELN



2- In Import Parameters

I_LIFNR          TYPE   LIFNR

I_FROM_BUDAT       TYPE   BUDAT

I_TO_BUDAT TYPE   BUDAT



3- Enter in the Source Code –

FUNCTION ZSP_VEND_PAYMENT.
*"----------------------------------------------------------------------
*"*"Local Interface:
*"  IMPORTING
*"     VALUE(I_LIFNR) TYPE  LIFNR
*"     VALUE(I_FROM_BUDAT) TYPE  BUDAT
*"     VALUE(I_TO_BUDAT) TYPE  BUDAT
*"  TABLES
*"      ITAB STRUCTURE  ZSP_VEND_PAYMENT
*"----------------------------------------------------------------------

DATA: IT_BSAK TYPE STANDARD TABLE OF ZSP_VEND_PAYMENT WITH HEADER LINE.
DATA: WA_BSAK like LINE OF IT_BSAK.

DATA: IT_BSAS TYPE STANDARD TABLE OF ZSP_VEND_PAYMENT WITH HEADER LINE.
DATA: WA_BSAS like LINE OF IT_BSAS.

SELECT * INTO CORRESPONDING FIELDS OF TABLE IT_BSAK
FROM BSAK WHERE
   BUKRS = ' Your Company Code ' AND
   LIFNR = I_LIFNR AND
   BLART IN (Your Document Type) AND
   ( BUDAT BETWEEN I_FROM_BUDAT AND I_TO_BUDAT ).

LOOP AT IT_BSAK INTO WA_BSAK.
  SELECT * INTO CORRESPONDING FIELDS OF WA_BSAS
    FROM BSAS WHERE
    BUKRS = 'Your Company Code' AND
    BELNR = WA_BSAK-BELNR AND
    ( BUDAT BETWEEN I_FROM_BUDAT AND I_TO_BUDAT ).
  ENDSELECT.
  APPEND WA_BSAS TO IT_BSAS.
ENDLOOP.

LOOP AT IT_BSAS INTO WA_BSAS.
  WA_BSAS-LIFNR = I_LIFNR.
  APPEND WA_BSAS TO ITAB.
ENDLOOP.

DELETE ADJACENT DUPLICATES FROM ITAB.

ENDFUNCTION.

Creating Display Only Role in SAP by SAP_ALL Role

Main idea is to download/export the SAP_ALL Role on to your local system and then change the ACTVT * to ACTVT 03 by opening the role in a Notepad.

But this activity doesn't work completely. Some transaction will work but some will not as they require the some other value apart from 03.

I tried these step but result was not upto the mark. So i searched more and found this link -

http://scn.sap.com/community/security/blog/2014/02/27/creating-an-sapall-display-only-role


Download the Role from the above link and upload it on to your SAP system.
I did it on QA server and it worked fine.

Upload and Download File in SAP

Upload file from Local Disk to a directory in SAP by Transaction - CG3Z

and

Download File from SAP to Local Disk by Transaction - CG3Y