Friday, April 3, 2015

Complete PA transfer structure FI

Copy the GL for which the error is coming and go to the T-Code KEI1

Select the PA transfer structure "FI".
Click on the "assignment lines" in the left panel and select the appropriate group on the right side and select source on the left and add the cost element in the error.
Further, you can assign the value field to this.

Monday, March 23, 2015

Reseting the SAP Runtime Value - ABAP Report Timeout

Prevent ABAP report timeout by Reseting the SAP runtime value using TH_REDISPATCH


Kindly follow the link below -

http://www.sapdev.co.uk/reporting/prevent-sap-timeout.htm

Tuesday, February 24, 2015

Reprint Check in SAP using FBZ5

Use T-Code FBZ5.
Give Below Parameters -



Document Number
Company Code
Fiscal Year
Payment method
Check lot number
Alternative form
 

Friday, February 13, 2015

BDC for Credit Note to Customers - FB75

Make the file in txt format having the fields that are defined in the Structure below -

REPORT ZFB75 NO STANDARD PAGE HEADING LINE-SIZE 255.

*TYPES DECLARATION............................................*
DATA: W_FILENAME TYPE STRING.
SELECTION-SCREEN SKIP 1.
SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-500.
PARAMETERS: P_FILENM LIKE RLGRAP-FILENAME.
SELECTION-SCREEN END OF BLOCK B1.

TABLES: INVFO.

TYPES : BEGIN OF ST,

        ACCNT(17),
        BLDAT(10),
        BUDAT(10),
        CWRBTR(13),
        WAERS(5),
        BUPLA(4),
        SECCO(4),
        SGTXT(50),
        HKONT(10),
        DWRBTR(13),
        "MWSKZ(2),   Not Required
        "GSBER(4),   Not Required it will picked up from Cost Center
        KOSTL(10),
        "PRCTR(10),  Not Required it will picked up from Cost Center
        ZFBDT(10),

        END OF ST.

*INTERNAL TABLE AND WORKAREA DECLARATION*
DATA : IT TYPE TABLE OF ST.
DATA : WA TYPE ST.

INCLUDE BDCRECX1.

START-OF-SELECTION.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILENM.

  CALL FUNCTION 'WS_FILENAME_GET'
       EXPORTING
            MASK             = ',*.*,*.*.'
            MODE             = '0'
            TITLE            = 'GET FILE NAME'
       IMPORTING
            FILENAME         = P_FILENM
       EXCEPTIONS
            INV_WINSYS       = 1
            NO_BATCH         = 2
            SELECTION_CANCEL = 3
            SELECTION_ERROR  = 4
            OTHERS           = 5.

** START OF CHANGE DCS05052003
START-OF-SELECTION.
 W_FILENAME = P_FILENM.
CALL FUNCTION 'GUI_UPLOAD'
  EXPORTING
**   FILENAME                    = 'C:\BDC_XLS_ASSIGN.TXT'
   FILENAME                      = W_FILENAME
   FILETYPE                      = 'ASC'
   HAS_FIELD_SEPARATOR           = 'X'
  TABLES
    DATA_TAB                     = IT
 EXCEPTIONS
   FILE_OPEN_ERROR               = 1
   FILE_READ_ERROR               = 2
   NO_BATCH                      = 3
   GUI_REFUSE_FILETRANSFER       = 4
   INVALID_TYPE                  = 5
   NO_AUTHORITY                  = 6
   UNKNOWN_ERROR                 = 7
   BAD_DATA_FORMAT               = 8
   HEADER_NOT_ALLOWED            = 9
   SEPARATOR_NOT_ALLOWED         = 10
   HEADER_TOO_LONG               = 11
   UNKNOWN_DP_ERROR              = 12
   ACCESS_DENIED                 = 13
   DP_OUT_OF_MEMORY              = 14
   DISK_FULL                     = 15
   DP_TIMEOUT                    = 16
   OTHERS                        = 17.

          .
IF SY-SUBRC <> 0.
 MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO.
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

PERFORM OPEN_GROUP.

LOOP AT IT INTO WA.

"---------------------------------------------------------------
PERFORM BDC_DYNPRO      USING 'SAPMF05A' '1200'.
PERFORM BDC_FIELD       USING 'BDC_OKCODE'
                              '/00'.
PERFORM BDC_FIELD       USING 'RF05A-BUSCS'
                              'G'.
PERFORM BDC_FIELD       USING 'INVFO-ACCNT'
                               WA-ACCNT."'63G63187'.
PERFORM BDC_FIELD       USING 'INVFO-BLDAT'
                               WA-BLDAT. "'31.01.2014'.
PERFORM BDC_FIELD       USING 'INVFO-BUDAT'
                               WA-BUDAT."'31.01.2014'.
PERFORM BDC_FIELD       USING 'INVFO-WRBTR'
                               WA-CWRBTR."'70000'.
PERFORM BDC_FIELD       USING 'INVFO-WAERS'
                               WA-WAERS."''.
PERFORM BDC_FIELD       USING 'INVFO-BUPLA'
                               WA-BUPLA."''.
PERFORM BDC_FIELD       USING 'INVFO-SECCO'
                               WA-SECCO."''.
PERFORM BDC_FIELD       USING 'INVFO-SGTXT'
                               WA-SGTXT."'TESTING FOR '.
PERFORM BDC_FIELD       USING 'ACGL_ITEM-HKONT(01)'
                               WA-HKONT."'505100'.
PERFORM BDC_FIELD       USING 'ACGL_ITEM-WRBTR(01)'
                               WA-DWRBTR."'            70000'.
PERFORM BDC_FIELD       USING 'ACGL_ITEM-MWSKZ(01)'
                               ''."WA-MWSKZ."'V0'.
PERFORM BDC_FIELD       USING 'ACGL_ITEM-GSBER(01)'
                               ''."WA-GSBER."''.
PERFORM BDC_FIELD       USING 'ACGL_ITEM-KOSTL(01)'
                               WA-KOSTL."'46301'.
PERFORM BDC_FIELD       USING 'ACGL_ITEM-PRCTR(01)'
                               ''."WA-PRCTR."'400'.
PERFORM BDC_DYNPRO      USING 'SAPMF05A' '1200'.
PERFORM BDC_FIELD       USING 'BDC_OKCODE'
                              '/00'.
PERFORM BDC_FIELD       USING 'BDC_CURSOR'
                              'INVFO-ZFBDT'.
PERFORM BDC_FIELD       USING 'INVFO-ZFBDT'
                               WA-ZFBDT."'31.01.2014'.
PERFORM BDC_DYNPRO      USING 'SAPMF05A' '1200'.
PERFORM BDC_FIELD       USING 'BDC_OKCODE'
                              '=BS'.
PERFORM BDC_FIELD       USING 'BDC_CURSOR'
                              'INVFO-ZFBDT'.
PERFORM BDC_FIELD       USING 'INVFO-ZFBDT'
                               WA-ZFBDT."'31.01.2014'.
PERFORM BDC_DYNPRO      USING 'SAPMSSY0' '0120'.
PERFORM BDC_FIELD       USING 'BDC_OKCODE'
                              '=PS 18'.
PERFORM BDC_DYNPRO      USING 'SAPMSSY0' '0120'.
PERFORM BDC_FIELD       USING 'BDC_OKCODE'
                              '=PS 37'.
PERFORM BDC_DYNPRO      USING 'SAPMSSY0' '0120'.
PERFORM BDC_FIELD       USING 'BDC_OKCODE'
                              '=BU'.
PERFORM BDC_TRANSACTION USING 'FB75'.

ENDLOOP.

PERFORM CLOSE_GROUP.

Wednesday, February 4, 2015

BDC for Transaction F-04

Make the file in txt format having the fields that are defined in the Structure below -
 
REPORT ZF04 NO STANDARD PAGE HEADING LINE-SIZE 255.

*TYPES DECLARATION............................................*
DATA: W_FILENAME TYPE STRING.
SELECTION-SCREEN SKIP 1.
SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-500.
PARAMETERS: P_FILENM LIKE RLGRAP-FILENAME.
SELECTION-SCREEN END OF BLOCK B1.

 TYPES : BEGIN OF ST,

   BLDAT(10),
   BLART(2),
   BURKS(4),
   BUDAT(10),
   MONAT(2),
   WAERS(5),
   NEWBS(2),
   NEWKO(17),
   WRBTR(13),
   GSBER(4),
   PRCTR(10),
   VALUT(10),
   ZUONR(18),
   SGTXT(50),

   NEWBS2(2),
   NEWKO2(17),
   WRBTR2(13),
   GSBER2(4),
   PRCTR2(10),
   ZUONR2(18),
   SGTXT2(50),

END OF ST.

*INTERNAL TABLE AND WORKAREA DECLARATION*

 DATA : IT TYPE TABLE OF ST.
 DATA : WA TYPE ST.

INCLUDE BDCRECX1.

START-OF-SELECTION.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILENM.

  CALL FUNCTION 'WS_FILENAME_GET'
       EXPORTING
            MASK             = ',*.*,*.*.'
            MODE             = '0'
            TITLE            = 'GET FILE NAME'
       IMPORTING
            FILENAME         = P_FILENM
       EXCEPTIONS
            INV_WINSYS       = 1
            NO_BATCH         = 2
            SELECTION_CANCEL = 3
            SELECTION_ERROR  = 4
            OTHERS           = 5.

** START OF CHANGE DCS05052003
START-OF-SELECTION.
 W_FILENAME = P_FILENM.
CALL FUNCTION 'GUI_UPLOAD'
  EXPORTING
**   FILENAME                    = 'C:\BDC_XLS_ASSIGN.TXT'
   FILENAME                      = W_FILENAME
   FILETYPE                      = 'ASC'
   HAS_FIELD_SEPARATOR           = 'X'
  TABLES
    DATA_TAB                     = IT
 EXCEPTIONS
   FILE_OPEN_ERROR               = 1
   FILE_READ_ERROR               = 2
   NO_BATCH                      = 3
   GUI_REFUSE_FILETRANSFER       = 4
   INVALID_TYPE                  = 5
   NO_AUTHORITY                  = 6
   UNKNOWN_ERROR                 = 7
   BAD_DATA_FORMAT               = 8
   HEADER_NOT_ALLOWED            = 9
   SEPARATOR_NOT_ALLOWED         = 10
   HEADER_TOO_LONG               = 11
   UNKNOWN_DP_ERROR              = 12
   ACCESS_DENIED                 = 13
   DP_OUT_OF_MEMORY              = 14
   DISK_FULL                     = 15
   DP_TIMEOUT                    = 16
   OTHERS                        = 17.

          .
IF SY-SUBRC <> 0.
 MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO.
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

PERFORM OPEN_GROUP.

LOOP AT IT INTO WA.

PERFORM BDC_DYNPRO      USING 'SAPMF05A' '0122'.
PERFORM BDC_FIELD       USING 'BDC_CURSOR'
                              'RF05A-NEWKO'.
PERFORM BDC_FIELD       USING 'BDC_OKCODE'
                              '/00'.
PERFORM BDC_FIELD       USING 'BKPF-BLDAT'
                               WA-BLDAT. "'24.06.2013'.
PERFORM BDC_FIELD       USING 'BKPF-BLART'
                               WA-BLART. "'KA'.
PERFORM BDC_FIELD       USING 'BKPF-BUKRS'
                               WA-BURKS.
PERFORM BDC_FIELD       USING 'BKPF-BUDAT'
                               WA-BUDAT. "'24.06.2013'.
PERFORM BDC_FIELD       USING 'BKPF-MONAT'
                               WA-MONAT. "'3'.
PERFORM BDC_FIELD       USING 'BKPF-WAERS'
                               WA-WAERS. "'INR'.
PERFORM BDC_FIELD       USING 'FS006-DOCID'
                               '*'.
PERFORM BDC_FIELD       USING 'RF05A-NEWBS'
                               WA-NEWBS. "'39'.
PERFORM BDC_FIELD       USING 'RF05A-NEWKO'
                               WA-NEWKO. "''.
PERFORM BDC_DYNPRO      USING 'SAPMF05A' '0300'.
PERFORM BDC_FIELD       USING 'BDC_CURSOR'
                              'RF05A-NEWKO'.
PERFORM BDC_FIELD       USING 'BDC_OKCODE'
                              '/00'.
PERFORM BDC_FIELD       USING 'BSEG-WRBTR'
                               WA-WRBTR."'100'.
PERFORM BDC_FIELD       USING 'BSEG-VALUT'
                               WA-VALUT."'24.06.2013'.
PERFORM BDC_FIELD       USING 'BSEG-ZUONR'
                               WA-ZUONR."'TESTING FOR PF'.
PERFORM BDC_FIELD       USING 'BSEG-SGTXT'
                               WA-SGTXT."'TESTING FOR PF'.
PERFORM BDC_FIELD       USING 'RF05A-NEWBS'
                               WA-NEWBS2. "'40'.
PERFORM BDC_FIELD       USING 'RF05A-NEWKO'
                               WA-NEWKO2. "'860101'.
PERFORM BDC_DYNPRO      USING 'SAPLKACB' '0002'.
PERFORM BDC_FIELD       USING 'BDC_CURSOR'
                              'COBL-PRCTR'.
PERFORM BDC_FIELD       USING 'BDC_OKCODE'
                              '=ENTE'.
PERFORM BDC_FIELD       USING 'COBL-GSBER'
                              WA-GSBER."'4'.
PERFORM BDC_FIELD       USING 'COBL-PRCTR'
                              WA-PRCTR."'400'.
PERFORM BDC_DYNPRO      USING 'SAPMF05A' '0300'.
PERFORM BDC_FIELD       USING 'BDC_CURSOR'
                              'BSEG-SGTXT'.
PERFORM BDC_FIELD       USING 'BDC_OKCODE'
                              '=AB'.
PERFORM BDC_FIELD       USING 'BSEG-WRBTR'
                               WA-WRBTR2."'100'.
PERFORM BDC_FIELD       USING 'BSEG-VALUT'
                               WA-VALUT."'03.02.2015'.
PERFORM BDC_FIELD       USING 'BSEG-ZUONR'
                               WA-ZUONR2."'TESTING FOR PF'.
PERFORM BDC_FIELD       USING 'BSEG-SGTXT'
                               WA-SGTXT2."'TESTING FOR PF'.
PERFORM BDC_DYNPRO      USING 'SAPLKACB' '0002'.
PERFORM BDC_FIELD       USING 'BDC_CURSOR'
                              'COBL-PRCTR'.
PERFORM BDC_FIELD       USING 'BDC_OKCODE'
                              '=ENTE'.
PERFORM BDC_FIELD       USING 'COBL-GSBER'
                               WA-GSBER2."'1'.
PERFORM BDC_FIELD       USING 'COBL-PRCTR'
                               WA-PRCTR."'100'.
PERFORM BDC_DYNPRO      USING 'SAPMF05A' '0700'.
PERFORM BDC_FIELD       USING 'BDC_CURSOR'
                              'RF05A-NEWBS'.
PERFORM BDC_FIELD       USING 'BDC_OKCODE'
                              '=BU'.
PERFORM BDC_TRANSACTION USING 'F-04'.

REFRESH BDCDATA.
ENDLOOP.

PERFORM CLOSE_GROUP.

Friday, January 30, 2015

Delete Parked Document By FBV6 - Runtime Error

When we are running the T-Code FBV6 and trying to delete, system gives run time error.

In order to solve the issue please apply notes and retest the same scenario.

1810842 - Delete or change parked documents from MM
1833381 - ASSERT violation FM_DOCUMENT_REVERSE_PP

Wednesday, January 7, 2015

Business Area, Profit Center and Cost Center Field Mandatory in Internal Order

Make Business Area, Profit Center and Cost Center Mandatory in Internal Order

Go to T-Code - KOT2_OPA
Select the Order Type for which you want the fields to be mandatory.
Or
Create New Order Type.

After the selecting the Order Type go to display.
Scroll down and click on Field Selection.
Now make the field as required and save.