6 Replies Latest reply: Mar 11, 2008 8:43 PM by CARLOS YEPEZ RSS

logical database in sd

sasikumar selvarajan
Currently Being Moderated

hi experts,

 

   i need standard LDB's  related to the tables of sd, mm and fi... can anyone help regarding this.....

  • Re: logical database in sd
    Navaneetha Krishnan
    Currently Being Moderated

    You can find all the tables related to SAP transaction in the link below.

     

    http://www.erpgenie.com/abap/tables.htm

    • Re: logical database in sd
      sasikumar selvarajan
      Currently Being Moderated

      i need only the LDB names used in the sd flow......

      • Re: logical database in sd
        Ranjeet Rajendra Jain
        Currently Being Moderated

        Ok so here you are, If you want to edit one go to SE36

         

        -


        LDB name

        Logical database short text

        -


        50V

        Delivery in process

        AAV

        Logical Database RV: Sales Documents

        ABCLAIMLDB

        Agency Business: Complaints Processing

        ABS

        ABAP Book: Customer and bookings

        ACAC_ACE_LDBDS

        Accrual Object Distribution Server Reporting Table

        ACAC_ACE_LDBPS

        Accrual Engine Posting Server Reporting Database

        ACE_FILA_LDBDS

        Accrual Object Distribution Server Reporting Table

        ACE_FILA_LDBPS

        Accrual Engine Posting Server Reporting Database

        ACE_SOP_LDBDS

        Stock Option Accounting Distribution Server LDB

        ACE_SOP_LDBPS

        Provisions for Awards: Posting Server LDB

        ACEDS_003

        Accrual Object Distribution Server Reporting Table

        ACEPS_003

        Accrual Engine Posting Server Reporting Database

        ADA

        Assets Database

        AFI

        Logical database for orders

        AGENCYLDB

        Agency Business: Logical Database

        AKV

        Logical Database RV: Sales Documents

        ALV

        Archiving Deliveries

        ARV

        Logical Database RV: Sales Documents

        ASV

        Request Screen for Summary Information

        AUK

        Settlement documents

        AUW

        Allocation Table

        B1L

        Transfer requirements by number

        BAF

        BAV-Data collector

        BAM

        Purchase Requisitions (General)

        BANK

        Logical Database for Table BNKA

        BBM

        Archiving of Purchase Requisitions

        BC405_DIFF_NODES

        Example of Different Node Types

        BJF

        Loans flow records with date restriction(YR

        BKK

        Base Planning Object

        BKM

        Purchase Requisitions per Account Assignment

        BMM

        Documents for Number

        BPF

        Treasury Business Partner

        BRF

        Document Database

        BRM

        Accounting Documents

        BTF

        Loan portfolios and flows

        BTM

        Process Order; Print

        BUCHUNGSJOURNAL

        LDB for Posting Journal

        BUD

        LDB For Loans Master Data, Conditions, Documents

        C1F

        Cash Budget Management

        CCLDB_AENR

        ECH: Change number with status information

        CDC

        Document structure

        CEC

        Equipment BOM

        CEK

        Cost Centers - Line Items

        CFK

        Data pool for SAP EIS

        CIK

        Cost Centers - Actual Data

        CKA

        Costing

        CKC

        Sales order BOM

        CKM

        Material master

        CKQ

        Material Selection for New Costing Solution

        CKS

        MiniApp. for the Calculator: Sales Order Data

        CKS_WAO

        MiniApp: Sales Order Items to be Processed

        CKW

        Costing run: Material Selection

        CMC

        Material BOM

        CPK

        Cost Centers - Plan Data

        CRC

        Work Centers

        CRK

        Cost Centers - Total

        CRZ

        Logical database for courses BC220/BC230

        CSC

        Standard BOM

        CSR

        Logical database for archiving BOMs

        CTC

        Functional location BOM

        DBM

        MRP Documents

        DDF

        CUSTOMER  DATABASE

        DPM

        Planned Orders

        DSF

        Loan Debit Position

        DVS

        Logical database for archiving DMS data

        DWF

        Loan resubmission

        EBM

        Purchasing Activities per Requirement Tracking No.

        ECM

        Purchasing Documents per Material Class

        EHS_OH001

        Logical Database for Occupational Health

        EKM

        Purchasing Documents per Account Assignment

        ELM

        Purchasing Documents per Vendor

        EMM

        Purchasing Documents for Material

        ENM

        Purchasing Documents per Document Number

        EQI

        Logical Database (Equipment)

        ERM

        Archiving of Purchasing Documents

        ESM

        Purchasing Documents per Collective Number

        EWM

        Purchasing Documents per Supplying Plant

        F1S

        BC: Planned flights, flights and bookings

        FDF

        Cash management and forecast

        FDK

        IS-U/FERC: Drill down to line items and paths

        FEF

        Cash Management - Memo Records

        FILA

        Lease Accounting

        FMF

        Funds Management

        FPMF

        LDB, reads FPAYH and FPAYP

        FRF

        Drill-down Selection Screen

        FSF

        Cash Management Totals Records

        FTI_BW_CFM_VALUES

        Market Values and Simulated Values in Pos. Mgmt

        FTI_LO_PERIODS

        Loan/CML Period Evaluations

        FTI_LO_POSITIONS

        Loan /CML Positions

        FTI_SWAP_POSITION

        Swap Positions

        FTI_TR_CASH_FLOWS

        Treasury Payment Information

        FTI_TR_PERIODS

        Treasury: Period-Based Evaluations

        FTI_TR_PL_CF

        Treasury: Revenue and Cash Flow Reporting

        FTI_TR_POSITIONS

        Treasury Positions

        FTLM_DB01

        Limit Management

        FUK

        IS-U/FERC: Drill back from document line items

        G1S

        text

        GLG

        FI-SL Totals and Line Items

        GLU3

        Flexible G/L

        I1L

        Inventory data for storage bin

        I2L

        Warehouse quants for storage bin

        I3L

        Inventory documents

        IBF

        Real Estate Logical Database (Lease-Out)

        IDF

        Real Estate Logical Database

        IDFPLUS

        Real Estate Plus Logical Database

        IFM

        Purchasing Info Records: General

        ILM

        Archiving Purchasing Info Records

        IMA

        Logical database for investment programs

        IMC

        IM Summarization (not usable operationally)

        IMM

        Inventory documents for material

        IMR

        Approp. requests (not operationally functional)

        IMT

        Approp. requests (not operationally functional)

        INM

        Inventory documents

        IOC

        Shop floor control - order info system

        IPM_ACE_LDBDS

        Accrual Object Distribution Server Reporting Table

        IPM_ACE_LDBPS

        Accrual Engine Posting Server Reporting Database

        IRM

        Reorganization of inventory documents

        J5F

        Logical Database for new Nota Fiscal Database

        K1V

        Generating Conditions

        KDF

        Vendor Database

        KIV

        Customer Material Information

        KKF

        Balance Audit Trail of Open Items

        KLF

        Historical Balance Audit Trail

        KMV

        SD Documents for Credit Limit

        KOV

        Selection of Condition Records

        L1L

        Evaluation Whse Documents

        L1M

        Stock movements for material

        LMM

        Stock Movements for Material

        LNM

        Stock movements

        LO_CHANGE_MNMT

        Logical database for engineering change management

        MAF

        Dataset for Dunning Notices

        MDF

        Logical Database for Master Data Selection

        MEPOLDB

        Logical Database/Selection of Purch. Order Tables

        MIV

        BC: Planned flights, flights and bookings

        MMIMRKPFRESB

        Selection from Reservations

        MRM

        Reorganization of material documents

        MSM

        Material master

        NOTIF

        LDB for Basic Notifications

        NOTIFICATIONS

        NTI

        Logical database object networking

        ODC

        Shop floor control - orders per MRP controller

        ODK

        Orders

        OFC

        Shop floor control - orders per prod.scheduler

        OHC

        Shop floor control - orders by numbers

        OPC

        Shop floor control - orders by material

        PAK

        CO-PA Segment Level and Line Items

        PAP

        Applicant master data

        PCH

        Personnel Planning

        PGQ

        QM: Specs and Results of the Quality Inspection

        PMI

        Structure database (plant maintenance)

        PNI

        PM Planning Database

        PNM

        Planning database

        PNM_OLD

        Planning Database

        PNP

        HR Master Data

        PNPCE

        HR Master Data (Incl. Concurrent Employment)

        POH

        Production orders database - header

        PSJ

        Project system

        PTRVP

        Travel Management

        PYF

        Database for Payment Medium Print Programs

        QAM

        Inspection Catalogs: Selected Sets

        QAQ

        Inspection Catalogs: Selected Sets

        QCM

        Inspection Catalogs: Codes

        QCQ

        Inspection Catalogs: Codes

        QMI

        Logical database (PM notifications)

        QMQ

        Inspection Characteristics

        QNQ

        Quality Notifications

        QTQ

        Logical database for inspection methods

        QUERYTESTLDB

        Test LDB for InfoSet Query

        R0L

        Archive selection: Transfer orders (MM-WM)

        R1L

        Archive selection: Transfer requirements (MM-WM)

        R2L

        Archive Selection: Posting Change Notices (MM-WM)

        R3L

        Archive selection: Inventory documents (MM-WM)

        R4L

        Archive selection: Inventory histories (MM-WM)

        RBL

        Archiving of transfer requests

        REAO

        Real Estate: Logical Database for Architecture

        REBD

        Logical Database for Real Estate Objects

        REBP

        Logical Database via Partner (Real Estate)

        RECN

        Real Estate: Selection by Contracts

        RECONTRACT

        RE Logical Database: (General) Contract

        RHL

        Archiving of inventory history

        RIL

        Archiving of inventory documents

        RKM

        Reservations for Account Assignment

        RLI

        Logical Database Reference Location

        RMM

        Reservations for material

        RNM

        Reservations

        RTL

        Archiving of transfer orders

        RUL

        Archiving of Posting Change Notices

        S1L

        Stock by storage bins

        S1L_OLD

        Stock by Storage Bins

        S2L

        Warehouse quant for material

        S3L

        Stocks

        SAK

        Completely Reversed Allocation Documents

        SD_KUSTA

        Logical Database for Sales Summary

        SD_ORDER

        Logical database for inquiries, contracts

        SD_SALES_DOCUMENT

        Logical database for inquiries, contracts

        SDF

        G/L Account Database

        SMI

        Serial Number Management

        T1L

        Transfer orders by number

        T1L_OLD

        Transfer Orders by Number

        T2L

        Transfer orders for material

        T3L

        Transfer orders for storage type

        T4L

        Transfer order for TO printing

        T5L

        Transfer orders for reference number

        TAF

        Treasury

        TIF

        Treasury Information System

        TPI

        Functional Location Logical Database

        U1S

        User master reorganization: Password changes

        U2S

        User master reorganization: Password changes

        U3S

        User master reorganization: Password changes

        U4S

        User master reorganization: Password changes

        UKM_BUPA

        SAP Credit Management: Business Partner

        V12L

        Pricing Report

        VAV

        Logical Database RV: Sales Documents

        VC1

        List of Sales Activities

        VC2

        Generate Address List

        VDF

        Customer Database with View of Document Index

        VFV

        Logical Database RV: Billing Documents

        VLV

        Logical Database For Deliveries

        VVAV

        Logical Database RV: Sales Documents

        VXV

        SD: Billing Document - Export

        WAF

        Securities position plus additional master data

        WOI

        Maintenance Item

        WPI

        Maintenance plans

        WTF

        Securities positions and flows

        WTY

        WTY LD

        WUF

        Sec.-Determ.master data for positions

        -


         

        I hope this will delh

      • Re: logical database in sd
        CARLOS YEPEZ
        Currently Being Moderated

        The table you are looking for is the VBFA it contains all the SD flow since the sales order to the Billing.

         

        Regards,

        Carlos

Actions