C_BPCustAddrDepdntInformation

DDL: C_BPCUSTADDRDEPDNTINFORMATION SQL: CCUSTADDRDEPTP Type: view CONSUMPTION
22 Fields 1 Data Sources 5 Associations

C view for Addr Dependent Cust General

C_BPCustAddrDepdntInformation is a Consumption CDS View that provides data about "C view for Addr Dependent Cust General" in SAP S/4HANA. It reads from 1 data source (I_BPCustAddressDependentInfoTP) and exposes 22 fields with key fields AddressID, BusinessPartner, Customer. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPCustAddressDependentInfoTP CustAddrDepdntInformation from

Associations (5)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[0..1] C_BPAddressValueHelp _BPAddressValueHelp $projection.BusinessPartner = _BPAddressValueHelp.BusinessPartner and $projection.AddressID = _BPAddressValueHelp.AddressNumber
[0..*] I_CityCodeText _CityCodeText $projection.CityCode = _CityCodeText.CityCode and $projection.Country = _CityCodeText.Country and $projection.Region = _CityCodeText.Region
[0..*] C_CountyCodeTempValueHelpText _CountyCodeText $projection.County = _CountyCodeText.County and $projection.Region = _CountyCodeText.Region and $projection.Country = _CountyCodeText.Country

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CCUSTADDRDEPTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label C view for Addr Dependent Cust General view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.type #CONSUMPTION view
ObjectModel.writeEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
UI.headerInfo.typeName Address-Dependent Information view
UI.headerInfo.typeNamePlural Address-Dependent Information view
VDM.viewType #CONSUMPTION view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY AddressID I_BPCustAddressDependentInfoTP AddressID Ship-to address
KEY BusinessPartner I_BPCustAddressDependentInfoTP BusinessPartner Issuing Authority
KEY Customer I_BPCustAddressDependentInfoTP Customer Sold-to Party
ExpressTrainStationName I_BPCustAddressDependentInfoTP ExpressTrainStationName Express station
TrainStationName I_BPCustAddressDependentInfoTP TrainStationName Train station
CityCode I_BPCustAddressDependentInfoTP CityCode IATA: City
County I_BPCustAddressDependentInfoTP County Wyoming County
CustomerForEdit I_BPCustAddressDependentInfoTP CustomerForEdit Customer
AddressIDForEdit I_BPCustAddressDependentInfoTP AddressIDForEdit Address Number
BusinessPartnerForEdit I_BPCustAddressDependentInfoTP BusinessPartnerForEdit Busn. Partner
BusinessPartnerUUID I_BPCustAddressDependentInfoTP BusinessPartnerUUID UUID
Region I_BPCustAddressDependentInfoTP Region Venue Region
Country I_BPCustAddressDependentInfoTP Country Venue: Ctry/Reg
FormattedAddress I_BPCustAddressDependentInfoTP FormattedAddress
BusinessPartnerCategory I_BPCustAddressDependentInfoTP BusinessPartnerCategory Partner Cat.
ShipToPartyFormattedAddress I_BPCustAddressDependentInfoTP ShipToPartyFormattedAddress
_Customer _Customer
_BusinessPartner _BusinessPartner
_BusinessPartnerCustomer _BusinessPartnerCustomer
_CityCodeText _CityCodeText
_CountyCodeText _CountyCodeText
_BPAddressValueHelp _BPAddressValueHelp

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 C_BPCustAddrDepdntInformation.
-- 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: CCUSTADDRDEPTP

CREATE VIEW C_BPCustAddrDepdntInformation AS
SELECT
  CustAddrDepdntInformation.AddressID AS AddressID,
  CustAddrDepdntInformation.BusinessPartner AS BusinessPartner,
  CustAddrDepdntInformation.Customer AS Customer,
  CustAddrDepdntInformation.ExpressTrainStationName AS ExpressTrainStationName,
  CustAddrDepdntInformation.TrainStationName AS TrainStationName,
  CustAddrDepdntInformation.CityCode AS CityCode,
  CustAddrDepdntInformation.County AS County,
  CustAddrDepdntInformation.CustomerForEdit AS CustomerForEdit,
  CustAddrDepdntInformation.AddressIDForEdit AS AddressIDForEdit,
  CustAddrDepdntInformation.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  CustAddrDepdntInformation.BusinessPartnerUUID AS BusinessPartnerUUID,
  CustAddrDepdntInformation.Region AS Region,
  CustAddrDepdntInformation.Country AS Country,
  CustAddrDepdntInformation.FormattedAddress AS FormattedAddress,
  CustAddrDepdntInformation.BusinessPartnerCategory AS BusinessPartnerCategory,
  CustAddrDepdntInformation.ShipToPartyFormattedAddress AS ShipToPartyFormattedAddress
FROM I_BPCustAddressDependentInfoTP AS CustAddrDepdntInformation
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BPAddressValueHelp AS _BPAddressValueHelp ON BusinessPartner = _BPAddressValueHelp.BusinessPartner AND AddressID = _BPAddressValueHelp.AddressNumber  -- association [0..1]
LEFT OUTER JOIN I_CityCodeText AS _CityCodeText ON CityCode = _CityCodeText.CityCode AND Country = _CityCodeText.Country AND Region = _CityCodeText.Region  -- association [0..*]
LEFT OUTER JOIN C_CountyCodeTempValueHelpText AS _CountyCodeText ON County = _CountyCodeText.County AND Region = _CountyCodeText.Region AND Country = _CountyCodeText.Country  -- association [0..*]
;

Learn More