I_CustDepartmentAddrDepdntInfo

Department dependent on Customer Address | view: ICUSDEPADDEP | Extraction: Not supported | Component: Business Partners
Tables used: WRF4_ADDR
Column Name Description
Customer FK Customer Number
AddressID FK Business Partner Address Number (from BUT020)
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
DepartmentLayout Layout LAYVAR
DepartmentLayoutAreaSchema Area schema FLVAR
Master Data Relations Join Conditions
Business Partner Address Number (from BUT020)
  • Business Partner Address Number (from BUT020)
  • Client
  • ?
  • I_CUSTDEPARTMENTADDRDEPDNTINFO.ADDRESSID == BUT020.ADDRNUMBER
  • I_CUSTDEPARTMENTADDRDEPDNTINFO.MANDT == BUT020.CLIENT
  • I_CUSTDEPARTMENTADDRDEPDNTINFO.[column in domain "BU_PARTNER"] == BUT020.PARTNER
Customer Number
  • Client
  • Customer Number
  • I_CUSTDEPARTMENTADDRDEPDNTINFO.MANDT == KNA1.MANDT
  • I_CUSTDEPARTMENTADDRDEPDNTINFO.CUSTOMER == KNA1.KUNNR
Department number
  • Department number
  • Client
  • I_CUSTDEPARTMENTADDRDEPDNTINFO.CUSTOMERDEPARTMENT == TSAB.ABTNR
  • I_CUSTDEPARTMENTADDRDEPDNTINFO.MANDT == TSAB.MANDT