What is R_BusinessPartnerAddressDraft in SAP S/4HANA?

R_BusinessPartnerAddressDraft is a basic CDS view in SAP S/4HANA. Business Partner Address-Draft It contains 71 fields.

Which tables does R_BusinessPartnerAddressDraft read from?

R_BusinessPartnerAddressDraft reads data from: bupa_adrc_d_2.

What VDM layer is R_BusinessPartnerAddressDraft?

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

R_BusinessPartnerAddressDraft

DDL: R_BUSINESSPARTNERADDRESSDRAFT Type: view_entity BASIC

71 Fields 1 Data Sources

Business Partner Address-Draft

R_BusinessPartnerAddressDraft is a Basic CDS View that provides data about "Business Partner Address-Draft" in SAP S/4HANA. It reads from 1 data source (bupa_adrc_d_2) and exposes 71 fields with key fields BusinessPartner, AddressNumber, DraftUUID.

Data Sources (1)

Source	Alias	Join Type
bupa_adrc_d_2	bupa_adrc_d_2	from

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Business Partner Address-Draft	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view

Fields (71)

Key	Field	Source Field	Description
KEY	BusinessPartner	businesspartner	Issuing Authority
KEY	AddressNumber	addressnumber	Src Address No
KEY	DraftUUID	draftuuid	UUID
	ParentDraftUUID	parentdraftuuid	NodeID
	AddressIDForEdit	addressidforedit	Address Number
	BusinessPartnerAddressUUID	businesspartneraddressuuid	UUID
	ValidityStartDate	validitystartdate	Validity Start Date
	ValidityEndDate	validityenddate	ValidTo
	CareOfName	careofname	c/o
	StreetPrefixName	streetprefixname	Street 2
	AdditionalStreetPrefixName	additionalstreetprefixname	Street 3
	HouseNumber	housenumber	House Number
	StreetName	streetname	Text
	HouseNumberSupplementText	housenumbersupplementtext	Supplement
	StreetSuffixName	streetsuffixname	Street 4
	AdditionalStreetSuffixName	additionalstreetsuffixname	Street 5
	HomeCityName	homecityname	Different City
	District	district	District Court
	DistrictName	districtname	District
	PostalCode	postalcode	Postal Code
	CityName	cityname	Name
	Country	country	Venue: Ctry/Reg
	Region	region	Venue Region
	AddressTimeZone	addresstimezone	Time Zone
	TransportZone	transportzone	Transport Zone
	TaxJurisdiction	taxjurisdiction	Tax Jurisdiction
	CompanyPostalCode	companypostalcode	Company Post Cd
	DeliveryServiceTypeCode	deliveryservicetypecode	Delvry Serv Type
	DeliveryServiceNumber	deliveryservicenumber	Delivery Service No.
	POBox	pobox	PO Box
	POBoxIsWithoutNumber	poboxiswithoutnumber	PO Box w/o No.
	POBoxPostalCode	poboxpostalcode	PO Box Postal Code
	POBoxLobbyName	poboxlobbyname	PO Box Lobby
	POBoxDeviatingCityName	poboxdeviatingcityname	PO Box City
	POBoxDeviatingRegion	poboxdeviatingregion	PO Region
	POBoxDeviatingCountry	poboxdeviatingcountry	PO Box C/R
	CorrespondenceLanguage	correspondencelanguage	Language
	PrfrdCommMediumType	prfrdcommmediumtype	Comm. Method
	AddressNonDeliverableReason	addressnondeliverablereason	Undeliverable
	PostBoxNonDeliverableReason	postboxnondeliverablereason	Undeliverable
	Building	building	Building code
	Floor	floor	Floor
	RoomNumber	roomnumber	Room Number
	County	county	Wyoming County
	BPCountyText	bpcountytext	County
	AddressLine1Text	addressline1text	Address line
	AddressLine2Text	addressline2text	E-Mail Address
	FormattedAddress	formattedaddress
	CompleteAddress	completeaddress
	BPAddressIsProtected	bpaddressisprotected	Sensitivity
	StandardUsage	standardusage	TRUE
	AuthorizationGroup	authorizationgroup	AuthorizGroup
	BPHasActiveEntity	bphasactiveentity	Is active
	IsBusinessPurposeCompleted	isbusinesspurposecompleted	Purpose Completed
	DraftEntityCreationDateTime	draftentitycreationdatetime	Draft Created On
	DraftEntityLastChangeDateTime	draftentitylastchangedatetime	Draft Last Changed On
	DraftAdministrativeDataUUID	draftadministrativedatauuid	UUID
	DraftEntityOperationCode	draftentityoperationcode	Draft - Operation Code
	DataControllerSet	datacontrollerset	Data Ctrlr. Set
	DataController1	datacontroller1	Data Controller
	DataController2	datacontroller2	Data Controller
	DataController3	datacontroller3	Data Controller
	DataController4	datacontroller4	Data Controller
	DataController5	datacontroller5	Data Controller
	DataController6	datacontroller6	Data Controller
	DataController7	datacontroller7	Data Controller
	DataController8	datacontroller8	Data Controller
	DataController9	datacontroller9	Data Controller
	DataController10	datacontroller10	Data Controller
	HasActiveEntity	hasactiveentity	TRUE
	DraftFieldChanges	draftfieldchanges	Field Changes

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 R_BusinessPartnerAddressDraft.
-- 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.

CREATE VIEW R_BusinessPartnerAddressDraft AS
SELECT
  BusinessPartner,
  AddressNumber,
  DraftUUID,
  ParentDraftUUID,
  AddressIDForEdit,
  BusinessPartnerAddressUUID,
  ValidityStartDate,
  ValidityEndDate,
  CareOfName,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  HouseNumber,
  StreetName,
  HouseNumberSupplementText,
  StreetSuffixName,
  AdditionalStreetSuffixName,
  HomeCityName,
  District,
  DistrictName,
  PostalCode,
  CityName,
  Country,
  Region,
  AddressTimeZone,
  TransportZone,
  TaxJurisdiction,
  CompanyPostalCode,
  DeliveryServiceTypeCode,
  DeliveryServiceNumber,
  POBox,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  POBoxLobbyName,
  POBoxDeviatingCityName,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  CorrespondenceLanguage,
  PrfrdCommMediumType,
  AddressNonDeliverableReason,
  PostBoxNonDeliverableReason,
  Building,
  Floor,
  RoomNumber,
  County,
  BPCountyText,
  AddressLine1Text,
  AddressLine2Text,
  FormattedAddress,
  CompleteAddress,
  BPAddressIsProtected,
  StandardUsage,
  AuthorizationGroup,
  BPHasActiveEntity,
  IsBusinessPurposeCompleted,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10,
  HasActiveEntity,
  DraftFieldChanges
FROM bupa_adrc_d_2
;

Depth:

R_BusinessPartnerAddressDraft view_entity

bupa_adrc_d_2