I_CustomerDepartment

Customer Master Department Data | view: ICUSTDEPARTMENT | Extraction: Not supported | Component: Business Partners
Tables used: WRF4
Column Name Description
Customer FK Customer Number
CustomerDepartment FK Department number
Column Name Description
Column Name Description
📏 Sales area (floor space) unit (RetailLocationSellingAreaUnit):
RetailLocationSellingAreaSize Sales area (floor space)
Column Name Description
Column Name Description
Column Name Description Domain name
ReceivingPoint Receiving Point TEXT25
Master Data Relations Join Conditions
Customer Number
  • Customer Number
  • Client
  • I_CUSTOMERDEPARTMENT.CUSTOMER == KNA1.KUNNR
  • I_CUSTOMERDEPARTMENT.MANDT == KNA1.MANDT
Department number
  • Department number
  • Client
  • I_CUSTOMERDEPARTMENT.CUSTOMERDEPARTMENT == TSAB.ABTNR
  • I_CUSTOMERDEPARTMENT.MANDT == TSAB.MANDT
Layout
  • Layout
  • Client
  • I_CUSTOMERDEPARTMENT.DEPARTMENTLAYOUT == TWGV.LAYVR
  • I_CUSTOMERDEPARTMENT.MANDT == TWGV.MANDT
Area variant
  • Area schema
  • Client
  • I_CUSTOMERDEPARTMENT.DEPARTMENTLAYOUTAREASCHEMA == TWGF.FLVAR
  • I_CUSTOMERDEPARTMENT.MANDT == TWGF.MANDT
Sales area (floor space) unit
  • Sales area (floor space) unit
  • Client
  • I_CUSTOMERDEPARTMENT.RETAILLOCATIONSELLINGAREAUNIT == T006.MSEHI
  • I_CUSTOMERDEPARTMENT.MANDT == T006.MANDT