addition of Customer tIN no. in Invoice standard smartform

[Former Member]

Hi experts,

Can anyone explain the step by step process how to add TIN number(Customer) below customer

in Payment information window.

Form name:LB_BIL_INVOICE

Smartform: RLB_INVOICE

TIN Number field: KNA1-STCD1

[Former Member · Accepted solution]

Hi .

declare one global varible tin_no type j_1icstno.

use table - j_1imocust

input customer no and get tin no.

select single tin no from this table into this variable and display.

Regards

[Former Member]

SELECT SINGLE STCEG FROM KNA1

INTO TIN_NO

WHERE KUNNR EQ wa_VBPA1-KUNNR.

[Former Member]

Hi Monika,

Please explain what are the declarations to be maintained in form interface or global definitions and tell me how to add customer tin no. (stcd1 field in kna1 table) in the payment window.

[Former Member]

DEFINE TIN_NO IN UR GLOBAL FIELD

LIKE TIN_NO LIKE KNA1-STCD1.

THEN WRITE UR CODE

SELECT SINGLE STCD1 FROM KNA1 INTO TIN_NO WHERE KUNNR EQ GS_HD_ADR-KUNNR.

[Former Member]

Thanks Monika. Problem solved.

There is small change in field name.Following code worked for me.

SELECT SINGLE STCD1 FROM KNA1

INTO TIN_NO

WHERE KUNNR EQ GS_HD_GEN-payer.

[Former Member]

hi , u gave points to someone else.

[Former Member]

You need to create Z smartform and then at the required location add the field KNA1-STCD1.

This might be assign at header lavel.

Kapil