Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

first date field in va01

Former Member
0 Kudos

Hi all,

i have a requirement i.e i have to show the FIRST DATE of sales order line item

but am unable to find out the table name , when i pressed F1 i found that a structure name i.e. RV45A and field ETDAT but i want database table and correct field name.

plz its urgent.

Regards,

Amit

2 REPLIES 2

Former Member
0 Kudos

Hi Amit,

It is the schedule line date of the line item and you can get this from table<b> VBEP</b>(Sales Document: Schedule Line Data) and the field is <b>EDATU</b>.

Reward if helpful..

Thanks

Vinay

raymond_giuseppi
Active Contributor
0 Kudos

Data come from database table VBEP, it is mapped in sap transaction to your desired field :

CALL FUNCTION 'PERIOD_AND_DATE_CONVERT_OUTPUT'
     EXPORTING                                
          INTERNAL_DATE   = VBEP-EDATU        
          INTERNAL_PERIOD = VBEP-PRGRS        
     IMPORTING                                
          EXTERNAL_DATE   = VB_ETDAT          
          EXTERNAL_PERIOD = VB_PRGBZ.     

and back if changed in dynpro

CALL FUNCTION 'PERIOD_AND_DATE_CONVERT_INPUT' 
     EXPORTING                                
          EXTERNAL_DATE   = RV45A-ETDAT       
          EXTERNAL_PERIOD = RV45A-PRGBZ       
     IMPORTING                                
          INTERNAL_DATE   = VBEP-EDATU        
          INTERNAL_PERIOD = VBEP-PRGRS 

Regards