What is C_BusPartScriptedOrgAddrProcTP in SAP S/4HANA?

C_BusPartScriptedOrgAddrProcTP is a consumption CDS view in SAP S/4HANA. Organization Address Version It contains 95 fields.

Which tables does C_BusPartScriptedOrgAddrProcTP read from?

C_BusPartScriptedOrgAddrProcTP reads data from: I_BusPartScriptedOrgAddrProcTP.

What VDM layer is C_BusPartScriptedOrgAddrProcTP?

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

C_BusPartScriptedOrgAddrProcTP

DDL: C_BUSPARTSCRIPTEDORGADDRPROCTP Type: view_entity CONSUMPTION Package: MDC_BUPA_GOV_BO

95 Fields 1 Data Sources 3 Associations 3 OData Services

Organization Address Version

C_BusPartScriptedOrgAddrProcTP is a Consumption CDS View that provides data about "Organization Address Version" in SAP S/4HANA. It reads from 1 data source (I_BusPartScriptedOrgAddrProcTP) and exposes 95 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 3 associations to related views. It is exposed through 3 OData services (ASQL_F7205A, C_MDCHGPROCBPDETAILSTP_SRV, C_MDCHGPROCBPDETAILSTP_SRV). Part of development package MDC_BUPA_GOV_BO.

Data Sources (1)

Source	Alias	Join Type
I_BusPartScriptedOrgAddrProcTP	I_BusPartScriptedOrgAddrProcTP	projection

Associations (3)

Cardinality	Target	Alias	Condition
[0..*]	C_BPScrOrgAddrProcessChanges	_Changes	`$projection.MasterDataChangeProcess = _Changes.MasterDataChangeProcess and $projection.MDChgProcessStep = _Changes.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject and $projection.AddressNumber = _Changes.AddressNumber and $projection.AddressRepresentationCode = _Changes.AddressRepresentationCode and _Changes.MDChgProcessSourceModified = 'X'`
[0..1]	I_MDChangeProcessRecordTarget	_RecordTarget	`$projection.MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess and $projection.MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject and _RecordTarget.MDChgProcessSrceObjectTypeCode = '147'`
[0..1]	C_MDChgProcBusPartDetailsTP	_Details	`$projection.MasterDataChangeProcess = _Details.MasterDataChangeProcess and $projection.MDChgProcessStep = _Details.MDChgProcessStep`

Annotations (7)

Name	Value	Level
EndUserText.label	Organization Address Version	view
AccessControl.authorizationCheck	#CHECK	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#XXL	view
VDM.viewType	#CONSUMPTION	view

OData Services (3)

Service	Binding	Version	Contract	Release
ASQL_F7205A	ASQL_F7205A		C2	NOT_RELEASED
C_MDCHGPROCBPDETAILSTP_SRV	C_MDCHGPROCBPDETAILSTP_SRV	V2	C1	NOT_RELEASED
C_MDCHGPROCBPDETAILSTP_SRV	C_MDCHGPROCBPDETAILSTP_V2	V2	C1	NOT_RELEASED

Fields (95)

Key	Field	Source Table	Source Field	Description
KEY	MasterDataChangeProcess		MasterDataChangeProcess	Process ID
KEY	MDChgProcessStep		MDChgProcessStep	Step Number
KEY	MDChgProcessSrceSystem		MDChgProcessSrceSystem	Source System
KEY	MDChgProcessSrceObject		MDChgProcessSrceObject	Source ID
KEY	AddressNumber		AddressNumber	Src Address No
KEY	AddressRepresentationCode		AddressRepresentationCode	Address Version
	AddressRepresentationDesclocalized
	BusinessPartner		BusinessPartner	Issuing Authority
	StandardUsage		StandardUsage	TRUE
	BusinessPartnerAddressUUID		BusinessPartnerAddressUUID	UUID
	ValidityStartDate		ValidityStartDate	Validity Start Date
	ValidityEndDate		ValidityEndDate	ValidTo
	FormOfAddress		FormOfAddress	Title Key
	FormOfAddressNamelocalized
	BusinessPartnerName1		BusinessPartnerName1	Name
	BusinessPartnerName2		BusinessPartnerName2	Name 2
	BusinessPartnerName3		BusinessPartnerName3	Name 3
	BusinessPartnerName4		BusinessPartnerName4	Name 4
	CareOfName		CareOfName	c/o
	FullName		FullName	Name
	CityName		CityName	Name
	DistrictName		DistrictName	District
	CityNumber		CityNumber	City Code
	HomeCityName		HomeCityName	Different City
	CityFileTestStatus		CityFileTestStatus	Check Status
	PostalCode		PostalCode	Postal Code
	POBoxPostalCode		POBoxPostalCode	PO Box Postal Code
	CompanyPostalCode		CompanyPostalCode	Company Post Cd
	POBox		POBox	PO Box
	AddressPostBoxUnusable		AddressPostBoxUnusable
	POBoxIsWithoutNumber		POBoxIsWithoutNumber	PO Box w/o No.
	POBoxDeviatingCityName		POBoxDeviatingCityName	PO Box City
	POBoxDeviatingRegion		POBoxDeviatingRegion	PO Region
	POBoxDeviatingCountry		POBoxDeviatingCountry	PO Box C/R
	TransportZone		TransportZone	Transport Zone
	StreetName		StreetName	Text
	AddressStreetUnusable		AddressStreetUnusable
	HouseNumber		HouseNumber	House Number
	HouseNumberSupplementText		HouseNumberSupplementText	Supplement
	StreetPrefixName		StreetPrefixName	Street 2
	AdditionalStreetPrefixName		AdditionalStreetPrefixName	Street 3
	StreetSuffixName		StreetSuffixName	Street 4
	AdditionalStreetSuffixName		AdditionalStreetSuffixName	Street 5
	Building		Building	Building code
	Floor		Floor	Floor
	RoomNumber		RoomNumber	Room Number
	Country		Country	Venue: Ctry/Reg
	CountryNamelocalized
	CorrespondenceLanguage		CorrespondenceLanguage	Language
	Region		Region	Venue Region
	RegionNamelocalized
	SearchTerm1		SearchTerm1	Search Term 1
	SearchTerm2		SearchTerm2	Search Term 2
	PrfrdCommMediumType		PrfrdCommMediumType	Comm. Method
	PhoneNumber		PhoneNumber	Telephone no.
	AddressFaxNumber		AddressFaxNumber	Fax
	CitySearch		CitySearch
	StreetSearch		StreetSearch
	AddressTimeZone		AddressTimeZone	Time Zone
	TaxJurisdiction		TaxJurisdiction	Tax Jurisdiction
	POBoxLobbyName		POBoxLobbyName	PO Box Lobby
	DeliveryServiceTypeCode		DeliveryServiceTypeCode	Delvry Serv Type
	DeliveryServiceNumber		DeliveryServiceNumber	Delivery Service No.
	CountyCode		CountyCode	County code
	BPCountyText		BPCountyText	County
	MDChgProcessSourceModified		MDChgProcessSourceModified	Modified
	MDChgProcessSourceModifBinary		MDChgProcessSourceModifBinary
	MDChgProcSrceLastChgdDateTime		MDChgProcSrceLastChgdDateTime
	virtualAddressCountryland1
	virtualAddressRegionregio
	virtualAddressPostalCodead_pstcd1
	sstring260
	sstring260
	sstring260
	MDChgProcKPIRecordTypeText
	MDChgProcKPIRecordType	_RecordType	MDChgProcKPIRecordType
	MDChgProcKPIRecordStatusText
	MDChgProcessValidationStatus	_BusinessPartner	MDChgProcessValidationStatus
	MDChgProcKPIUpdateStatusText	_KPIUpdateStatusText	MDChangeProcKPIValueKeyDesc
	MDChgProcKPIUpdateStatus		MDChgProcKPIUpdateStatus	Row Type
	virtualMDChangeProcessMessageTypesymsgty			Message Type
	virtualMDChangeProcessMessageIDmsgid			Log Message Class
	virtualMDChangeProcessMessageNumbermsgno			Log Message Number
	MDChgProcessActivationTarget	_BusinessPartner	MDChgProcessActivationTarget
	MDChgProcKPIRecordTargetText
	MDChangeProcKPIValueKeyDesc	_StdStatus	MDChgProcStdznStatusText
	MDChgProcKPIStdznStatus		MDChgProcKPIStdznStatus	Standardization Status
	MDChgProcessReplicationStatus	_BusinessPartner	MDChgProcessReplicationStatus
	MDChgProcReplicationStatusText
	_BPProtectedAddress		_BPProtectedAddress
	_Changes		_Changes
	_RecordTarget		_RecordTarget
	_Step		_Step
	_AddrInfoMgmtOut		_AddrInfoMgmtOut
	_Details		_Details

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_BusPartScriptedOrgAddrProcTP.
-- 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_BusPartScriptedOrgAddrProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AddressNumber,
  AddressRepresentationCode,
  _AddressRepresentation._Text.AddressRepresentationDesc : localized AS AddressRepresentationDesclocalized,
  BusinessPartner,
  StandardUsage,
  BusinessPartnerAddressUUID,
  ValidityStartDate,
  ValidityEndDate,
  FormOfAddress,
  _FormOfAddress._Text.FormOfAddressName : localized AS FormOfAddressNamelocalized,
  BusinessPartnerName1,
  BusinessPartnerName2,
  BusinessPartnerName3,
  BusinessPartnerName4,
  CareOfName,
  FullName,
  CityName,
  DistrictName,
  CityNumber,
  HomeCityName,
  CityFileTestStatus,
  PostalCode,
  POBoxPostalCode,
  CompanyPostalCode,
  POBox,
  AddressPostBoxUnusable,
  POBoxIsWithoutNumber,
  POBoxDeviatingCityName,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  TransportZone,
  StreetName,
  AddressStreetUnusable,
  HouseNumber,
  HouseNumberSupplementText,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  StreetSuffixName,
  AdditionalStreetSuffixName,
  Building,
  Floor,
  RoomNumber,
  Country,
  _Country._Text.CountryName : localized AS CountryNamelocalized,
  CorrespondenceLanguage,
  Region,
  _Region._RegionText.RegionName : localized AS RegionNamelocalized,
  SearchTerm1,
  SearchTerm2,
  PrfrdCommMediumType,
  PhoneNumber,
  AddressFaxNumber,
  CitySearch,
  StreetSearch,
  AddressTimeZone,
  TaxJurisdiction,
  POBoxLobbyName,
  DeliveryServiceTypeCode,
  DeliveryServiceNumber,
  CountyCode,
  BPCountyText,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcSrceLastChgdDateTime,
  virtual AddressCountry : land1 AS virtualAddressCountryland1,
  virtual AddressRegion : regio AS virtualAddressRegionregio,
  virtual AddressPostalCode : ad_pstcd1 AS virtualAddressPostalCodead_pstcd1,
  virtual SourceSystem : abap.sstring( 260 ) AS sstring260,
  _RecordType._KPIRecordTypeText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTypeText,
  _RecordType.MDChgProcKPIRecordType AS MDChgProcKPIRecordType,
  _BusinessPartner._KPIRecordStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordStatusText,
  _BusinessPartner.MDChgProcessValidationStatus AS MDChgProcessValidationStatus,
  _KPIUpdateStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIUpdateStatusText,
  MDChgProcKPIUpdateStatus,
  virtual MDChangeProcessMessageType : symsgty AS virtualMDChangeProcessMessageTypesymsgty,
  virtual MDChangeProcessMessageID : msgid AS virtualMDChangeProcessMessageIDmsgid,
  virtual MDChangeProcessMessageNumber : msgno AS virtualMDChangeProcessMessageNumbermsgno,
  _BusinessPartner.MDChgProcessActivationTarget AS MDChgProcessActivationTarget,
  _BusinessPartner._RecordTargetText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTargetText,
  _StdStatus.MDChgProcStdznStatusText AS MDChangeProcKPIValueKeyDesc,
  MDChgProcKPIStdznStatus,
  _BusinessPartner.MDChgProcessReplicationStatus AS MDChgProcessReplicationStatus,
  _BusinessPartner._ReplicationStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcReplicationStatusText
FROM I_BusPartScriptedOrgAddrProcTP
LEFT OUTER JOIN C_BPScrOrgAddrProcessChanges AS _Changes ON MasterDataChangeProcess = _Changes.MasterDataChangeProcess AND MDChgProcessStep = _Changes.MDChgProcessStep AND MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject AND AddressNumber = _Changes.AddressNumber AND AddressRepresentationCode = _Changes.AddressRepresentationCode AND _Changes.MDChgProcessSourceModified = 'X'  -- association [0..*]
LEFT OUTER JOIN I_MDChangeProcessRecordTarget AS _RecordTarget ON MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess AND MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject AND _RecordTarget.MDChgProcessSrceObjectTypeCode = '147'  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcBusPartDetailsTP AS _Details ON MasterDataChangeProcess = _Details.MasterDataChangeProcess AND MDChgProcessStep = _Details.MDChgProcessStep  -- association [0..1]
;

Depth:

C_BusPartScriptedOrgAddrProcTP view_entity

I_BusPartScriptedOrgAddrProcTP view_entity