What is R_BPScriptedPersAddrGovDraft in SAP S/4HANA?

R_BPScriptedPersAddrGovDraft is a basic CDS view in SAP S/4HANA. Draft Access Person Address Version It contains 77 fields.

Which tables does R_BPScriptedPersAddrGovDraft read from?

R_BPScriptedPersAddrGovDraft reads data from: but020scrper_dft.

What VDM layer is R_BPScriptedPersAddrGovDraft?

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

R_BPScriptedPersAddrGovDraft

DDL: R_BPSCRIPTEDPERSADDRGOVDRAFT Type: view_entity BASIC

77 Fields 1 Data Sources

Draft Access Person Address Version

R_BPScriptedPersAddrGovDraft is a Basic CDS View that provides data about "Draft Access Person Address Version" in SAP S/4HANA. It reads from 1 data source (but020scrper_dft) and exposes 77 fields with key fields BusinessPartnerUUID, BusinessPartnerAddressUUID, BPScriptedPersnAddrDrftUUID, MasterDataChangeProcess, MDChgProcessSrceSystem.

Data Sources (1)

Source	Alias	Join Type
but020scrper_dft	but020scrper_dft	from

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Draft Access Person Address Version	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 (77)

Key	Field	Source Field	Description
KEY	BusinessPartnerUUID	businesspartneruuid	UUID
KEY	BusinessPartnerAddressUUID	businesspartneraddressuuid	UUID
KEY	BPScriptedPersnAddrDrftUUID	bpscriptedpersnaddrdrftuuid	UUID
KEY	MasterDataChangeProcess	masterdatachangeprocess	Process ID
KEY	MDChgProcessSrceSystem	mdchgprocesssrcesystem	Source System
KEY	MDChgProcessSrceObject	mdchgprocesssrceobject	Source ID
KEY	AddressNumber	addressnumber	Src Address No
KEY	AddressRepresentationCode	addressrepresentationcode	Address Version
	AddrRepresentationCodeForEdit	addrrepresentationcodeforedit	Address Version
	MDChgProcessStep	mdchgprocessstep	Step Number
	ValidityStartDate	validitystartdate	Validity Start Date
	ValidityEndDate	validityenddate	ValidTo
	CareOfName	careofname	c/o
	AdditionalStreetSuffixName	additionalstreetsuffixname	Street 5
	CorrespondenceLanguage	correspondencelanguage	Language
	PrfrdCommMediumType	prfrdcommmediumtype	Comm. Method
	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
	DeliveryServiceTypeCode	deliveryservicetypecode	Delvry Serv Type
	DeliveryServiceNumber	deliveryservicenumber	Delivery Service No.
	AddressTimeZone	addresstimezone	Time Zone
	CityFileTestStatus	cityfileteststatus	Check Status
	AddressNonDeliverableReason	addressnondeliverablereason	Undeliverable
	PostBoxNonDeliverableReason	postboxnondeliverablereason	Undeliverable
	FullName	fullname	Name
	CityName	cityname	Name
	DistrictName	districtname	District
	HomeCityName	homecityname	Different City
	PostalCode	postalcode	Postal Code
	CompanyPostalCode	companypostalcode	Company Post Cd
	StreetName	streetname	Text
	StreetPrefixName	streetprefixname	Street 2
	AdditionalStreetPrefixName	additionalstreetprefixname	Street 3
	StreetSuffixName	streetsuffixname	Street 4
	HouseNumber	housenumber	House Number
	HouseNumberSupplementText	housenumbersupplementtext	Supplement
	Building	building	Building code
	Floor	floor	Floor
	RoomNumber	roomnumber	Room Number
	Country	country	Venue: Ctry/Reg
	Region	region	Venue Region
	BPCountyText	bpcountytext	County
	TaxJurisdiction	taxjurisdiction	Tax Jurisdiction
	TransportZone	transportzone	Transport Zone
	Person	person	Person/ Farm/ Field
	FormOfAddress	formofaddress	Title Key
	SearchTerm1	searchterm1	Search Term 1
	SearchTerm2	searchterm2	Search Term 2
	FirstName	firstname	First Name
	LastName	lastname	Last Name
	BusinessPartnerBirthName	businesspartnerbirthname	Name at Birth
	MiddleName	middlename	Middle Name
	AdditionalLastName	additionallastname	Other Last Name
	PersonFullName	personfullname	Full Name
	AcademicTitle	academictitle	Academic Title
	AcademicTitle2	academictitle2	2nd Academic
	LastNamePrefix	lastnameprefix	Prefix Key
	LastNameSecondPrefix	lastnamesecondprefix	2nd prefix
	BusinessPartnerSupplementName	businesspartnersupplementname	Name Supplement
	BusinessPartnerNicknameLabel	businesspartnernicknamelabel	Nickname
	Initials	initials	Initials
	NameFormat	nameformat	Name Format
	NameCountry	namecountry	Country/Region
	BPFirstNameSearchHelp	bpfirstnamesearchhelp	Name2/First Nme
	BPLastNameSearchHelp	bplastnamesearchhelp	Name 1/Last Nme
	MasterDataIsCurrent	masterdataiscurrent	Truth Value
	DraftEntityCreationDateTime	draftentitycreationdatetime	Draft Created On
	DraftEntityLastChangeDateTime	draftentitylastchangedatetime	Draft Last Changed On
	DraftAdministrativeDataUUID	draftadministrativedatauuid	UUID
	DraftEntityOperationCode	draftentityoperationcode	Draft - Operation Code
	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_BPScriptedPersAddrGovDraft.
-- 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_BPScriptedPersAddrGovDraft AS
SELECT
  BusinessPartnerUUID,
  BusinessPartnerAddressUUID,
  BPScriptedPersnAddrDrftUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AddressNumber,
  AddressRepresentationCode,
  AddrRepresentationCodeForEdit,
  MDChgProcessStep,
  ValidityStartDate,
  ValidityEndDate,
  CareOfName,
  AdditionalStreetSuffixName,
  CorrespondenceLanguage,
  PrfrdCommMediumType,
  POBox,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  POBoxLobbyName,
  POBoxDeviatingCityName,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  DeliveryServiceTypeCode,
  DeliveryServiceNumber,
  AddressTimeZone,
  CityFileTestStatus,
  AddressNonDeliverableReason,
  PostBoxNonDeliverableReason,
  FullName,
  CityName,
  DistrictName,
  HomeCityName,
  PostalCode,
  CompanyPostalCode,
  StreetName,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  StreetSuffixName,
  HouseNumber,
  HouseNumberSupplementText,
  Building,
  Floor,
  RoomNumber,
  Country,
  Region,
  BPCountyText,
  TaxJurisdiction,
  TransportZone,
  Person,
  FormOfAddress,
  SearchTerm1,
  SearchTerm2,
  FirstName,
  LastName,
  BusinessPartnerBirthName,
  MiddleName,
  AdditionalLastName,
  PersonFullName,
  AcademicTitle,
  AcademicTitle2,
  LastNamePrefix,
  LastNameSecondPrefix,
  BusinessPartnerSupplementName,
  BusinessPartnerNicknameLabel,
  Initials,
  NameFormat,
  NameCountry,
  BPFirstNameSearchHelp,
  BPLastNameSearchHelp,
  MasterDataIsCurrent,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM but020scrper_dft
;

Depth:

R_BPScriptedPersAddrGovDraft view_entity

but020scrper_dft