What is C_CustomerAddressIDValueHelp in SAP S/4HANA?

C_CustomerAddressIDValueHelp is a consumption CDS view in SAP S/4HANA. Customer Address ID Value Help It contains 56 fields.

Which tables does C_CustomerAddressIDValueHelp read from?

C_CustomerAddressIDValueHelp reads data from: I_Address.

What VDM layer is C_CustomerAddressIDValueHelp?

C_CustomerAddressIDValueHelp is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CustomerAddressIDValueHelp

DDL: C_CUSTOMERADDRESSIDVALUEHELP SQL: CCUSTADDRIDVH Type: view CONSUMPTION Package: ODATA_CA_ADDR

56 Fields 1 Data Sources

Customer Address ID Value Help

C_CustomerAddressIDValueHelp is a Consumption CDS View that provides data about "Customer Address ID Value Help" in SAP S/4HANA. It reads from 1 data source (I_Address) and exposes 56 fields with key fields AddressID, ReferenceObjectID. Part of development package ODATA_CA_ADDR.

Data Sources (1)

Source	Alias	Join Type
I_Address	Address	left_outer

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CCUSTADDRIDVH	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.semanticKey	FullName	view
ObjectModel.dataCategory	#VALUE_HELP	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
EndUserText.label	Customer Address ID Value Help	view
VDM.viewType	#CONSUMPTION	view
Search.searchable	true	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (56)

Key	Field	Source Table	Source Field	Description
KEY	AddressID
KEY	ReferenceObjectID
	FullName	I_Address	FullName	Name
	BusinessPartnerName1	I_Address	BusinessPartnerName1	Name
	BusinessPartnerName2	I_Address	BusinessPartnerName2	Name 2
	StreetName	I_Address	StreetName	Text
	HouseNumber	I_Address	HouseNumber	House Number
	PostalCode	I_Address	PostalCode	Postal Code
	CityName	I_Address	CityName	Name
	District	I_Address	District	District Court
	Country	I_Address	Country	Venue: Ctry/Reg
	Region	I_Address	Region	Venue Region
	CustomerName	Customer	CustomerName	Name of Customer
	CareOfName	I_Address	CareOfName	c/o
	AdditionalStreetSuffixName	I_Address	AdditionalStreetSuffixName	Street 5
	CorrespondenceLanguage	I_Address	CorrespondenceLanguage	Language
	PrfrdCommMediumType	I_Address	PrfrdCommMediumType	Comm. Method
	POBox	I_Address	POBox	PO Box
	POBoxIsWithoutNumber	I_Address	POBoxIsWithoutNumber	PO Box w/o No.
	POBoxPostalCode	I_Address	POBoxPostalCode	PO Box Postal Code
	POBoxLobbyName	I_Address	POBoxLobbyName	PO Box Lobby
	POBoxDeviatingCityName	I_Address	POBoxDeviatingCityName	PO Box City
	POBoxDeviatingRegion	I_Address	POBoxDeviatingRegion	PO Region
	POBoxDeviatingCountry	I_Address	POBoxDeviatingCountry	PO Box C/R
	DeliveryServiceTypeCode	I_Address	DeliveryServiceTypeCode	Delvry Serv Type
	DeliveryServiceNumber	I_Address	DeliveryServiceNumber	Delivery Service No.
	AddressTimeZone	I_Address	AddressTimeZone	Time Zone
	CityCode	I_Address	CityCode	IATA: City
	HomeCityName	I_Address	HomeCityName	Different City
	CompanyPostalCode	I_Address	CompanyPostalCode	Company Post Cd
	StreetPrefixName	I_Address	StreetPrefixName	Street 2
	AdditionalStreetPrefixName	I_Address	AdditionalStreetPrefixName	Street 3
	StreetSuffixName	I_Address	StreetSuffixName	Street 4
	HouseNumberSupplementText	I_Address	HouseNumberSupplementText	Supplement
	Building	I_Address	Building	Building code
	Floor	I_Address	Floor	Floor
	RoomNumber	I_Address	RoomNumber	Room Number
	County	I_Address	County	Wyoming County
	FormOfAddress	I_Address	FormOfAddress	Title Key
	Nation	I_Address	Nation	Country/Region
	PhoneNumber	I_Address	PhoneNumber	Telephone no.
	FaxNumber	I_Address	FaxNumber	Fax Number
	SearchTerm1	I_Address	SearchTerm1	Search Term 1
	StreetSearch	I_Address	StreetSearch	Street
	CitySearch	I_Address	CitySearch	City
	BusinessPartnerName3	I_Address	BusinessPartnerName3	Name 3
	BusinessPartnerName4	I_Address	BusinessPartnerName4	Name 4
	TaxJurisdiction	I_Address	TaxJurisdiction	Tax Jurisdiction
	TransportZone	I_Address	TransportZone	Transport Zone
	Person	I_Address	Person	Person/ Farm/ Field
	EmailAddress	_DefaultEmailAddress	EmailAddress	E-Mail Address
	Customer	Customer	Customer	Sold-to Party
	CustomerAccountGroup	Customer	CustomerAccountGroup	Account group
	AuthorizationGroup	Customer	AuthorizationGroup	AuthorizGroup
	IsBusinessPurposeCompleted	Customer	IsBusinessPurposeCompleted	Purpose Completed
	DataControllerSet	Customer	DataControllerSet	Data Ctrlr. Set

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_CustomerAddressIDValueHelp.
-- 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: CCUSTADDRIDVH

CREATE VIEW C_CustomerAddressIDValueHelp AS
SELECT
  cast(Customer.AddressID as caaddr_addressid preserving type ) AS AddressID,
  cast(Customer.Customer as caaddr_customerid preserving type ) AS ReferenceObjectID,
  Address.FullName AS FullName,
  Address.BusinessPartnerName1 AS BusinessPartnerName1,
  Address.BusinessPartnerName2 AS BusinessPartnerName2,
  Address.StreetName AS StreetName,
  Address.HouseNumber AS HouseNumber,
  Address.PostalCode AS PostalCode,
  Address.CityName AS CityName,
  Address.District AS District,
  Address.Country AS Country,
  Address.Region AS Region,
  Customer.CustomerName AS CustomerName,
  Address.CareOfName AS CareOfName,
  Address.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  Address.CorrespondenceLanguage AS CorrespondenceLanguage,
  Address.PrfrdCommMediumType AS PrfrdCommMediumType,
  Address.POBox AS POBox,
  Address.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  Address.POBoxPostalCode AS POBoxPostalCode,
  Address.POBoxLobbyName AS POBoxLobbyName,
  Address.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  Address.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  Address.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  Address.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  Address.DeliveryServiceNumber AS DeliveryServiceNumber,
  Address.AddressTimeZone AS AddressTimeZone,
  Address.CityCode AS CityCode,
  Address.HomeCityName AS HomeCityName,
  Address.CompanyPostalCode AS CompanyPostalCode,
  Address.StreetPrefixName AS StreetPrefixName,
  Address.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  Address.StreetSuffixName AS StreetSuffixName,
  Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  Address.Building AS Building,
  Address.Floor AS Floor,
  Address.RoomNumber AS RoomNumber,
  Address.County AS County,
  Address.FormOfAddress AS FormOfAddress,
  Address.Nation AS Nation,
  Address.PhoneNumber AS PhoneNumber,
  Address.FaxNumber AS FaxNumber,
  Address.SearchTerm1 AS SearchTerm1,
  Address.StreetSearch AS StreetSearch,
  Address.CitySearch AS CitySearch,
  Address.BusinessPartnerName3 AS BusinessPartnerName3,
  Address.BusinessPartnerName4 AS BusinessPartnerName4,
  Address.TaxJurisdiction AS TaxJurisdiction,
  Address.TransportZone AS TransportZone,
  Address.Person AS Person,
  _DefaultEmailAddress.EmailAddress AS EmailAddress,
  Customer.Customer AS Customer,
  Customer.CustomerAccountGroup AS CustomerAccountGroup,
  Customer.AuthorizationGroup AS AuthorizationGroup,
  Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  Customer.DataControllerSet AS DataControllerSet
LEFT OUTER JOIN I_Address AS Address ON /* join condition not captured in parsed metadata */
;

Depth:

C_CustomerAddressIDValueHelp view

I_Address view