cancel
Showing results for 
Search instead for 
Did you mean: 

logical database in sd

Former Member
0 Kudos

hi experts,

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member183879
Active Contributor
0 Kudos

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

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

Former Member
0 Kudos

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

ranjeetrajendra_jain
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Regards,

Carlos

Answers (1)

Answers (1)

ranjeetrajendra_jain
Active Contributor
0 Kudos

What is a logical database?

If you mean list tables Follow the

[link|http://sapsdtech.googlegroups.com/web/Tables.doc?gda=3ye3Oj0AAABhyxSjSQZnzRMzLi3o-QiTrL1D4R2QUZ0cMAmfp3Np4aEfD8gizBqda3A8nb_OSkcIeLNSsMgh3dS_1Izx6tNq]

reards

Former Member
0 Kudos

hi..

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