09-07-2008 6:20 AM
In my below script editor coding the "Payment Due Immediately" is hard coded.
/: SET DATE MASK = "MM/DD/YYYY"
/* -- Invoice Information
/: IF &BSEG-BSCHL& EQ '01'.
DN <B>DEBIT MEMO NO. &BKPF-BELNR& </>
SP
IN ISSUE DATE: &BKPF-BLDAT&
/
/
/
IN <B>TERMS: Payment Due Immediately </>
/: ENDIF.
Now I need build logic to use T052u table or TVZBT to bring text (TEXT1 field) for zterm instead of hard coding which is wrong.
Please correct me if I am wrong --> I need to write the logic in subroutine pool program to bring TEXT1 field from T052u or TVZBT table say PERFORM GET_TVZBT_TEXT1 IN PROGRAM Z_F_P_LAYOUT_TEXT USING ??? (here what to use).
My problem is
What to write in SCRIPT editor and
*WHAT TO WRITE IN PROGRAM Z_F_P_LAYOUT_TEXT .
What I can use in where condition while selecting TEXT1 field from T052u or TVZBT table
THANKS IN ADVANCE.
09-07-2008 6:39 AM
Hi Sam Kumar,
Firstly to get the Text from the table T052U or TVZBT you need to have field.
ZTERM --->Terms of Payment Key
As you have BELNR field, you need to get teh ZTERM field from table BSEG ---> Accounting Document Segment. and then you need to fetch the text from the table T052U or TVZBT.
Best regards,
raam
09-07-2008 6:39 AM
Hi Sam Kumar,
Firstly to get the Text from the table T052U or TVZBT you need to have field.
ZTERM --->Terms of Payment Key
As you have BELNR field, you need to get teh ZTERM field from table BSEG ---> Accounting Document Segment. and then you need to fetch the text from the table T052U or TVZBT.
Best regards,
raam