What is R_DebitMemoRequestPartnerTP in SAP S/4HANA?

R_DebitMemoRequestPartnerTP is a transactional CDS view in SAP S/4HANA. Debit Memo Request Partner - TP It contains 55 fields.

Which tables does R_DebitMemoRequestPartnerTP read from?

R_DebitMemoRequestPartnerTP reads data from: I_DebitMemoReqPartner.

What VDM layer is R_DebitMemoRequestPartnerTP?

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

R_DebitMemoRequestPartnerTP

DDL: R_DEBITMEMOREQUESTPARTNERTP Type: view_entity TRANSACTIONAL

55 Fields 1 Data Sources 4 Associations

Debit Memo Request Partner - TP

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

Data Sources (1)

Source	Alias	Join Type
I_DebitMemoReqPartner	DebitMemoRequestPartner	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`

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	Debit Memo Request Partner - TP	view

Fields (55)

Key	Field	Source Table	Source Field	Description
KEY	DebitMemoRequest		DebitMemoRequest
KEY	PartnerFunction
	PartnerFunctionForEdit
	Customer	I_DebitMemoReqPartner	Customer	Sold-to Party
	Supplier	I_DebitMemoReqPartner	Supplier	Supplier
	Personnel	I_DebitMemoReqPartner	Personnel	Personnel No.
	ContactPerson	I_DebitMemoReqPartner	ContactPerson	Contact Person Key
	ReferenceBusinessPartner	I_DebitMemoReqPartner	ReferenceBusinessPartner	Busn. Partner
	Partner	I_DebitMemoReqPartner	Partner	With Partner
	FullName	I_DebitMemoReqPartner	FullName	Name
	SDDocumentPartnerType	_PartnerFunction	SDDocumentPartnerType	Partner Type
	FormOfAddress	I_DebitMemoReqPartner	FormOfAddress	Title Key
	PostalCode
	CityName
	DistrictName
	Country
	Region
	StreetName
	StreetPrefixName1
	StreetPrefixName2
	StreetSuffixName1
	StreetSuffixName2
	HouseNumber
	InternationalPhoneNumber	I_DebitMemoReqPartner	InternationalPhoneNumber	Telephone no.
	InternationalMobilePhoneNumber	I_DebitMemoReqPartner	InternationalMobilePhoneNumber
	EmailAddress	I_DebitMemoReqPartner	EmailAddress	E-Mail Address
	InternationalFaxNumber	I_DebitMemoReqPartner	InternationalFaxNumber	Fax Number
	POBox
	POBoxPostalCode
	CorrespondenceLanguage	I_DebitMemoReqPartner	CorrespondenceLanguage	Language
	TaxJurisdiction
	TransportZone
	UnloadingPointName	I_DebitMemoReqPartner	UnloadingPointName	Unloading Point Name
	VATRegistration	I_DebitMemoReqPartner	VATRegistration	VAT Registration No.
	AddressID	I_DebitMemoReqPartner	AddressID	Ship-to address
	AddressPersonID	I_DebitMemoReqPartner	AddressPersonID	Person Number
	AddressObjectType	I_DebitMemoReqPartner	AddressObjectType	Address Type
	SDDocPartnerAddressRefType	I_DebitMemoReqPartner	SDDocPartnerAddressRefType	Adress ind.
	BPAddrDeterminationTransaction	I_DebitMemoReqPartner	BPAddrDeterminationTransaction	Address Detn
	BPRefAddressIDForDocSpcfcAddr	I_DebitMemoReqPartner	BPRefAddressIDForDocSpcfcAddr	BP Ref. Address Num.
	DebitMemoRequestType	_DebitMemoRequest	DebitMemoRequestType
	SalesOrganization	_DebitMemoRequest	SalesOrganization	Sales Organization
	DistributionChannel	_DebitMemoRequest	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	_DebitMemoRequest	OrganizationDivision	Org. Division
	_DebitMemoRequest		_DebitMemoRequest
	_PartnerFunction		_PartnerFunction
	_CorrespondenceLanguage		_CorrespondenceLanguage
	_FormOfAddress		_FormOfAddress
	_TransportationZone		_TransportationZone
	_DfltAddrRprstn	I_DebitMemoReqPartner	_DfltAddrRprstn
	_OrgNamePostalAddress	I_DebitMemoReqPartner	_OrgNamePostalAddress
	_BusinessPartnerAddress	I_DebitMemoReqPartner	_BusinessPartnerAddress
	_BPRefAddressForDocSpcfcAddr	I_DebitMemoReqPartner	_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_DebitMemoRequestPartnerTP.
-- 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_DebitMemoRequestPartnerTP AS
SELECT
  DebitMemoRequest,
  cast(DebitMemoRequestPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  cast(DebitMemoRequestPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunctionForEdit,
  DebitMemoRequestPartner.Customer AS Customer,
  DebitMemoRequestPartner.Supplier AS Supplier,
  DebitMemoRequestPartner.Personnel AS Personnel,
  DebitMemoRequestPartner.ContactPerson AS ContactPerson,
  DebitMemoRequestPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  DebitMemoRequestPartner.Partner AS Partner,
  DebitMemoRequestPartner.FullName AS FullName,
  _PartnerFunction.SDDocumentPartnerType AS SDDocumentPartnerType,
  DebitMemoRequestPartner.FormOfAddress AS FormOfAddress,
  DebitMemoRequestPartner._OrgNamePostalAddress.PostalCode AS PostalCode,
  DebitMemoRequestPartner._OrgNamePostalAddress.CityName AS CityName,
  DebitMemoRequestPartner._OrgNamePostalAddress.DistrictName AS DistrictName,
  DebitMemoRequestPartner._OrgNamePostalAddress.Country AS Country,
  DebitMemoRequestPartner._OrgNamePostalAddress.Region AS Region,
  DebitMemoRequestPartner._OrgNamePostalAddress.StreetName AS StreetName,
  DebitMemoRequestPartner._OrgNamePostalAddress.StreetPrefixName1 AS StreetPrefixName1,
  DebitMemoRequestPartner._OrgNamePostalAddress.StreetPrefixName2 AS StreetPrefixName2,
  DebitMemoRequestPartner._OrgNamePostalAddress.StreetSuffixName1 AS StreetSuffixName1,
  DebitMemoRequestPartner._OrgNamePostalAddress.StreetSuffixName2 AS StreetSuffixName2,
  DebitMemoRequestPartner._OrgNamePostalAddress.HouseNumber AS HouseNumber,
  DebitMemoRequestPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  DebitMemoRequestPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  DebitMemoRequestPartner.EmailAddress AS EmailAddress,
  DebitMemoRequestPartner.InternationalFaxNumber AS InternationalFaxNumber,
  DebitMemoRequestPartner._OrgNamePostalAddress.POBox AS POBox,
  DebitMemoRequestPartner._OrgNamePostalAddress.POBoxPostalCode AS POBoxPostalCode,
  DebitMemoRequestPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  DebitMemoRequestPartner._OrgNamePostalAddress.TaxJurisdiction AS TaxJurisdiction,
  DebitMemoRequestPartner._OrgNamePostalAddress.TransportZone AS TransportZone,
  DebitMemoRequestPartner.UnloadingPointName AS UnloadingPointName,
  DebitMemoRequestPartner.VATRegistration AS VATRegistration,
  DebitMemoRequestPartner.AddressID AS AddressID,
  DebitMemoRequestPartner.AddressPersonID AS AddressPersonID,
  DebitMemoRequestPartner.AddressObjectType AS AddressObjectType,
  DebitMemoRequestPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  DebitMemoRequestPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  DebitMemoRequestPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  _DebitMemoRequest.DebitMemoRequestType AS DebitMemoRequestType,
  _DebitMemoRequest.SalesOrganization AS SalesOrganization,
  _DebitMemoRequest.DistributionChannel AS DistributionChannel,
  _DebitMemoRequest.OrganizationDivision AS OrganizationDivision,
  DebitMemoRequestPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  DebitMemoRequestPartner._OrgNamePostalAddress AS _OrgNamePostalAddress,
  DebitMemoRequestPartner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  DebitMemoRequestPartner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  DebitMemoRequestPartner._OrgNamePostalAddress._Country AS _Country,
  DebitMemoRequestPartner._OrgNamePostalAddress._Region AS _Region
FROM I_DebitMemoReqPartner AS DebitMemoRequestPartner
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  -- association [0..1]
;

Depth:

R_DebitMemoRequestPartnerTP view_entity

I_DebitMemoReqPartner view

I_DebitMemoRequestPartnerTP view_entity