I_CustomerDepartmentTP

Transactional Processing view for Customer Department | view: IBPDEPARTMENTTP | Extraction: Not supported | Component: Business Partners
Tables used: BUT000KNA1WRF4CVI_CUST_LINK
Column Name Description
Customer FK Customer Number
CustomerDepartment FK Department number
BusinessPartner Business Partner 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
BusinessPartnerForEdit Business Partner Number BU_PARTNER
BusinessPartnerUUID Business Partner GUID SYSUUID
ReceivingPoint Receiving Point TEXT25
Master Data Relations Join Conditions
Customer Number
  • Customer Number
  • Customer Number
  • Client
  • I_CUSTOMERDEPARTMENTTP.CUSTOMER == KNA1.KUNNR
  • I_CUSTOMERDEPARTMENTTP.CUSTOMERFOREDIT == KNA1.KUNNR
  • I_CUSTOMERDEPARTMENTTP.MANDT == KNA1.MANDT
Department number
  • Department number
  • Department number
  • Client
  • I_CUSTOMERDEPARTMENTTP.CUSTOMERDEPARTMENT == TSAB.ABTNR
  • I_CUSTOMERDEPARTMENTTP.CUSTOMERDEPARTMENTFOREDIT == TSAB.ABTNR
  • I_CUSTOMERDEPARTMENTTP.MANDT == TSAB.MANDT
Department number
  • Department number
  • Department number
  • Client
  • I_CUSTOMERDEPARTMENTTP.CUSTOMERDEPARTMENT == TSAB.ABTNR
  • I_CUSTOMERDEPARTMENTTP.CUSTOMERDEPARTMENTFOREDIT == TSAB.ABTNR
  • I_CUSTOMERDEPARTMENTTP.MANDT == TSAB.MANDT
Customer Number
  • Customer Number
  • Customer Number
  • Client
  • I_CUSTOMERDEPARTMENTTP.CUSTOMER == KNA1.KUNNR
  • I_CUSTOMERDEPARTMENTTP.CUSTOMERFOREDIT == KNA1.KUNNR
  • I_CUSTOMERDEPARTMENTTP.MANDT == KNA1.MANDT
Layout
  • Layout
  • Client
  • I_CUSTOMERDEPARTMENTTP.DEPARTMENTLAYOUT == TWGV.LAYVR
  • I_CUSTOMERDEPARTMENTTP.MANDT == TWGV.MANDT
Area variant
  • Client
  • Area schema
  • I_CUSTOMERDEPARTMENTTP.MANDT == TWGF.MANDT
  • I_CUSTOMERDEPARTMENTTP.DEPARTMENTLAYOUTAREASCHEMA == TWGF.FLVAR
Sales area (floor space) unit
  • Sales area (floor space) unit
  • Client
  • I_CUSTOMERDEPARTMENTTP.RETAILLOCATIONSELLINGAREAUNIT == T006.MSEHI
  • I_CUSTOMERDEPARTMENTTP.MANDT == T006.MANDT