Logical Database Help

[Former Member]

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

[p291102]

Hi,

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

Thanks,

Shankar

[RaymondGiuseppi]

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

Regards.

[Sijin_Chandran]

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