SAP table WYT3 (Partner Functions)

SAP table WYT3 has 7 primary key fields being MANDT,LIFNR,EKORG,LTSNR,WERKS,PARVW,PARZA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
EKORG Purchasing organization CHAR 4 0 T024E EKORG
LTSNR Supplier Subrange CHAR 6 0 WYT1 LTSNR
WERKS Plant CHAR 4 0 T001W WERKS_D
PARVW Partner Function CHAR 2 0 TPAR PARVW
PARZA Partner counter NUMC 3 0 PARZA
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
LIFN2 Reference to other supplier CHAR 10 0 LFA1 LIFN2
DEFPA Default Partner CHAR 1 0 DEFPA
PERNR Personnel Number NUMC 8 0 PERNR_D
PARNR Number of Contact Person NUMC 10 0 PARNR

WYT3 foreign key relationships

Table Field Check Table Check Field
0 WYT3 EKORG T024E Purchasing Organizations EKORG
1 WYT3 LIFN2 LFA1 Supplier Master (General Section) MANDT
1 WYT3 LIFN2 LFA1 Supplier Master (General Section) LIFNR
0 WYT3 LIFNR LFA1 Supplier Master (General Section) MANDT
0 WYT3 LIFNR LFA1 Supplier Master (General Section) LIFNR
1 WYT3 LTSNR WYT1 Vendor Subrange MANDT
1 WYT3 LTSNR WYT1 Vendor Subrange LIFNR
1 WYT3 LTSNR WYT1 Vendor Subrange LTSNR
0 WYT3 MANDT T000 Clients MANDT
1 WYT3 PARVW TPAR Business Partner: Functions PARVW
0 WYT3 WERKS T001W Plants/Branches WERKS