Programme SAP SAPDBMDF - FM Master Data Mass Selection

Description
Logical database SAPDBMDF

Use

Note
The SAPDBMDF program controls access to master data in FundsManagement. Since the program only contains physical access routinesfor the logical database, you cannot start it separately.

Technical documentation
The standard delivered for logical database SAPDBMDF contains thefollowing:

  • Basic selection screen (selection screen number 1000)

  • Contains all available database selections. If changes are made todatabase selections (such as including a new selection criterion), thisscreen is regenerated automatically by the system. It is thenimmediately available to all programs which use logical database MDF.
    • Selection screen variants

    • Selection screen variant are available in reporting by entering theselection screen number in attributes.
      FIP
      For selection of commitment items
      FIC
      For selection of funds centers

      Available fields
      The fields available on a selection screen are marked with an "X".
      Selection screen variant
      Field name 1000 FIP FIC
      FM area x x x
      Fiscal year x x x
      Fund x
      Funds center x x
      Key date x x
      Plan variant x x
      Commitment item x x
      Attribute: Postable x x
      Commitment item category x x
      Financial transaction x x
      Role in Col.Bdgt Admin. x x
      Attribute: Statistical x x

      Note on performance
      To improve performance you can control which tables or which fields ofa table are to be viewed.

      • Selective viewing of complete database tables

      • You can use the table FMSG described below which controls whetherinformation for an individual segment is needed.
        • Selective viewing of individual fields of a database table.

        • The GET result offers the possibility of naming the fields needed forthe program. As a result, the database burden is eased because onlythose fields are transported to the application server that are needed(not supported for BSPE segment).
          Individual tables can be exempted from the selection in order toincrease performance. You can set the following fields in theapplication program during INITIALIZATION or START-OF-SELECTION:
          • FMSG-XPPLN (default BLANK) : If this field is set to "X", then the
          • chart of commitment items data is read for the FKRS segment.
            • FMSG-XFFND (default BLANK) : If this field is set to "X", then no data
            • for a specific fund is read.
              • FMSG-XFCTR (default BLANK) : If this field is set to "X", then no funds
              • center data is read.
                • FMSG-XZBSP (default BLANK) : If this field is set to "X", then the
                • budget structure element assignment data is read.
                  • FMSG-XTXTM (default BLANK) : If this field is set to "X", then no
                  • master data texts are read.

                    Authorization check
                    FM area (display authorization)

                    • Fund authorization group (display authorization)

                    • Funds center authorization group (display authorization)

                    • Commitment item authorization group (display authorization)

                    • FM account assignment authorization group (display authorization
                    • Notes on programming
                      The MDF logical database allows the programer to adapt the selectionprogram to their needs.

                      • In Release 3.0, it is possible to read individual fields from database
                      • tables using OPEN SQL statements. The MDF logical database supportsthis option. During the reduction of the number of fields to be read bythe database, performance can improve considerably. You can specify thefields to be selected either in the GET or write them in theSELECT_FIELDS table during INITIALIZATION. The table is available toall selection programs which use the MDF logical database. TheSELECT_FIELDS internal table may ONLY be changed during INITIALIZATION.