Which CDS Views use I_ADDRESS_2?

I_ADDRESS_2 is used by 40 CDS view(s), including: A_BPIntlAddressVersion, A_InbDeliveryAddress, A_OutbDeliveryAddress, A_ReturnsDeliveryAddress, A_SalesOrderItemPartnerAddress, A_SalesOrderPartnerAddress, A_SrvcConfItmPartnerAddress, A_SrvcConfPartnerAddress, A_SrvcOrdItmPartnerAddress, A_SrvcOrdPartnerAddress.

How many fields does I_ADDRESS_2 have?

I_ADDRESS_2 has 93 fields. Key fields: AddressID, AddressPersonID, AddressRepresentationCode.

I_ADDRESS_2

CDS View

93 Fields 40 CDS Views

Address of an Organization or a Person

I_ADDRESS_2 is a CDS View in S/4HANA. Address of an Organization or a Person. It contains 93 fields. 40 CDS views read from this table.

CDS Views using this table (40)

View	Type	Join	VDM	Description
A_BPIntlAddressVersion	view	inner	COMPOSITE	BP International Address Version
A_InbDeliveryAddress	view	from	COMPOSITE	CDS View for Address
A_OutbDeliveryAddress	view	from	COMPOSITE	CDS view for API exposure
A_ReturnsDeliveryAddress	view	from	COMPOSITE	Returns Delivery Address
A_SalesOrderItemPartnerAddress	view_entity	inner	COMPOSITE	Item Partner Address
A_SalesOrderPartnerAddress	view_entity	inner	COMPOSITE	Header Partner Address
A_SrvcConfItmPartnerAddress	view_entity	inner	COMPOSITE	Partner Address of Service Confirmation Item
A_SrvcConfPartnerAddress	view_entity	inner	COMPOSITE	Partner Address of Service Confirmation
A_SrvcOrdItmPartnerAddress	view_entity	inner	COMPOSITE	Partner Address of Service Order Item
A_SrvcOrdPartnerAddress	view_entity	inner	COMPOSITE	Partner Address of Service Order
A_SrvcOrdTmplItmPartnerAddress	view_entity	inner	COMPOSITE	Partner Address of Service Order Template Item
A_SrvcOrdTmplPartnerAddress	view_entity	inner	COMPOSITE	Partner Address of Service Order Template
C_Arberp_Address	view	from	CONSUMPTION	CDS View for Addresses
C_PurgCustomerBPShipToAddrVH	view	inner	CONSUMPTION	Customer Ship to Addresses
I_AddressDefaultRepresentation	view_entity	from	COMPOSITE	Dflt Addr Rprstn of an Org or a Person
I_AddressTP	view	from	TRANSACTIONAL	Address Reuse Component Transactional
I_BPCustomerMultiAddrVH	view	inner	COMPOSITE	Customers by Multiple Addresses
I_CN_GoldenTaxAddress	view	from	COMPOSITE	CN Golden Tax Interface Address
I_ES_ElectronicDocAccountDoc	view_entity	inner	COMPOSITE	Spain SII Header eDocument Consistency
I_NO_SAFTCustomerMasterData	view_entity	inner	COMPOSITE	Master data of customers for SAFT
I_NO_SAFTSupplierMasterData	view_entity	inner	COMPOSITE	Master data of suppliers for SAFT
I_ProdPlantPurchaseTax	view	inner	COMPOSITE	Composite View - Prod Plant Purchase Tax
I_PurchasingDeliveryAddressTP	view	from	TRANSACTIONAL	Purchasing Delivery Address - TP
I_Purctraddressint	view	left_outer	COMPOSITE	Purchase Contract Address Information
P_CompanyCodeDetailsPA	view	left_outer	COMPOSITE
P_NO_SAFTJournalCustSupMD	view	inner	COMPOSITE	SAF-T Norway Journal Item BP Master Data
P_PlantAbroadDetails	view	left_outer	COMPOSITE
P_TH_ADDRESS	view	from	COMPOSITE
P_TH_ADDRESS2	view	from	COMPOSITE
P_TH_SUPPLIER_ADDR_D	view_entity	from	COMPOSITE
P_TH_SUPPLIER_ADDR_T	view_entity	from	COMPOSITE
R_CFinRpldBillgDocPrtnAddrTP	view_entity	inner	TRANSACTIONAL	CFin Repl Billg Doc Partner Address - TP
R_CFinRpldBlgDcItmPrtnAddrTP	view_entity	inner	TRANSACTIONAL	CFin Repl Billg Doc Partner Address - TP
R_CFinRpldSlsDocItmPrtnAddrTP	view_entity	inner	TRANSACTIONAL	CFin Repl SalesDocItemPartnerAddr - TP
R_CFinRpldSlsDocPrtnAddressTP	view_entity	inner	TRANSACTIONAL	CFin Repl Sales Doc Partner Address - TP
R_TranspOrdBPAddrAddlRprstnTP	view_entity	inner	TRANSACTIONAL	Transp Ord BP Addr Addl Rprstn - TP
R_TrOrdItmMnBPAddrAddlRprstnTP	view_entity	inner	TRANSACTIONAL	Transp Ord Itm Main BP Addr Ad Rpn - TP
R_TrOrdMainBPAddrAddlRprstnTP	view_entity	inner	TRANSACTIONAL	Transp Ord Main BP Addr Addl Rprstn - TP
R_TrOrdStgeBPAddrAddlRprstnTP	view_entity	inner	TRANSACTIONAL	Transp Ord Stage BP Addr Addl Rpn - TP
R_TrOrdStopLocAddrAddlRprstnTP	view_entity	inner	TRANSACTIONAL	Transp Ord Stop Loc Addr Addl Rpn - TP

Fields (93)

Key	Field	CDS Fields	Used in Views
KEY	AddressID	AddressID	24
KEY	AddressPersonID	AddressPersonID,Person	16
KEY	AddressRepresentationCode	AddressRepresentationCode,Nation	18
	_AddressGroup	_AddressGroup	1
	_AddressObjectType	_AddressObjectType	1
	_AddressPersonName	_AddressPersonName	1
	_AddressRepresentationCode	_AddressRepresentationCode	6
	_CorrespondenceLanguage	_CorrespondenceLanguage	1
	_Country	_Country	2
	_CurrentDfltEmailAddress	_CurrentDfltEmailAddress	1
	_CurrentDfltFaxNumber	_CurrentDfltFaxNumber	1
	_CurrentDfltLandlinePhoneNmbr	_CurrentDfltLandlinePhoneNmbr	3
	_CurrentDfltMobilePhoneNumber	_CurrentDfltMobilePhoneNumber	3
	_DeliveryServiceTypeCode	_DeliveryServiceTypeCode	1
	_EmailAddress	_EmailAddress	1
	_FaxNumber	_FaxNumber	1
	_FormOfAddress	_FormOfAddress	1
	_MainWebsiteURL	_MainWebsiteURL	1
	_OrganizationAddress	_OrganizationAddress	1
	_PersonAddress	_PersonAddress	1
	_PhoneNumber	_PhoneNumber	1
	_POBoxAddrNonDeliverableReason	_POBoxAddrNonDeliverableReason	1
	_POBoxDeviatingCityCode	_POBoxDeviatingCityCode	1
	_POBoxDeviatingCountry	_POBoxDeviatingCountry	1
	_POBoxDeviatingRegion	_POBoxDeviatingRegion	1
	_PostalCity	_PostalCity	1
	_PrfrdCommMediumType	_PrfrdCommMediumType	1
	_Region	_Region	4
	_RegionalStructureCheckStatus	_RegionalStructureCheckStatus	1
	_SecondaryRegion	_SecondaryRegion	1
	_Street	_Street	1
	_StreetAddrNonDeliverableRsn	_StreetAddrNonDeliverableRsn	1
	_TertiaryRegion	_TertiaryRegion	1
	_TimeZone	_TimeZone	1
	_TransportationZone	_TransportationZone	1
	_UniformResourceIdentifier	_UniformResourceIdentifier	1
	AddressCreatedByUser	AddressCreatedByUser	4
	AddresseeFullName	AddresseeFullName,FullName,NameText	17
	AddressGroup	AddressGroup	2
	AddressObjectType	AddressObjectType	6
	AddressSearchTerm1	AddressSearchTerm1,SearchTerm1	6
	AddressSearchTerm2	AddressSearchTerm2	4
	AddressTimeZone	AddressTimeZone	13
	Building	Building	10
	CareOfName	CareOfName	13
	CityName	CityName,HomeCityName	34
	CityNumber	CityCode,CityNumber	12
	CompanyPostalCode	CompanyPostalCode	8
	CorrespondenceLanguage	CorrespondenceLanguage,Language	15
	Country	Country	32
	DeliveryServiceNumber	DeliveryServiceNumber	8
	DeliveryServiceTypeCode	DeliveryServiceTypeCode	8
	DistrictName	District,DistrictName	22
	DistrictNumber	DistrictNumber	4
	Floor	Floor	10
	FormOfAddress	FormOfAddress	14
	HouseNumber	HouseNumber	35
	HouseNumberSupplementText	HouseNumberSupplementText	10
	OrganizationName1	BusinessPartnerName1,CompanyCodeName,CompanyName,OrganizationName1	24
	OrganizationName2	BusinessPartnerName2,OrganizationName2	23
	OrganizationName3	BusinessPartnerName3,ConsigneeName3,OrganizationName3	21
	OrganizationName4	BusinessPartnerName4,ConsigneeName4,OrganizationName4	21
	PersonFamilyName	PersonFamilyName	3
	PersonGivenName	PersonGivenName	3
	POBox	POBox	23
	POBoxAddrNonDeliverableReason	POBoxAddrNonDeliverableReason	2
	POBoxDeviatingCityCode	POBoxDeviatingCityCode	5
	POBoxDeviatingCityName	POBoxDeviatingCityName	12
	POBoxDeviatingCountry	POBoxDeviatingCountry	12
	POBoxDeviatingRegion	POBoxDeviatingRegion	12
	POBoxIsWithoutNumber	POBoxIsWithoutNumber	12
	POBoxLobbyName	POBoxLobbyName	8
	POBoxPostalCode	POBoxPostalCode	19
	PostalCode	PostalCode	37
	PrfrdCommMediumType	PrfrdCommMediumType	8
	Region	Region	30
	RegionalStructureCheckStatus	RegionalStructureCheckStatus	6
	RegionalStructureGroup	RegionalStructureGroup	4
	RoomNumber	RoomNumber	10
	SecondaryRegion	CountyCode,SecondaryRegion	8
	SecondaryRegionName	County,SecondaryRegionName	12
	Street	Street	8
	StreetAddrNonDeliverableReason	StreetAddrNonDeliverableReason	2
	StreetName	StreetName	36
	StreetPrefixName1	StreetPrefixName,StreetPrefixName1	22
	StreetPrefixName2	AdditionalStreetPrefixName,StreetPrefixName2	18
	StreetSuffixName1	StreetSuffixName,StreetSuffixName1	18
	StreetSuffixName2	AdditionalStreetSuffixName,StreetSuffixName2	15
	TaxJurisdiction	TaxJurisdiction	16
	TertiaryRegion	TertiaryRegion	3
	TertiaryRegionName	TertiaryRegionName	3
	TransportZone	TransportZone	16
	VillageName	HomeCityName,VillageName	13

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Address of an Organization or a Person
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ADDRESS_2 (
    ADDRESSID,
    ADDRESSPERSONID,
    ADDRESSREPRESENTATIONCODE,
    _ADDRESSGROUP,
    _ADDRESSOBJECTTYPE,
    _ADDRESSPERSONNAME,
    _ADDRESSREPRESENTATIONCODE,
    _CORRESPONDENCELANGUAGE,
    _COUNTRY,
    _CURRENTDFLTEMAILADDRESS,
    _CURRENTDFLTFAXNUMBER,
    _CURRENTDFLTLANDLINEPHONENMBR,
    _CURRENTDFLTMOBILEPHONENUMBER,
    _DELIVERYSERVICETYPECODE,
    _EMAILADDRESS,
    _FAXNUMBER,
    _FORMOFADDRESS,
    _MAINWEBSITEURL,
    _ORGANIZATIONADDRESS,
    _PERSONADDRESS,
    _PHONENUMBER,
    _POBOXADDRNONDELIVERABLEREASON,
    _POBOXDEVIATINGCITYCODE,
    _POBOXDEVIATINGCOUNTRY,
    _POBOXDEVIATINGREGION,
    _POSTALCITY,
    _PRFRDCOMMMEDIUMTYPE,
    _REGION,
    _REGIONALSTRUCTURECHECKSTATUS,
    _SECONDARYREGION,
    _STREET,
    _STREETADDRNONDELIVERABLERSN,
    _TERTIARYREGION,
    _TIMEZONE,
    _TRANSPORTATIONZONE,
    _UNIFORMRESOURCEIDENTIFIER,
    ADDRESSCREATEDBYUSER,
    ADDRESSEEFULLNAME,
    ADDRESSGROUP,
    ADDRESSOBJECTTYPE,
    ADDRESSSEARCHTERM1,
    ADDRESSSEARCHTERM2,
    ADDRESSTIMEZONE,
    BUILDING,
    CAREOFNAME,
    CITYNAME,
    CITYNUMBER,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICTNAME,
    DISTRICTNUMBER,
    FLOOR,
    FORMOFADDRESS,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    ORGANIZATIONNAME1,
    ORGANIZATIONNAME2,
    ORGANIZATIONNAME3,
    ORGANIZATIONNAME4,
    PERSONFAMILYNAME,
    PERSONGIVENNAME,
    POBOX,
    POBOXADDRNONDELIVERABLEREASON,
    POBOXDEVIATINGCITYCODE,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    REGIONALSTRUCTURECHECKSTATUS,
    REGIONALSTRUCTUREGROUP,
    ROOMNUMBER,
    SECONDARYREGION,
    SECONDARYREGIONNAME,
    STREET,
    STREETADDRNONDELIVERABLEREASON,
    STREETNAME,
    STREETPREFIXNAME1,
    STREETPREFIXNAME2,
    STREETSUFFIXNAME1,
    STREETSUFFIXNAME2,
    TAXJURISDICTION,
    TERTIARYREGION,
    TERTIARYREGIONNAME,
    TRANSPORTZONE,
    VILLAGENAME,
    PRIMARY KEY (ADDRESSID, ADDRESSPERSONID, ADDRESSREPRESENTATIONCODE)
);

Depth:

I_ADDRESS_2

CDS Views using this table (40)

Fields (93)

Learn More