What is C_BusPartScriptedPersAddrGovTP in SAP S/4HANA?

C_BusPartScriptedPersAddrGovTP is a consumption CDS view in SAP S/4HANA. Projection for IBusPartScriptedPersAddrGovTP It contains 76 fields.

Which tables does C_BusPartScriptedPersAddrGovTP read from?

C_BusPartScriptedPersAddrGovTP reads data from: I_BusPartScriptedPersAddrGovTP.

What VDM layer is C_BusPartScriptedPersAddrGovTP?

C_BusPartScriptedPersAddrGovTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_BusPartScriptedPersAddrGovTP

DDL: C_BUSPARTSCRIPTEDPERSADDRGOVTP Type: view_entity CONSUMPTION

76 Fields 1 Data Sources

Projection for IBusPartScriptedPersAddrGovTP

C_BusPartScriptedPersAddrGovTP is a Consumption CDS View that provides data about "Projection for IBusPartScriptedPersAddrGovTP" in SAP S/4HANA. It reads from 1 data source (I_BusPartScriptedPersAddrGovTP) and exposes 76 fields with key fields BusinessPartnerUUID, BusinessPartnerAddressUUID, BPScriptedPersnAddrDrftUUID, MasterDataChangeProcess, MDChgProcessSrceSystem.

Data Sources (1)

Source	Alias	Join Type
I_BusPartScriptedPersAddrGovTP	I_BusPartScriptedPersAddrGovTP	projection

Annotations (8)

Name	Value	Level
EndUserText.label	Projection for IBusPartScriptedPersAddrGovTP	view
AccessControl.authorizationCheck	#CHECK	view
Metadata.allowExtensions	true	view
Search.searchable	true	view
ObjectModel.usageType.serviceQuality	#C	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#XXL	view

Fields (76)

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
	AddressRepresentationDesclocalized
	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
	CityFileTestStatusNamelocalized
	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
	FormOfAddressNamelocalized
	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
	sstring260
	_BPProtectedAddress	_BPProtectedAddress

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 C_BusPartScriptedPersAddrGovTP.
-- 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 C_BusPartScriptedPersAddrGovTP AS
SELECT
  BusinessPartnerUUID,
  BusinessPartnerAddressUUID,
  BPScriptedPersnAddrDrftUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AddressNumber,
  AddressRepresentationCode,
  AddrRepresentationCodeForEdit,
  _AddressRepresentation._Text.AddressRepresentationDesc : localized AS AddressRepresentationDesclocalized,
  MDChgProcessStep,
  ValidityStartDate,
  ValidityEndDate,
  CareOfName,
  AdditionalStreetSuffixName,
  CorrespondenceLanguage,
  PrfrdCommMediumType,
  POBox,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  POBoxLobbyName,
  POBoxDeviatingCityName,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  DeliveryServiceTypeCode,
  DeliveryServiceNumber,
  AddressTimeZone,
  CityFileTestStatus,
  _CheckStatusText.CityFileTestStatusName : localized AS CityFileTestStatusNamelocalized,
  AddressNonDeliverableReason,
  PostBoxNonDeliverableReason,
  FullName,
  CityName,
  DistrictName,
  HomeCityName,
  PostalCode,
  CompanyPostalCode,
  StreetName,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  StreetSuffixName,
  HouseNumber,
  HouseNumberSupplementText,
  Building,
  Floor,
  RoomNumber,
  Country,
  Region,
  BPCountyText,
  TaxJurisdiction,
  TransportZone,
  Person,
  FormOfAddress,
  _FormOfAddress._Text.FormOfAddressName : localized AS FormOfAddressNamelocalized,
  SearchTerm1,
  SearchTerm2,
  FirstName,
  LastName,
  BusinessPartnerBirthName,
  MiddleName,
  AdditionalLastName,
  PersonFullName,
  AcademicTitle,
  AcademicTitle2,
  LastNamePrefix,
  LastNameSecondPrefix,
  BusinessPartnerSupplementName,
  BusinessPartnerNicknameLabel,
  Initials,
  NameFormat,
  NameCountry,
  BPFirstNameSearchHelp,
  BPLastNameSearchHelp,
  MasterDataIsCurrent,
  virtual FormattedAddress : abap.sstring( 260 ) AS sstring260
FROM I_BusPartScriptedPersAddrGovTP
;

Depth:

C_BusPartScriptedPersAddrGovTP view_entity

I_BusPartScriptedPersAddrGovTP view_entity