What is R_BusinessPartnerGovDraft in SAP S/4HANA?

R_BusinessPartnerGovDraft is a cds CDS view in SAP S/4HANA. Draft query view for BUT000_DFT It contains 112 fields.

Which tables does R_BusinessPartnerGovDraft read from?

R_BusinessPartnerGovDraft reads data from: but000_dft.

R_BusinessPartnerGovDraft

DDL: R_BUSINESSPARTNERGOVDRAFT Type: view_entity Package: MDC_BUPA_GOV_BO

112 Fields 1 Data Sources

Draft query view for BUT000_DFT

R_BusinessPartnerGovDraft is a CDS View that provides data about "Draft query view for BUT000_DFT" in SAP S/4HANA. It reads from 1 data source (but000_dft) and exposes 112 fields with key fields BusinessPartnerUUID, MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject. Part of development package MDC_BUPA_GOV_BO.

Data Sources (1)

Source	Alias	Join Type
but000_dft	but000_dft	from

Annotations (3)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
Metadata.allowExtensions	true	view
EndUserText.label	Draft query view for BUT000_DFT	view

Fields (112)

Key	Field	Source Field	Description
KEY	BusinessPartnerUUID	businesspartneruuid	UUID
KEY	MasterDataChangeProcess	masterdatachangeprocess	Process ID
KEY	MDChgProcessSrceSystem	mdchgprocesssrcesystem	Source System
KEY	MDChgProcessSrceObject	mdchgprocesssrceobject	Source ID
	MDChgProcessStep	mdchgprocessstep	Step Number
	MasterDataChangeProcessForEdit	masterdatachangeprocessforedit	Process ID
	MDChangeProcessNumberDisplay	mdchangeprocessnumberdisplay	Process ID
	MDChgProcessSrceObjectTypeCode	mdchgprocesssrceobjecttypecode	Bus. Obj. Type
	MDChgProcessGoal	mdchgprocessgoal	Process Goal
	BusinessPartner	businesspartner	Issuing Authority
	BusinessPartnerCategory	businesspartnercategory	Partner Cat.
	AuthorizationGroup	authorizationgroup	AuthorizGroup
	PersonNumber	personnumber	Person Number
	ETag	etag	Update Token
	MDChgProcessIsStarted	mdchgprocessisstarted	Process Started
	MDChgProcessIsIdle	mdchgprocessisidle	Truth Value
	BusinessPartnerName	businesspartnername	Extracted Customer Name
	BusinessPartnerFullName	businesspartnerfullname	Broker Name
	CreatedByUser	createdbyuser	User Name
	CreationDate	creationdate	Time Stamp
	CreationTime	creationtime	Time of Change
	LastChangedByUser	lastchangedbyuser	User Name
	LastChangeDate	lastchangedate	Time Stamp
	LastChangeTime	lastchangetime	Time changed
	BusinessPartnerIsBlocked	businesspartnerisblocked	Central Block
	IsBusinessPurposeCompleted	isbusinesspurposecompleted	Purpose Completed
	OrganizationBPName1	organizationbpname1	Name 1
	OrganizationBPName2	organizationbpname2	Name 2
	OrganizationBPName3	organizationbpname3	Name 3
	OrganizationBPName4	organizationbpname4	Name 4
	InternationalLocationNumber1	internationallocationnumber1	Location no. 1
	InternationalLocationNumber2	internationallocationnumber2	Location no. 2
	InternationalLocationNumber3	internationallocationnumber3	Check digit
	LegalForm	legalform	Legal form
	OrganizationFoundationDate	organizationfoundationdate	Date founded
	OrganizationLiquidationDate	organizationliquidationdate	Liquidation
	Industry	industry	Industry Sector
	FormOfAddressPerson	formofaddressperson	Title Key
	FormOfAddressOrganization	formofaddressorganization	Title Key
	FormOfAddressGroup	formofaddressgroup	Title Key
	FormOfAddress	formofaddress	Title Key
	BusinessPartnerGrouping	businesspartnergrouping	Grouping
	BusinessPartnerType	businesspartnertype	Undefined range (can be used for patch levels)
	BusinessPartnerPrintFormat	businesspartnerprintformat	Print Format
	BusinessPartnerDataOriginType	businesspartnerdataorigintype	Data Origin
	SearchTerm1	searchterm1	Search Term 1
	SearchTerm2	searchterm2	Search Term 2
	BPLastNameSearchHelp	bplastnamesearchhelp	Name 1/Last Nme
	BPFirstNameSearchHelp	bpfirstnamesearchhelp	Name2/First Nme
	IndependentAddressID	independentaddressid	Address Number
	IsMarkedForArchiving	ismarkedforarchiving	Archiving Flag
	ContactPermission	contactpermission	Contact
	LegalEntityOfOrganization	legalentityoforganization	Legal entity
	BusinessPartnerIsNotReleased	businesspartnerisnotreleased	Not released
	IsNotContractuallyCapable	isnotcontractuallycapable	Not Legally Competnt
	ActiveAuthorizationGroup	activeauthorizationgroup	Authorization Group
	CorrespondenceLanguage	correspondencelanguage	Language
	BPPersonDataIsDisplayed	bppersondataisdisplayed	TRUE
	BusPartPersonDataIsHidden	buspartpersondataishidden	TRUE
	BusPartOrgDataIsHidden	buspartorgdataishidden	TRUE
	BusPartGroupDataIsHidden	buspartgroupdataishidden	TRUE
	BusPartAddrLanguageIsHidden	buspartaddrlanguageishidden	TRUE
	IsFemale	isfemale	Female
	IsMale	ismale	Male
	IsSexUnknown	issexunknown	Unknown
	GenderCodeName	gendercodename	Sex
	FirstName	firstname	First Name
	LastName	lastname	Last Name
	AdditionalName	additionalname	Name 2
	AdditionalLastName	additionallastname	Other Last Name
	BusinessPartnerBirthName	businesspartnerbirthname	Name at Birth
	MiddleName	middlename	Middle Name
	AcademicTitle	academictitle	Academic Title
	AcademicTitle2	academictitle2	2nd Academic
	BusinessPartnerSupplementName	businesspartnersupplementname	Name Supplement
	LastNamePrefix	lastnameprefix	Prefix Key
	LastNameSecondPrefix	lastnamesecondprefix	2nd prefix
	PersonFullName	personfullname	Full Name
	BusinessPartnerNicknameLabel	businesspartnernicknamelabel	Nickname
	Initials	initials	Initials
	NameFormat	nameformat	Name Format
	NameCountry	namecountry	Country/Region
	Language	language	Report Text Language
	IsNaturalPerson	isnaturalperson	Natural person
	BirthDate	birthdate	Date of Birth
	BusinessPartnerBirthplaceName	businesspartnerbirthplacename	Birthplace
	BusinessPartnerDeathDate	businesspartnerdeathdate	Death date
	BusinessPartnerBirthDateStatus	businesspartnerbirthdatestatus	Birth Date Status
	NaturalPersonEmployerName	naturalpersonemployername	Employer
	BusinessPartnerOccupation	businesspartneroccupation	Occupation
	BusPartMaritalStatus	buspartmaritalstatus	Marital Status
	BusPartNationality	buspartnationality	Nationality
	BusinessPartnerIDByExtSystem	businesspartneridbyextsystem	External Number
	NonResidentCompanyOriginCntry	nonresidentcompanyorigincntry	C/R of Origin
	GroupBusinessPartnerName1	groupbusinesspartnername1	Name 1
	GroupBusinessPartnerName2	groupbusinesspartnername2	Name 2
	BusinessPartnerGroupType	businesspartnergrouptype	Group type
	MDChgBPRelshpHasChanged	mdchgbprelshphaschanged	TRUE
	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
	BPDataControllerIsNotRequired	bpdatacontrollerisnotrequired	DC Not Required
	Origin	origin	Task Origin
	bp_eew_dummy	bp_eew_dummy	Dummy function in length 1

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_BusinessPartnerGovDraft.
-- 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_BusinessPartnerGovDraft AS
SELECT
  BusinessPartnerUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  MDChgProcessStep,
  MasterDataChangeProcessForEdit,
  MDChangeProcessNumberDisplay,
  MDChgProcessSrceObjectTypeCode,
  MDChgProcessGoal,
  BusinessPartner,
  BusinessPartnerCategory,
  AuthorizationGroup,
  PersonNumber,
  ETag,
  MDChgProcessIsStarted,
  MDChgProcessIsIdle,
  BusinessPartnerName,
  BusinessPartnerFullName,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  BusinessPartnerIsBlocked,
  IsBusinessPurposeCompleted,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  InternationalLocationNumber1,
  InternationalLocationNumber2,
  InternationalLocationNumber3,
  LegalForm,
  OrganizationFoundationDate,
  OrganizationLiquidationDate,
  Industry,
  FormOfAddressPerson,
  FormOfAddressOrganization,
  FormOfAddressGroup,
  FormOfAddress,
  BusinessPartnerGrouping,
  BusinessPartnerType,
  BusinessPartnerPrintFormat,
  BusinessPartnerDataOriginType,
  SearchTerm1,
  SearchTerm2,
  BPLastNameSearchHelp,
  BPFirstNameSearchHelp,
  IndependentAddressID,
  IsMarkedForArchiving,
  ContactPermission,
  LegalEntityOfOrganization,
  BusinessPartnerIsNotReleased,
  IsNotContractuallyCapable,
  ActiveAuthorizationGroup,
  CorrespondenceLanguage,
  BPPersonDataIsDisplayed,
  BusPartPersonDataIsHidden,
  BusPartOrgDataIsHidden,
  BusPartGroupDataIsHidden,
  BusPartAddrLanguageIsHidden,
  IsFemale,
  IsMale,
  IsSexUnknown,
  GenderCodeName,
  FirstName,
  LastName,
  AdditionalName,
  AdditionalLastName,
  BusinessPartnerBirthName,
  MiddleName,
  AcademicTitle,
  AcademicTitle2,
  BusinessPartnerSupplementName,
  LastNamePrefix,
  LastNameSecondPrefix,
  PersonFullName,
  BusinessPartnerNicknameLabel,
  Initials,
  NameFormat,
  NameCountry,
  Language,
  IsNaturalPerson,
  BirthDate,
  BusinessPartnerBirthplaceName,
  BusinessPartnerDeathDate,
  BusinessPartnerBirthDateStatus,
  NaturalPersonEmployerName,
  BusinessPartnerOccupation,
  BusPartMaritalStatus,
  BusPartNationality,
  BusinessPartnerIDByExtSystem,
  NonResidentCompanyOriginCntry,
  GroupBusinessPartnerName1,
  GroupBusinessPartnerName2,
  BusinessPartnerGroupType,
  MDChgBPRelshpHasChanged,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10,
  BPDataControllerIsNotRequired,
  Origin,
  bp_eew_dummy
FROM but000_dft
;

Depth:

R_BusinessPartnerGovDraft view_entity

but000_dft