Which tables does P_FrcElmntOrgBusinessAddress read from?

P_FrcElmntOrgBusinessAddress reads data from: adrc.

What VDM layer is P_FrcElmntOrgBusinessAddress?

P_FrcElmntOrgBusinessAddress is classified as a Basic (interface) view providing a 1:1 representation of a database table.

P_FrcElmntOrgBusinessAddress

Q: What is P_FrcElmntOrgBusinessAddress in SAP S/4HANA?

P_FrcElmntOrgBusinessAddress is a basic CDS view in SAP S/4HANA. It contains 51 fields.

DDL: P_FRCELMNTORGBUSINESSADDRESS SQL: PFEORGBUSADDR Type: view BASIC

51 Fields 1 Data Sources

P_FrcElmntOrgBusinessAddress is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (adrc) and exposes 51 fields with key fields AddressNumber, FrcElmntOrgAddrFromDate, Nation.

Data Sources (1)

Source	Alias	Join Type
adrc	FrcElmntOrgBusinessAddress	from

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	PFEORGBUSADDR	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#BASIC	view
VDM.private	true	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view

Fields (51)

Key	Field	Source Table	Source Field	Description
KEY	AddressNumber	adrc	addrnumber	Address Number
KEY	FrcElmntOrgAddrFromDate	adrc	date_from	Validity Start Date
KEY	Nation	adrc	nation	Country/Region
	FrcElmntOrgAddrToDate	adrc	date_to	Validity End Date
	FrcElmntOrgAddrTitle	adrc	title	View Title
	FrcElmntOrgAddrName1	adrc	name1	PA text
	FrcElmntOrgAddrName2	adrc	name2	Name2/First nme
	FrcElmntOrgAddrName3	adrc	name3	Name 3
	FrcElmntOrgAddrName4	adrc	name4	Name 4
	FrcElmntOrgAddrCareOfName	adrc	name_co	c/o
	CityName	adrc	city1	City
	FrcElmntOrgAddrDistrict	adrc	city2	District
	HomeCityName	adrc	home_city	Different City
	RegionalStructureGrouping	adrc	regiogroup	Structure Group
	PostalCode	adrc	post_code1	Postal Code
	FrcElmntOrgAddrPOBoxPostalCode	adrc	post_code2	PO Box Post Cde
	CompanyPostalCode	adrc	post_code3	Company Post Cd
	POBox	adrc	po_box	PO Box
	FrcElmntOrgPOBoxNonDelivRsn	adrc	dont_use_p	Undeliverable
	FrcElmntOrgIsPOBoxWthoutNmbr	adrc	po_box_num	PO Box w/o No.
	FrcElmntOrgAddrPOBoxCityName	adrc	po_box_loc	PO Box City
	FrcElmntOrgAddrPOBoxRegion	adrc	po_box_reg	PO Region
	FrcElmntOrgAddrPOBoxCountry	adrc	po_box_cty	PO Box C/R
	TransportZone	adrc	transpzone	Transport Zone
	StreetName	adrc	street	Street Code
	FrcElmntOrgAddrNonDelivReason	adrc	dont_use_s	Undeliverable
	HouseNumber	adrc	house_num1	House Number
	FrcElmntOrgHsNmbrSuplmntText	adrc	house_num2	Supplement
	FrcElmntOrgAddrStreetName2	adrc	str_suppl1	Street 2
	FrcElmntOrgAddrStreetName3	adrc	str_suppl2	Street 3
	FrcElmntOrgAddrStreetName4	adrc	str_suppl3	Street 4
	FrcElmntOrgAddrLocationName	adrc	location	Text
	Building	adrc	building	Building code
	Floor	adrc	floor	Floor
	RoomNumber	adrc	roomnumber	Room Number
	CountryCode	adrc	country	Venue: Ctry/Reg
	LanguageCode	adrc	langu	Primary lang.
	Region	adrc	region	Venue Region
	AddressSearchText1	adrc	sort1	Sort string 1
	AddressSearchText2	adrc	sort2	Sort string 2
	CommunicationMediumType	adrc	deflt_comm	Comm. Method
	FrcElmntOrgAddrTelephoneNumber	adrc	tel_number	Telephone
	FrcElmntOrgAddrTelExtension	adrc	tel_extens	Extension
	AddressFaxNumber	adrc	fax_number	Fax Number
	FrcElmntOrgAddrFaxNumberExtn	adrc	fax_extens	Extension
	AddressTimeZone	adrc	time_zone	TimeZone
	FrcElmntOrgAddrTaxJurisdiction	adrc	taxjurcode	Tax Jurisdiction
	FrcElmntOrgAddrPOBoxLobbyName	adrc	po_box_lobby	PO Box Lobby
	DeliveryServiceTypeCode	adrc	deli_serv_type	Delvry Serv Type
	FrcElmntOrgAddrDelivSrvcNumber	adrc	deli_serv_number	Delivery Service No.
	AddressGroup	adrc	addr_group	Address group

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 P_FrcElmntOrgBusinessAddress.
-- 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: PFEORGBUSADDR

CREATE VIEW P_FrcElmntOrgBusinessAddress AS
SELECT
  FrcElmntOrgBusinessAddress.addrnumber AS AddressNumber,
  FrcElmntOrgBusinessAddress.date_from AS FrcElmntOrgAddrFromDate,
  FrcElmntOrgBusinessAddress.nation AS Nation,
  FrcElmntOrgBusinessAddress.date_to AS FrcElmntOrgAddrToDate,
  FrcElmntOrgBusinessAddress.title AS FrcElmntOrgAddrTitle,
  FrcElmntOrgBusinessAddress.name1 AS FrcElmntOrgAddrName1,
  FrcElmntOrgBusinessAddress.name2 AS FrcElmntOrgAddrName2,
  FrcElmntOrgBusinessAddress.name3 AS FrcElmntOrgAddrName3,
  FrcElmntOrgBusinessAddress.name4 AS FrcElmntOrgAddrName4,
  FrcElmntOrgBusinessAddress.name_co AS FrcElmntOrgAddrCareOfName,
  FrcElmntOrgBusinessAddress.city1 AS CityName,
  FrcElmntOrgBusinessAddress.city2 AS FrcElmntOrgAddrDistrict,
  FrcElmntOrgBusinessAddress.home_city AS HomeCityName,
  FrcElmntOrgBusinessAddress.regiogroup AS RegionalStructureGrouping,
  FrcElmntOrgBusinessAddress.post_code1 AS PostalCode,
  FrcElmntOrgBusinessAddress.post_code2 AS FrcElmntOrgAddrPOBoxPostalCode,
  FrcElmntOrgBusinessAddress.post_code3 AS CompanyPostalCode,
  FrcElmntOrgBusinessAddress.po_box AS POBox,
  FrcElmntOrgBusinessAddress.dont_use_p AS FrcElmntOrgPOBoxNonDelivRsn,
  FrcElmntOrgBusinessAddress.po_box_num AS FrcElmntOrgIsPOBoxWthoutNmbr,
  FrcElmntOrgBusinessAddress.po_box_loc AS FrcElmntOrgAddrPOBoxCityName,
  FrcElmntOrgBusinessAddress.po_box_reg AS FrcElmntOrgAddrPOBoxRegion,
  FrcElmntOrgBusinessAddress.po_box_cty AS FrcElmntOrgAddrPOBoxCountry,
  FrcElmntOrgBusinessAddress.transpzone AS TransportZone,
  FrcElmntOrgBusinessAddress.street AS StreetName,
  FrcElmntOrgBusinessAddress.dont_use_s AS FrcElmntOrgAddrNonDelivReason,
  FrcElmntOrgBusinessAddress.house_num1 AS HouseNumber,
  FrcElmntOrgBusinessAddress.house_num2 AS FrcElmntOrgHsNmbrSuplmntText,
  FrcElmntOrgBusinessAddress.str_suppl1 AS FrcElmntOrgAddrStreetName2,
  FrcElmntOrgBusinessAddress.str_suppl2 AS FrcElmntOrgAddrStreetName3,
  FrcElmntOrgBusinessAddress.str_suppl3 AS FrcElmntOrgAddrStreetName4,
  FrcElmntOrgBusinessAddress.location AS FrcElmntOrgAddrLocationName,
  FrcElmntOrgBusinessAddress.building AS Building,
  FrcElmntOrgBusinessAddress.floor AS Floor,
  FrcElmntOrgBusinessAddress.roomnumber AS RoomNumber,
  FrcElmntOrgBusinessAddress.country AS CountryCode,
  FrcElmntOrgBusinessAddress.langu AS LanguageCode,
  FrcElmntOrgBusinessAddress.region AS Region,
  FrcElmntOrgBusinessAddress.sort1 AS AddressSearchText1,
  FrcElmntOrgBusinessAddress.sort2 AS AddressSearchText2,
  FrcElmntOrgBusinessAddress.deflt_comm AS CommunicationMediumType,
  FrcElmntOrgBusinessAddress.tel_number AS FrcElmntOrgAddrTelephoneNumber,
  FrcElmntOrgBusinessAddress.tel_extens AS FrcElmntOrgAddrTelExtension,
  FrcElmntOrgBusinessAddress.fax_number AS AddressFaxNumber,
  FrcElmntOrgBusinessAddress.fax_extens AS FrcElmntOrgAddrFaxNumberExtn,
  FrcElmntOrgBusinessAddress.time_zone AS AddressTimeZone,
  FrcElmntOrgBusinessAddress.taxjurcode AS FrcElmntOrgAddrTaxJurisdiction,
  FrcElmntOrgBusinessAddress.po_box_lobby AS FrcElmntOrgAddrPOBoxLobbyName,
  FrcElmntOrgBusinessAddress.deli_serv_type AS DeliveryServiceTypeCode,
  FrcElmntOrgBusinessAddress.deli_serv_number AS FrcElmntOrgAddrDelivSrvcNumber,
  FrcElmntOrgBusinessAddress.addr_group AS AddressGroup
FROM adrc AS FrcElmntOrgBusinessAddress
;

Depth:

P_FrcElmntOrgBusinessAddress view

adrc

I_FrcElmntOrgBusinessAddress view