SAP Reports / Programs

Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

SAPDBKDF SAP ABAP Report - Logical Database SAPDBKDF

SAP T-Codes / Example ABAP code
ABAP OO / SAP Function Modules
ABAP reports / SAP Error Messages
SAP Tables / SAP Video Training

SAPDBKDF is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The report SAPDBKDF controls access to the vendor data base from a Financial Accounting point of view...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter SAPDBKDF into the relevant SAP transactions such as SE38 or SE80

ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.

SUBMIT SAPDBKDF. "Basic submit
SUBMIT SAPDBKDF AND RETURN. "Return to original report after report execution complete
SUBMIT SAPDBKDF VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement

Text pool values

Selection Text: XBR_GSBE = Business area
Selection Text: XBR_BLAR = Document type
Selection Text: KD_ZUONR = Assignment number
Selection Text: KD_UMSKZ = Special G/L indicator
Selection Text: KD_STIDA = Open items at key date
Selection Text: KD_LIFNR = Vendor account
Selection Text: KD_INDEX = Vendor search help
Selection Text: KD_GJAHR = Fiscal Year
Selection Text: KD_BUKRS = Company code
Selection Text: KD_BUDAT = Posting date
Selection Text: KD_AUGDT = Clearing date
Selection Text: EXCDT = Translation date
Selection Text: ALCUR = Alternative local currency
Title: Logical Database SAPDBKDF
Text Symbol: SRC = Data Sources
Text Symbol: 904 = Variant 1: as variant 4, but including fiscal year and special G/L indicator
Text Symbol: 903 = Variant 1: only possible to select account, matchcode, company code
Text Symbol: 902 = Variant 3: only possible to select open items/cleared items
Text Symbol: 901 = Variant 2: only possible to select cleared items
Text Symbol: 900 = Variant 1: only possible to select open items
Text Symbol: 025 = Alternative Currency
Text Symbol: 024 = Line item selection
Text Symbol: 023 = Reporting Time Frame
Text Symbol: 022 = Translation date
Text Symbol: 021 = Alternative local currency
Text Symbol: 015 = . Cannot be accessed.
Text Symbol: 014 = is not in view/table
Text Symbol: 013 = Archived documents were selected
Text Symbol: 012 = Special G/L transactions
Text Symbol: 011 = were not changed
Text Symbol: 010 = were not transferred
Text Symbol: 009 = were transferred
Text Symbol: 008 = Acct type
Text Symbol: 007 = Document header for company code
Text Symbol: 006 = no items were found
Text Symbol: 005 = in company code
Text Symbol: 004 = For document
Text Symbol: 003 = not found

Text Symbol: 002 = Doc. Number
Text Symbol: 001 = Matchcode
Text Symbol: 000 = Vendor selection

INCLUDES used within this REPORT SAPDBKDF

INCLUDE RFDBEXPC.
INCLUDE RFDBINCLUD1. "40C
INCLUDE RFDBINCLUD2. "40C

TABLES used within REPORT and the associated SELECT statement:

No SAP DATABASE tables are accessed within this REPORT code!

Function Modules used within report and the associated call statement:

FREE_SELECTIONS_LDB_JOINS_INIT CALL FUNCTION 'FREE_SELECTIONS_LDB_JOINS_INIT' TABLES TABLES_TAB = FIELDS.

CURRENCY_CHECK_FOR_PROCESS CALL FUNCTION 'CURRENCY_CHECK_FOR_PROCESS' EXPORTING PROCESS = 'SAPDBKDF' EXCEPTIONS PROCESS_NOT_MAINTAINED = 1 others = 2.

FI_CHECK_DATE CALL FUNCTION 'FI_CHECK_DATE' EXPORTING I_BUKRS = SPACE I_USER = SY-UNAME I_PROGRAM = 'SAPDBKDF' IMPORTING E_RETURN = LD_RETURN EXCEPTIONS NO_AUTHORITY_PROG = 1 NO_AUTHORITY_DATE = 2 WRONG_PARAMETER = 3 others = 4.

FUNCTION_EXISTS CALL FUNCTION 'FUNCTION_EXISTS' EXPORTING FUNCNAME = 'CA_WRITE_LOG' EXCEPTIONS FUNCTION_NOT_EXIST = 1 others = 2.

BUKRS_AUTHORITY_CHECK CALL FUNCTION 'BUKRS_AUTHORITY_CHECK' EXPORTING XDATABASE = 'K' TABLES XBUKREIS = KD_BUKRS.

BUKRS_AUTHORITY_CHECK CALL FUNCTION 'BUKRS_AUTHORITY_CHECK' EXPORTING XDATABASE = 'B' TABLES XBUKREIS = KD_BUKRS.

AS_DATASOURCE_SELECT
    CALL FUNCTION 'AS_DATASOURCE_SELECT'
      EXPORTING
        I_DB_AND_ARC       = 'X'
        I_NO_SOURCE_SELECT = SPACE
        I_INFOSYS_POSSIBLE = 'X'
        I_DOCUMENTATION    = 'DEFAULT'
        I_REPORT           = LD_PROGNAME
        I_REPORTTYPE       = SPACE
        IT_OBJECTS         = LT_OBJECTS[]
      CHANGING
        C_USE_DATABASE     = KD_USEDB
        C_USE_ARCHIVE      = KD_USEAR
        C_USE_INFOSYS      = KD_USEAS
        C_ARCHOBJ          = KD_OBJEC
        CT_ARCH_SEL        = KD_FILES[].

BUKRS_AUTHORITY_CHECK CALL FUNCTION 'BUKRS_AUTHORITY_CHECK' EXPORTING XDATABASE = 'K' TABLES XBUKREIS = KD_BUKRS.

BUKRS_AUTHORITY_CHECK CALL FUNCTION 'BUKRS_AUTHORITY_CHECK' EXPORTING XDATABASE = 'B' TABLES XBUKREIS = KD_BUKRS.

CA_WRITE_LOG
        call function 'CA_WRITE_LOG'                        "#EC EXISTS
             exporting
                  I_PROGRAM   = SY-CPROG
             exceptions
                  WRITE_ERROR = 1
                  others      = 2.

LDB_LOG_INIT CALL FUNCTION 'LDB_LOG_INIT'.

LDB_LOG_DISPLAY CALL FUNCTION 'LDB_LOG_DISPLAY'.

LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'.

READ_T001 CALL FUNCTION 'READ_T001' EXPORTING XBUKRS = LFB1-BUKRS IMPORTING STRUCT = T001.

READ_T001

CALL FUNCTION 'READ_T001' EXPORTING XBUKRS = SAVE_BUKRS IMPORTING STRUCT = T001.

READ_T001 CALL FUNCTION 'READ_T001' EXPORTING XBUKRS = SAVE_BUKRS IMPORTING STRUCT = T001.

LDB_LOG_WRITE
*        call function 'LDB_LOG_WRITE'.

LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'. "1344830

LDB_LOG_WRITE
*        call function 'LDB_LOG_WRITE'.

LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'. "1344830

LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'.

ADDR_GET_ARRAY CALL FUNCTION 'ADDR_GET_ARRAY' EXPORTING PUT_INTO_MEMORY = SPACE TABLES ADDRESS_SELECTION = LT_SELECTION ADDRESS_VALUE = XADDR1_VAL ADDRESS_TEXT = XADDR1_TEXT EXCEPTIONS PARAMETER_ERROR = 1 INTERNAL_ERROR = 2 others = 3.

ADDR_GET CALL FUNCTION 'ADDR_GET' EXPORTING ADDRESS_SELECTION = LS_SELECTION READ_TEXTS = 'X' IMPORTING ADDRESS_VALUE = ADDR1_VAL ADDRESS_TEXT = ADDR1_TEXT EXCEPTIONS PARAMETER_ERROR = 1 ADDRESS_NOT_EXIST = 2 VERSION_NOT_EXIST = 3 INTERNAL_ERROR = 4 others = 5.

INIT_T001 CALL FUNCTION 'INIT_T001' TABLES XBUKREIS = KD_BUKRS.

RS_REFRESH_FROM_DYNAMICAL_SEL CALL FUNCTION 'RS_REFRESH_FROM_DYNAMICAL_SEL' EXPORTING CURR_REPORT = SY-CPROG MODE_WRITE_OR_MOVE = 'M' IMPORTING P_TRANGE = GT_DYN_TRANGE EXCEPTIONS NOT_FOUND = 1 WRONG_TYPE = 2 others = 3.

FI_CHECK_DATE CALL FUNCTION 'FI_CHECK_DATE' EXPORTING I_BUKRS = LFC1-BUKRS I_USER = SY-UNAME I_PROGRAM = 'SAPDBKDF' I_FROM_YEAR = LFC1-GJAHR EXCEPTIONS NO_AUTHORITY_PROG = 1 NO_AUTHORITY_DATE = 2 WRONG_PARAMETER = 3 others = 4.

FI_CHECK_DATE CALL FUNCTION 'FI_CHECK_DATE' EXPORTING I_BUKRS = LFC3-BUKRS I_USER = SY-UNAME I_PROGRAM = 'SAPDBKDF' I_FROM_YEAR = LFC3-GJAHR EXCEPTIONS NO_AUTHORITY_PROG = 1 NO_AUTHORITY_DATE = 2 WRONG_PARAMETER = 3 others = 4.

FI_CHECK_DATE CALL FUNCTION 'FI_CHECK_DATE' EXPORTING I_BUKRS = BSIK-BUKRS I_USER = SY-UNAME I_PROGRAM = 'SAPDBKDF' I_FROM_DATE = LD_DATE EXCEPTIONS NO_AUTHORITY_PROG = 1 NO_AUTHORITY_DATE = 2 WRONG_PARAMETER = 3 others = 4.

FI_CHECK_DATE CALL FUNCTION 'FI_CHECK_DATE' EXPORTING I_BUKRS = IT001-BUKRS I_USER = SY-UNAME I_PROGRAM = 'SAPDBKDF' I_FROM_DATE = KD_STIDA EXCEPTIONS NO_AUTHORITY_PROG = 1 NO_AUTHORITY_DATE = 2 WRONG_PARAMETER = 3 others = 4.

FI_CHECK_DATE CALL FUNCTION 'FI_CHECK_DATE' EXPORTING I_BUKRS = IT001-BUKRS I_USER = SY-UNAME I_PROGRAM = 'SAPDBKDF' I_FROM_YEAR = KD_GJAHR-LOW I_TO_YEAR = KD_GJAHR-HIGH EXCEPTIONS NO_AUTHORITY_PROG = 1 NO_AUTHORITY_DATE = 2 WRONG_PARAMETER = 3 others = 4.

AS_DATASOURCE_INIT
  CALL FUNCTION 'AS_DATASOURCE_INIT'
    EXPORTING
      I_REPORT       = L_PROGNAME
      I_REPORTTYPE   = SPACE
    IMPORTING
      E_USE_DATABASE = R_USEDB
      E_USE_ARCHIVE  = R_USEAR
      E_USE_INFOSYS  = R_USEAS
      ET_ARCH_SEL    = RT_FILES[].

FI_DOCUMENT_ARCH_AS_ITEMS_READ
  CALL FUNCTION 'FI_DOCUMENT_ARCH_AS_ITEMS_READ'
    EXPORTING
      I_SELECTIONS       = GT_SELECTIONS
      I_CONVERT_CURRENCY = LD_CONVERT_CURRENCY
      I_SHOW_ERRORS      = LD_ERRORS
      I_SHOW_PROGESS     = LD_PROGRESS
    TABLES
      E_BKPF             = YBKPF
      E_BSEG             = YBSEG
      E_BSAK             = YBSAK
      I_ARCH_SEL         = KD_FILES[]
    EXCEPTIONS
      NO_INFOSTRUC_FOUND = 1
      SELECTIONS_ERROR   = 2.

FREE_SELECTIONS_WHERE_2_RANGE CALL FUNCTION 'FREE_SELECTIONS_WHERE_2_RANGE' EXPORTING WHERE_CLAUSES = LT_WHERE IMPORTING FIELD_RANGES = LT_TRANGE EXCEPTIONS EXPRESSION_NOT_SUPPORTED = 1 INCORRECT_EXPRESSION = 2 others = 3.

DDIF_NAMETAB_GET CALL FUNCTION 'DDIF_NAMETAB_GET' EXPORTING TABNAME = LD_TABLENAME LFIELDNAME = LD_FIELDNAME IMPORTING DFIES_WA = LS_DFIES EXCEPTIONS NOT_FOUND = 1 others = 2.

Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.

The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name SAPDBKDF or its description.

SAPDBKDF - Logical Database SAPDBKDF
SAPDBK1V - documentation and ABAP source code
SAPDBJ5F - documentation and ABAP source code
SAPDBIRM - documentation and ABAP source code
SAPDBIPM_ACE_LDBPS - Log. Database ACEPS_003 : Database Program
SAPDBIPM_ACE_LDBDS - Logical Database ACEDS_003: Database Program

RWRF_DISPRO_DATA_SEND

RWES_DEFINE_FILTER_F03