I_BPCustDeptAddrDepdntInfoTP

TP view for CustDep AddrDepInfo | view: ICUSDEPADDEPTP | Extraction: Not supported | Component: Business Partners
Tables used: BUT000, WRF4_ADDR, KNA1, CVI_CUST_LINK
Column Name Description
Customer FK Customer Number
AddressID FK Business Partner Address Number (from BUT020)
BusinessPartner Business Partner 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
DepartmentLayout Layout LAYVAR
DepartmentLayoutAreaSchema Area schema FLVAR
BusinessPartnerForEdit Business Partner Number BU_PARTNER
FormattedAddress null
Master Data Relations Join Conditions
Business Partner Address Number (from BUT020)
  • ?
  • Business Partner Address Number (from BUT020)
  • Business Partner Address Number (from BUT020)
  • Client
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.[column in domain "BU_PARTNER"] == BUT020.PARTNER
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.ADDRESSID == BUT020.ADDRNUMBER
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.ADDRESSIDFOREDIT == BUT020.ADDRNUMBER
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.MANDT == BUT020.CLIENT
Business Partner Address Number (from BUT020)
  • ?
  • Business Partner Address Number (from BUT020)
  • Business Partner Address Number (from BUT020)
  • Client
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.[column in domain "BU_PARTNER"] == BUT020.PARTNER
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.ADDRESSID == BUT020.ADDRNUMBER
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.ADDRESSIDFOREDIT == BUT020.ADDRNUMBER
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.MANDT == BUT020.CLIENT
Customer Number
  • Customer Number
  • Customer Number
  • Client
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.CUSTOMER == KNA1.KUNNR
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.CUSTOMERFOREDIT == KNA1.KUNNR
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.MANDT == KNA1.MANDT
Department number
  • Department number
  • Department number
  • Client
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.CUSTOMERDEPARTMENTFOREDIT == TSAB.ABTNR
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.CUSTOMERDEPARTMENT == TSAB.ABTNR
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.MANDT == TSAB.MANDT
Department number
  • Department number
  • Department number
  • Client
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.CUSTOMERDEPARTMENTFOREDIT == TSAB.ABTNR
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.CUSTOMERDEPARTMENT == TSAB.ABTNR
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.MANDT == TSAB.MANDT
Customer Number
  • Customer Number
  • Customer Number
  • Client
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.CUSTOMER == KNA1.KUNNR
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.CUSTOMERFOREDIT == KNA1.KUNNR
  • I_BPCUSTDEPTADDRDEPDNTINFOTP.MANDT == KNA1.MANDT