select distinctĪnd T077Y.SPRAS = 'E' and LFA1.KTOKK = 'Z012' and LFA1. You can link both the tables (LFA1 & ADR6) using address and address number. Now i am linking the ADR6 table with LFA1 using the field adress number for a particular vendor. Use Left Outer join between LFA1 and ADR6 table to get all vendors with email. Hi, I am trying to fetch the email ID from the table ADR6. I tried to add the case when for the query and sub-query as per below but I'm getting errors, please help. SAP Table: LFA1: Description: Vendor Master (General Section) Table Type.
Steps to create SAP Query SQVI Go to transaction code: SQVI Enter AVENDOREMAIL as shown below and click create button on the screen Select data source as Table join Select basis mode Once you press enter below screen appears. T189T (Conditions: Price List Categories: Texts) and ADR6 (E-Mail.
Inner join dgSAP_077Y as T077Y on LFA1.KTOKK = T077Y.KTOKK Use Left Outer join between LFA1 and ADR6 table to get all vendors with email address. Customized tables VBAP, VBAK, VBRP, VBRK, KNA1, LFA1 and MARA using append structures. I need to modify the below code using a CASE WHEN scenario where I want to add a new column to identify records returned as 'BAD' for the results returned in the below query.
0 kommentar(er)
