What is R_BPScriptedGroupAddDraft in SAP S/4HANA?

R_BPScriptedGroupAddDraft is a basic CDS view in SAP S/4HANA. BP Scripted Group Address-Draft It contains 72 fields.

Which tables does R_BPScriptedGroupAddDraft read from?

R_BPScriptedGroupAddDraft reads data from: bupa_grp_addr_d.

What VDM layer is R_BPScriptedGroupAddDraft?

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

R_BPScriptedGroupAddDraft

DDL: R_BPSCRIPTEDGROUPADDDRAFT Type: view_entity BASIC

72 Fields 1 Data Sources

BP Scripted Group Address-Draft

R_BPScriptedGroupAddDraft is a Basic CDS View that provides data about "BP Scripted Group Address-Draft" in SAP S/4HANA. It reads from 1 data source (bupa_grp_addr_d) and exposes 72 fields with key fields BusinessPartner, AddressNumber, AddressRepresentationCode, DraftUUID.

Data Sources (1)

Source	Alias	Join Type
bupa_grp_addr_d	bupa_grp_addr_d	from

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	BP Scripted Group 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 (72)

Key	Field	Source Field	Description
KEY	BusinessPartner	businesspartner	Issuing Authority
KEY	AddressNumber	addressnumber	Src Address No
KEY	AddressRepresentationCode	addressrepresentationcode	Address Version
KEY	DraftUUID	draftuuid	UUID
	ParentDraftUUID	parentdraftuuid	NodeID
	AddrRepCodeForEditValue	addrrepcodeforeditvalue	Address Version
	ValidityStartDate	validitystartdate	Validity Start Date
	ValidityEndDate	validityenddate	ValidTo
	BusinessPartnerAddressUUID	businesspartneraddressuuid	UUID
	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
	FullName	fullname	Name
	CityName	cityname	Name
	District	district	District Court
	DistrictName	district	District Court
	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
	County	county	Wyoming County
	BPCountyText	county	Wyoming County
	FormattedAddress	formattedaddress
	BusinessPartnerName1	businesspartnername1	Name
	BusinessPartnerName2	businesspartnername2	Name 2
	TaxJurisdiction	taxjurisdiction	Tax Jurisdiction
	TransportZone	transportzone	Transport Zone
	FormOfAddress	formofaddress	Title Key
	SearchTerm1	searchterm1	Search Term 1
	SearchTerm2	searchterm2	Search Term 2
	AuthorizationGroup	authorizationgroup	AuthorizGroup
	IsBusinessPurposeCompleted	isbusinesspurposecompleted	Purpose Completed
	BPAddressIsProtected	bpaddressisprotected	Sensitivity
	BusinessPartnerDraftUUID	businesspartnerdraftuuid	Draft Document ID
	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_BPScriptedGroupAddDraft.
-- 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_BPScriptedGroupAddDraft AS
SELECT
  BusinessPartner,
  AddressNumber,
  AddressRepresentationCode,
  DraftUUID,
  ParentDraftUUID,
  AddrRepCodeForEditValue,
  ValidityStartDate,
  ValidityEndDate,
  BusinessPartnerAddressUUID,
  CareOfName,
  AdditionalStreetSuffixName,
  CorrespondenceLanguage,
  PrfrdCommMediumType,
  POBox,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  POBoxLobbyName,
  POBoxDeviatingCityName,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  DeliveryServiceTypeCode,
  DeliveryServiceNumber,
  AddressTimeZone,
  FullName,
  CityName,
  District,
  district AS DistrictName,
  HomeCityName,
  PostalCode,
  CompanyPostalCode,
  StreetName,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  StreetSuffixName,
  HouseNumber,
  HouseNumberSupplementText,
  Building,
  Floor,
  RoomNumber,
  Country,
  Region,
  County,
  county AS BPCountyText,
  FormattedAddress,
  BusinessPartnerName1,
  BusinessPartnerName2,
  TaxJurisdiction,
  TransportZone,
  FormOfAddress,
  SearchTerm1,
  SearchTerm2,
  AuthorizationGroup,
  IsBusinessPurposeCompleted,
  BPAddressIsProtected,
  BusinessPartnerDraftUUID,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10,
  HasActiveEntity,
  DraftFieldChanges
FROM bupa_grp_addr_d
;

Depth:

R_BPScriptedGroupAddDraft view_entity

bupa_grp_addr_d