I_LocationAccountAssignment

Location and Account Assignment | view: ILOCACCASSIGNMT | ATTR | Extraction: Not supported | Component: Functional Locations

Tables used: ILOA

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical (1)
Other (2)
🔗 Relations (23)

Column Name	Description
MaintObjectLocAcctAssgmtNmbr	Location and account assignment for technical object

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description
WorkCenterTypeCode	Object types of the CIM resource	Show values

Column Name	Description	Domain name
MaintObjectFreeDefinedAttrib	Sort Field	CHAR30
AssetRoom	Room	CHAR8

Master Data Relations	Join Conditions
ABC Indicator for Technical Object ABC Indicator for Technical Object Client	`I_LOCATIONACCOUNTASSIGNMENT.ABCINDICATOR == T370C.ABCKZ` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == T370C.MANDT`
Address Number Address Number ? ? Client	`I_LOCATIONACCOUNTASSIGNMENT.ADDRESSID == ADRC.ADDRNUMBER` `I_LOCATIONACCOUNTASSIGNMENT.[column in domain "AD_NATION"] == ADRC.NATION` `I_LOCATIONACCOUNTASSIGNMENT.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == ADRC.CLIENT`
Location of maintenance object Location of maintenance object Location of maintenance object Client Maintenance Plant	`I_LOCATIONACCOUNTASSIGNMENT.ASSETLOCATION == T499S.STAND` `I_LOCATIONACCOUNTASSIGNMENT.MAINTENANCEOBJECTLOCATION == T499S.STAND` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == T499S.MANDT` `I_LOCATIONACCOUNTASSIGNMENT.MAINTENANCEPLANT == T499S.WERKS`
Business Area Business Area Client	`I_LOCATIONACCOUNTASSIGNMENT.BUSINESSAREA == TGSB.GSBER` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == TGSB.MANDT`
Company Code Company Code Client	`I_LOCATIONACCOUNTASSIGNMENT.COMPANYCODE == T001.BUKRS` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == T001.MANDT`
Controlling Area Controlling Area Client	`I_LOCATIONACCOUNTASSIGNMENT.CONTROLLINGAREA == TKA01.KOKRS` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == TKA01.MANDT`
Cost Center Cost Center Controlling Area ? Client	`I_LOCATIONACCOUNTASSIGNMENT.COSTCENTER == CSKS.KOSTL` `I_LOCATIONACCOUNTASSIGNMENT.CONTROLLINGAREA == CSKS.KOKRS` `I_LOCATIONACCOUNTASSIGNMENT.[column in domain "DATBI"] == CSKS.DATBI` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == CSKS.MANDT`
Distribution channel Sales Organization Distribution Channel Client	`I_LOCATIONACCOUNTASSIGNMENT.SALESORGANIZATION == TVKOV.VKORG` `I_LOCATIONACCOUNTASSIGNMENT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == TVKOV.MANDT`
Division Division Division Sales Organization Distribution Channel Client	`I_LOCATIONACCOUNTASSIGNMENT.DIVISION == TVTA.SPART` `I_LOCATIONACCOUNTASSIGNMENT.ORGANIZATIONDIVISION == TVTA.SPART` `I_LOCATIONACCOUNTASSIGNMENT.SALESORGANIZATION == TVTA.VKORG` `I_LOCATIONACCOUNTASSIGNMENT.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == TVTA.MANDT`
Asset Subnumber Asset Subnumber Company Code Main Asset Number Client	`I_LOCATIONACCOUNTASSIGNMENT.FIXEDASSET == ANLA.ANLN2` `I_LOCATIONACCOUNTASSIGNMENT.COMPANYCODE == ANLA.BUKRS` `I_LOCATIONACCOUNTASSIGNMENT.MASTERFIXEDASSET == ANLA.ANLN1` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == ANLA.MANDT`
Functional Location Functional Location Client	`I_LOCATIONACCOUNTASSIGNMENT.FUNCTIONALLOCATION == IFLOT.TPLNR` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == IFLOT.MANDT`
Location of maintenance object Location of maintenance object Location of maintenance object Client Maintenance Plant	`I_LOCATIONACCOUNTASSIGNMENT.ASSETLOCATION == T499S.STAND` `I_LOCATIONACCOUNTASSIGNMENT.MAINTENANCEOBJECTLOCATION == T499S.STAND` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == T499S.MANDT` `I_LOCATIONACCOUNTASSIGNMENT.MAINTENANCEPLANT == T499S.WERKS`
Maintenance Plant Client Maintenance Plant	`I_LOCATIONACCOUNTASSIGNMENT.MANDT == T001W.MANDT` `I_LOCATIONACCOUNTASSIGNMENT.MAINTENANCEPLANT == T001W.WERKS`
Division Division Division Sales Organization Distribution Channel Client	`I_LOCATIONACCOUNTASSIGNMENT.DIVISION == TVTA.SPART` `I_LOCATIONACCOUNTASSIGNMENT.ORGANIZATIONDIVISION == TVTA.SPART` `I_LOCATIONACCOUNTASSIGNMENT.SALESORGANIZATION == TVTA.VKORG` `I_LOCATIONACCOUNTASSIGNMENT.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == TVTA.MANDT`
Plant Section Plant Section Client Maintenance Plant	`I_LOCATIONACCOUNTASSIGNMENT.PLANTSECTION == T357.BEBER` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == T357.MANDT` `I_LOCATIONACCOUNTASSIGNMENT.MAINTENANCEPLANT == T357.WERKS`
Sales group Sales group Sales office Client	`I_LOCATIONACCOUNTASSIGNMENT.SALESGROUP == TVBVK.VKGRP` `I_LOCATIONACCOUNTASSIGNMENT.SALESOFFICE == TVBVK.VKBUR` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == TVBVK.MANDT`
Sales organization Sales Organization Client	`I_LOCATIONACCOUNTASSIGNMENT.SALESORGANIZATION == TVKO.VKORG` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == TVKO.MANDT`
Settlement order Settlement order Client	`I_LOCATIONACCOUNTASSIGNMENT.SETTLEMENTORDER == AUFK.AUFNR` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == AUFK.MANDT`
Standing order number Standing order number Client	`I_LOCATIONACCOUNTASSIGNMENT.STANDINGORDERNUMBER == AUFK.AUFNR` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == AUFK.MANDT`
Object ID of PP work center Object types of the CIM resource Object ID of PP work center Client	`I_LOCATIONACCOUNTASSIGNMENT.WORKCENTERTYPECODE == CRID.OBJTY` `I_LOCATIONACCOUNTASSIGNMENT.WORKCENTERINTERNALID == CRID.OBJID` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == CRID.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Sales office Division Division Sales Organization Sales office Distribution Channel Client	`I_LOCATIONACCOUNTASSIGNMENT.DIVISION == TVKBZ.SPART` `I_LOCATIONACCOUNTASSIGNMENT.ORGANIZATIONDIVISION == TVKBZ.SPART` `I_LOCATIONACCOUNTASSIGNMENT.SALESORGANIZATION == TVKBZ.VKORG` `I_LOCATIONACCOUNTASSIGNMENT.SALESOFFICE == TVKBZ.VKBUR` `I_LOCATIONACCOUNTASSIGNMENT.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG` `I_LOCATIONACCOUNTASSIGNMENT.MANDT == TVKBZ.MANDT`