I_BPCustAddressDependentInfoTP

DDL: I_BPCUSTADDRESSDEPENDENTINFOTP SQL: ICUSTADDRDEPTP Type: view TRANSACTIONAL
18 Fields 1 Data Sources 3 Associations

TP View for Addr Dep Customer General

I_BPCustAddressDependentInfoTP is a Transactional CDS View that provides data about "TP View for Addr Dep Customer General" in SAP S/4HANA. It reads from 1 data source (I_CustAddrDepdntInformation) and exposes 18 fields with key fields AddressID, BusinessPartner, Customer. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CustAddrDepdntInformation CustAddrDepdntInformation from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.businesspartner = _BusinessPartner.BusinessPartner
[0..1] E_CustAddrDepdntInformation _ActiveExtension $projection.Customer = _ActiveExtension.Customer and $projection.AddressID = _ActiveExtension.AddressID
[0..1] E_CustAddrDepdntInformation _DraftExtension $projection.Customer = _DraftExtension.Customer and $projection.AddressID = _DraftExtension.AddressID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTADDRDEPTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label TP View for Addr Dep Customer General view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.writeEnabled true view
ObjectModel.writeDraftPersistence BPCUSTADDRDTP_D view
ObjectModel.draftEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY AddressID I_CustAddrDepdntInformation AddressID Ship-to address
KEY BusinessPartner
KEY Customer I_CustAddrDepdntInformation Customer Sold-to Party
ExpressTrainStationName I_CustAddrDepdntInformation ExpressTrainStationName Express station
TrainStationName I_CustAddrDepdntInformation TrainStationName Train station
CityCode I_CustAddrDepdntInformation CityCode IATA: City
County I_CustAddrDepdntInformation County Wyoming County
CustomerForEdit I_CustAddrDepdntInformation Customer Sold-to Party
AddressIDForEdit I_CustAddrDepdntInformation AddressID Ship-to address
BusinessPartnerForEdit
BusinessPartnerUUID
BusinessPartnerCategory
Region
Country
FormattedAddress
ShipToPartyFormattedAddress
_Customer _Customer
_BusinessPartner _BusinessPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BPCustAddressDependentInfoTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICUSTADDRDEPTP

CREATE VIEW I_BPCustAddressDependentInfoTP AS
SELECT
  CustAddrDepdntInformation.AddressID AS AddressID,
  CustAddrDepdntInformation._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  CustAddrDepdntInformation.Customer AS Customer,
  CustAddrDepdntInformation.ExpressTrainStationName AS ExpressTrainStationName,
  CustAddrDepdntInformation.TrainStationName AS TrainStationName,
  CustAddrDepdntInformation.CityCode AS CityCode,
  CustAddrDepdntInformation.County AS County,
  CustAddrDepdntInformation.Customer AS CustomerForEdit,
  CustAddrDepdntInformation.AddressID AS AddressIDForEdit,
  CustAddrDepdntInformation._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartnerForEdit,
  CustAddrDepdntInformation._Customer._CustomerToBusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  CustAddrDepdntInformation._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  cast( ' ' as regio ) AS Region,
  cast( ' ' as land1 ) AS Country,
  cast( ' ' as abap.sstring( 260 ) ) AS FormattedAddress,
  cast( ' ' as abap.sstring( 260 ) ) AS ShipToPartyFormattedAddress
FROM I_CustAddrDepdntInformation AS CustAddrDepdntInformation
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON businesspartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN E_CustAddrDepdntInformation AS _ActiveExtension ON Customer = _ActiveExtension.Customer AND AddressID = _ActiveExtension.AddressID  -- association [0..1]
LEFT OUTER JOIN E_CustAddrDepdntInformation AS _DraftExtension ON Customer = _DraftExtension.Customer AND AddressID = _DraftExtension.AddressID  -- association [0..1]
;

Learn More