BDC ERROR: ​Formatting error in the field CAUFVD-GSTRP; see next message Enter date in the format _

[former_member771716]

ERROR: Formatting error in the field CAUFVD-GSTRP; see next message Enter date in the format __.__.____

Program:

TYPES: BEGIN OF TY_IW31,
PM_AUFART(4) TYPE C, "Order Type for Maintenance Orders
IWERK(4) TYPE C, "Maintenance Planning Plant
GSBER(4) TYPE C, "Business Area
KTEXT(40) TYPE C, "Description
VAPLZ(8) TYPE C, "Main work center for maintenance tasks
PERNR(8) TYPE C, "Personnel Number
ILART(3) TYPE C, "Maintenance activity type
SUBNO(3) TYPE C, "PM Sub Activity type
ARBEI(7) TYPE C, "Work involved in the activity
LARNT(6) TYPE C, "Activity Type
GSTRP(10) TYPE C, "Basic start date
GLTRP(10) TYPE C, "Basic finish date
KDAUF_AUFK(10) TYPE C, "Sales Order Number
KDPOS_AUFK(6) TYPE C, "Item Number in Sales Order
END OF TY_IW31.

DATA: IT_FINAL TYPE TABLE OF TY_IW31,
WA_FINAL TYPE TY_IW31.

excel file upload value :

field value like - 2020.01.17 2020.01.18

[Sandra_Rossi]

I guess CAUFVD-GSTRP is a date screen field. In the screens, you must enter dates in the format __.__.____ as you know.

[former_member771716]

Thank you for your comments...