topic Logical Database Help in Application Development and Automation Discussions

Logical Database Help

Former Member — Thu, 25 Jan 2007 05:37:47 GMT

Hi,

If any brother have got the knowledge of LDB then please tell me that how to make a dynamic selection in LDB.

Scenerio : in VFV LDB i want to get VBRK-FKDAT (Billing Date) in my ABAP Program, so how to pass this dynamically means by selection screen.

Thanks,

Muhammad Usman Malik

Re: Logical Database Help

p291102 — Thu, 01 Feb 2007 05:21:06 GMT

Hi,

U can go through SLDB or SE36 transaction u can access the logical database builder

Thanks,

Shankar

Re: Logical Database Help

RaymondGiuseppi — Thu, 01 Feb 2007 14:21:25 GMT

Just create a select-options FOR VBRK-FKDAT in your program which use the LDB.

Regards.

Re: Logical Database Help

Sijin_Chandran — Mon, 05 Mar 2012 05:51:41 GMT

Hello ,

I also had the same problem and solved the same by changing the LDB VFV as told by the Raymond Sir,

First you need to register the Object R3TR LDBA VFV with SCCR to get the access key to change Logical Dbs SELECTION SCREEN code and SOURCE CODE section.

After that click Selections section of the LDB VFV and add Select options for field FKDAT.

Eg .

SELECT-OPTIONS: DD_ERDAT FOR VBRK-ERDAT.

*{ INSERT DEVK904455 1

SELECT-OPTIONS: DD_FKDAT FOR VBRK-FKDAT." Added to Bring Billing Date in logical Database VFV

*} INSERT

And after that change the Source code section of LDB VFV as follows

SELECT (L_TAB_FIELDS-FIELDS) INTO CORRESPONDING

FIELDS OF TABLE ZVBRK FROM VBRK

UP TO 100 ROWS

WHERE VBELN IN DD_VBELN AND

VBELN IN ILAST AND

VKORG IN DD_VKORG AND

*{ INSERT DEVK904455 1

FKDAT IN DD_FKDAT AND " Addded Billing Date in logical DB

*} INSERT

LAND1 IN DD_LAND1 AND

ERDAT IN DD_ERDAT AND