What is R_CreditMemoRequestPartnerTP in SAP S/4HANA?

R_CreditMemoRequestPartnerTP is a transactional CDS view in SAP S/4HANA. Credit Memo Request Partner - TP It contains 56 fields.

Which tables does R_CreditMemoRequestPartnerTP read from?

R_CreditMemoRequestPartnerTP reads data from: I_CreditMemoReqPartner.

What VDM layer is R_CreditMemoRequestPartnerTP?

R_CreditMemoRequestPartnerTP is classified as a Transactional view that supports create, update, and delete operations.

R_CreditMemoRequestPartnerTP

DDL: R_CREDITMEMOREQUESTPARTNERTP Type: view_entity TRANSACTIONAL

56 Fields 1 Data Sources 4 Associations

Credit Memo Request Partner - TP

R_CreditMemoRequestPartnerTP is a Transactional CDS View that provides data about "Credit Memo Request Partner - TP" in SAP S/4HANA. It reads from 1 data source (I_CreditMemoReqPartner) and exposes 56 fields with key fields CreditMemoRequest, PartnerFunction. It has 4 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_CreditMemoReqPartner	CreditMemoRequestPartner	from

Associations (4)

Cardinality	Target	Alias	Condition
[0..1]	I_PartnerFunction	_PartnerFunction	`$projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction`
[0..1]	I_Language	_CorrespondenceLanguage	`$projection.CorrespondenceLanguage = _CorrespondenceLanguage.Language`
[0..1]	I_FormOfAddress	_FormOfAddress	`$projection.FormOfAddress = _FormOfAddress.FormOfAddress`
[0..1]	I_TransportationZone	_TransportationZone	`$projection.transportzone = _TransportationZone.TransportZone and $projection.country = _TransportationZone.CountryCode`

Annotations (8)

Name	Value	Level
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
VDM.viewType	#TRANSACTIONAL	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Credit Memo Request Partner - TP	view

Fields (56)

Key	Field	Source Table	Source Field	Description
KEY	CreditMemoRequest		CreditMemoRequest
KEY	PartnerFunction
	PartnerFunctionForEdit
	Customer	I_CreditMemoReqPartner	Customer	Sold-to Party
	Supplier	I_CreditMemoReqPartner	Supplier	Supplier
	Personnel	I_CreditMemoReqPartner	Personnel	Personnel No.
	ContactPerson	I_CreditMemoReqPartner	ContactPerson	Contact Person Key
	ReferenceBusinessPartner	I_CreditMemoReqPartner	ReferenceBusinessPartner	Busn. Partner
	Partner	I_CreditMemoReqPartner	Partner	With Partner
	FullName	I_CreditMemoReqPartner	FullName	Name
	SDDocumentPartnerType	_PartnerFunction	SDDocumentPartnerType	Partner Type
	FormOfAddress	I_CreditMemoReqPartner	FormOfAddress	Title Key
	PostalCode
	CityName
	DistrictName
	Country
	Region
	StreetName
	StreetPrefixName1
	StreetPrefixName2
	StreetSuffixName1
	StreetSuffixName2
	HouseNumber
	InternationalPhoneNumber	I_CreditMemoReqPartner	InternationalPhoneNumber	Telephone no.
	InternationalMobilePhoneNumber	I_CreditMemoReqPartner	InternationalMobilePhoneNumber
	EmailAddress	I_CreditMemoReqPartner	EmailAddress	E-Mail Address
	InternationalFaxNumber	I_CreditMemoReqPartner	InternationalFaxNumber	Fax Number
	POBox
	POBoxPostalCode
	CorrespondenceLanguage	I_CreditMemoReqPartner	CorrespondenceLanguage	Language
	TaxJurisdiction
	TransportZone
	UnloadingPointName	I_CreditMemoReqPartner	UnloadingPointName	Unloading Point Name
	VATRegistration	I_CreditMemoReqPartner	VATRegistration	VAT Registration No.
	SDDocPartnerAddrIsDocSpecific	I_CreditMemoReqPartner	SDDocPartnerAddrIsDocSpecific
	AddressID	I_CreditMemoReqPartner	AddressID	Ship-to address
	AddressPersonID	I_CreditMemoReqPartner	AddressPersonID	Person Number
	AddressObjectType	I_CreditMemoReqPartner	AddressObjectType	Address Type
	SDDocPartnerAddressRefType	I_CreditMemoReqPartner	SDDocPartnerAddressRefType	Adress ind.
	BPAddrDeterminationTransaction	I_CreditMemoReqPartner	BPAddrDeterminationTransaction	Address Detn
	BPRefAddressIDForDocSpcfcAddr	I_CreditMemoReqPartner	BPRefAddressIDForDocSpcfcAddr	BP Ref. Address Num.
	CreditMemoRequestType	_CreditMemoRequest	CreditMemoRequestType
	SalesOrganization	_CreditMemoRequest	SalesOrganization	Sales Organization
	DistributionChannel	_CreditMemoRequest	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	_CreditMemoRequest	OrganizationDivision	Org. Division
	_CreditMemoRequest		_CreditMemoRequest
	_PartnerFunction		_PartnerFunction
	_CorrespondenceLanguage		_CorrespondenceLanguage
	_FormOfAddress		_FormOfAddress
	_TransportationZone		_TransportationZone
	_DfltAddrRprstn	I_CreditMemoReqPartner	_DfltAddrRprstn
	_OrgNamePostalAddress	I_CreditMemoReqPartner	_OrgNamePostalAddress
	_BusinessPartnerAddress	I_CreditMemoReqPartner	_BusinessPartnerAddress
	_BPRefAddressForDocSpcfcAddr	I_CreditMemoReqPartner	_BPRefAddressForDocSpcfcAddr
	_Country
	_Region

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_CreditMemoRequestPartnerTP.
-- 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_CreditMemoRequestPartnerTP AS
SELECT
  CreditMemoRequest,
  cast(CreditMemoRequestPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  cast(CreditMemoRequestPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunctionForEdit,
  CreditMemoRequestPartner.Customer AS Customer,
  CreditMemoRequestPartner.Supplier AS Supplier,
  CreditMemoRequestPartner.Personnel AS Personnel,
  CreditMemoRequestPartner.ContactPerson AS ContactPerson,
  CreditMemoRequestPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  CreditMemoRequestPartner.Partner AS Partner,
  CreditMemoRequestPartner.FullName AS FullName,
  _PartnerFunction.SDDocumentPartnerType AS SDDocumentPartnerType,
  CreditMemoRequestPartner.FormOfAddress AS FormOfAddress,
  CreditMemoRequestPartner._OrgNamePostalAddress.PostalCode AS PostalCode,
  CreditMemoRequestPartner._OrgNamePostalAddress.CityName AS CityName,
  CreditMemoRequestPartner._OrgNamePostalAddress.DistrictName AS DistrictName,
  CreditMemoRequestPartner._OrgNamePostalAddress.Country AS Country,
  CreditMemoRequestPartner._OrgNamePostalAddress.Region AS Region,
  CreditMemoRequestPartner._OrgNamePostalAddress.StreetName AS StreetName,
  CreditMemoRequestPartner._OrgNamePostalAddress.StreetPrefixName1 AS StreetPrefixName1,
  CreditMemoRequestPartner._OrgNamePostalAddress.StreetPrefixName2 AS StreetPrefixName2,
  CreditMemoRequestPartner._OrgNamePostalAddress.StreetSuffixName1 AS StreetSuffixName1,
  CreditMemoRequestPartner._OrgNamePostalAddress.StreetSuffixName2 AS StreetSuffixName2,
  CreditMemoRequestPartner._OrgNamePostalAddress.HouseNumber AS HouseNumber,
  CreditMemoRequestPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  CreditMemoRequestPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  CreditMemoRequestPartner.EmailAddress AS EmailAddress,
  CreditMemoRequestPartner.InternationalFaxNumber AS InternationalFaxNumber,
  CreditMemoRequestPartner._OrgNamePostalAddress.POBox AS POBox,
  CreditMemoRequestPartner._OrgNamePostalAddress.POBoxPostalCode AS POBoxPostalCode,
  CreditMemoRequestPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  CreditMemoRequestPartner._OrgNamePostalAddress.TaxJurisdiction AS TaxJurisdiction,
  CreditMemoRequestPartner._OrgNamePostalAddress.TransportZone AS TransportZone,
  CreditMemoRequestPartner.UnloadingPointName AS UnloadingPointName,
  CreditMemoRequestPartner.VATRegistration AS VATRegistration,
  CreditMemoRequestPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  CreditMemoRequestPartner.AddressID AS AddressID,
  CreditMemoRequestPartner.AddressPersonID AS AddressPersonID,
  CreditMemoRequestPartner.AddressObjectType AS AddressObjectType,
  CreditMemoRequestPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  CreditMemoRequestPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  CreditMemoRequestPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  _CreditMemoRequest.CreditMemoRequestType AS CreditMemoRequestType,
  _CreditMemoRequest.SalesOrganization AS SalesOrganization,
  _CreditMemoRequest.DistributionChannel AS DistributionChannel,
  _CreditMemoRequest.OrganizationDivision AS OrganizationDivision,
  CreditMemoRequestPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  CreditMemoRequestPartner._OrgNamePostalAddress AS _OrgNamePostalAddress,
  CreditMemoRequestPartner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  CreditMemoRequestPartner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  CreditMemoRequestPartner._OrgNamePostalAddress._Country AS _Country,
  CreditMemoRequestPartner._OrgNamePostalAddress._Region AS _Region
FROM I_CreditMemoReqPartner AS CreditMemoRequestPartner
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_Language AS _CorrespondenceLanguage ON CorrespondenceLanguage = _CorrespondenceLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_FormOfAddress AS _FormOfAddress ON FormOfAddress = _FormOfAddress.FormOfAddress  -- association [0..1]
LEFT OUTER JOIN I_TransportationZone AS _TransportationZone ON transportzone = _TransportationZone.TransportZone AND country = _TransportationZone.CountryCode  -- association [0..1]
;

Depth:

R_CreditMemoRequestPartnerTP view_entity

I_CreditMemoReqPartner view

C_CrdtMemoReqPartnerManageTP view_entity
I_CreditMemoRequestPartnerTP view_entity