EKUN

IS-U-Specific Fields for Business Partner | #masterdata | Component: Business Partner

🔑 Keys (2)
💰 Amounts
∑ Quantities
📅 Dates (5)
☰ Categorical (3)
Other (13)
🔗 Relations (15)

Column Name	Description
MANDT	Client
PARTNER FK	Business Partner Number

Column Name	Description

Column Name	Description

Column Name	Description
STATDATUM	Date on which status of installer comes into effect
ERSTZUL	Date of initial license of installer
WERKSTATT	Date of workshop inspection
VERLZUL	Date of license renewal
ENDEZUL	Date until which license is renewed

Column Name	Description
MITGLIED	Membership of installer	Show values
RECPTYPE	Category for Alternate Payee	Show values
VIP	Indicate Very Important Business Partner	Show values

Column Name	Description	Domain name
MUSTER_KUN	Reference for creating a standard customer for bus. partner	KUNNR
SPZULASS	Division license of installer	SPZULASS
AUSWANZ	Number of identifications	AUSWANZ
PLOMBENZ	Sealing pliers number	PLOMBENZ
ANZEVU	Number of utility companies	ANZEVU
ANZFIL	Number of branches supported by an installionr company	ANZFIL
AUSW_INST	Identification number for installer license	AUSW_INST
DR_LICENSE	Driver's license number	DR_LICENSE
SOC_SECURE	Social Insurance Number	E_SOC_SECU
WELFARE	Welfare office	WELFARE
PLACE_EMPL	Work center	CHAR40
EMBVT	Bank details ID for donations/fund payments	CHAR4
IDENT_INST	Identification Number for Installer License	IDENT_INST

Master Data Relations	Join Conditions
Company work field Company work field Client	`EKUN.ARBFELD == TE185.ARBFELD` `EKUN.MANDT == TE185.MANDT`
Installer license type Installer license type Client	`EKUN.ARTZULASS == TE189.ARTZULASS` `EKUN.MANDT == TE189.MANDT`
Information release for business partner data Information release for business partner data Client	`EKUN.BUPINFOREL == TEBUPINFOREL.INFOREL` `EKUN.MANDT == TEBUPINFOREL.MANDT`
Classification of Business Partner Classification of Business Partner Client	`EKUN.CLASSIFICATION == TE181.CLASSIFICATION` `EKUN.MANDT == TE181.MANDT`
Business partner-specific criteria for agent determination	`EKUN.MANDT == TECLERK_ID.MANDT` `EKUN.CLERK_ID == TECLERK_ID.CLERK_ID`
Country/Region in Which Driver's License Was Acquired Country/Region in Which Driver's License Was Acquired Client	`EKUN.DR_LICENSE_LAND1 == T005.LAND1` `EKUN.MANDT == T005.MANDT`
Region in which driver's license was acquired Country/Region in Which Driver's License Was Acquired Region in which driver's license was acquired	`EKUN.MANDT == T005S.MANDT` `EKUN.DR_LICENSE_LAND1 == T005S.LAND1` `EKUN.DR_LICENSE_REGIO == T005S.BLAND`
Type of installation company Type of installation company Client	`EKUN.FIRMART == TE183.FIRMART` `EKUN.MANDT == TE183.MANDT`
Main utility company	`EKUN.MANDT == TE187.MANDT` `EKUN.FREMDEVU == TE187.EVU`
G/L accounts for donations/fund payments ? Client G/L accounts for donations/fund payments	`EKUN.[column in domain "KTOPL"] == SKA1.KTOPL` `EKUN.MANDT == SKA1.MANDT` `EKUN.HKONT == SKA1.SAKNR`
Account Class Account Class Client	`EKUN.KTOKLASSE == KONTOKLASSE.KTOKL` `EKUN.MANDT == KONTOKLASSE.MANDT`
Business Partner Number Business Partner Number Client	`EKUN.PARTNER == BUT000.PARTNER` `EKUN.MANDT == BUT000.CLIENT`
Payment method for donations/fund payments Payment method for donations/fund payments ? Client	`EKUN.PYMET == TFK042Z.ZLSCH` `EKUN.[column in domain "LAND1"] == TFK042Z.LAND1` `EKUN.MANDT == TFK042Z.MANDT`
Valid status of installer in supply area Valid status of installer in supply area Client	`EKUN.STATINS == TE061.STATINS` `EKUN.MANDT == TE061.MANDT`
Employee classification	`EKUN.MANDT == TE697.MANDT` `EKUN.WAKLASS == TE697.WAKLASS`