What is C_DebitMemoReqPartnerManageTP in SAP S/4HANA?

C_DebitMemoReqPartnerManageTP is a consumption CDS view in SAP S/4HANA. Dbt Memo Request Manage Header Partners It contains 58 fields.

Which tables does C_DebitMemoReqPartnerManageTP read from?

C_DebitMemoReqPartnerManageTP reads data from: R_DebitMemoRequestPartnerTP.

What VDM layer is C_DebitMemoReqPartnerManageTP?

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

C_DebitMemoReqPartnerManageTP

DDL: C_DEBITMEMOREQPARTNERMANAGETP Type: view_entity CONSUMPTION Package: ODATA_SD_DEBITMEMOREQUEST

58 Fields 1 Data Sources 1 Associations 1 OData Services

Dbt Memo Request Manage Header Partners

C_DebitMemoReqPartnerManageTP is a Consumption CDS View that provides data about "Dbt Memo Request Manage Header Partners" in SAP S/4HANA. It reads from 1 data source (R_DebitMemoRequestPartnerTP) and exposes 58 fields with key fields DebitMemoRequest, PartnerFunction. It has 1 association to related views. It is exposed through 1 OData service (UI_DEBITMEMOREQUESTMANAGE). Part of development package ODATA_SD_DEBITMEMOREQUEST.

Data Sources (1)

Source	Alias	Join Type
R_DebitMemoRequestPartnerTP	R_DebitMemoRequestPartnerTP	projection

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	C_PartnerFunctionUnconverted	_PartnerFunction	`$projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction`

Annotations (10)

Name	Value	Level
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#MANDATORY	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
ObjectModel.modelingPattern	#TRANSACTIONAL_QUERY	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.query.implementedBy	ABAP:CL_S4RAP_STICKY_QRY	view
EndUserText.label	Dbt Memo Request Manage Header Partners	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_DEBITMEMOREQUESTMANAGE	UI_DEBITMEMOREQUESTMANAGE	V4	C1	NOT_RELEASED

Fields (58)

Key	Field	Source Table	Source Field	Description
KEY	DebitMemoRequest	HeaderPartner	DebitMemoRequest
KEY	PartnerFunction	HeaderPartner	PartnerFunction	Partner Functn
	PartnerFunctionForEdit	HeaderPartner	PartnerFunctionForEdit	Partner Funct.
	Customer	HeaderPartner	Customer	Sold-to Party
	Supplier	HeaderPartner	Supplier	Supplier
	Personnel	HeaderPartner	Personnel	Personnel No.
	ContactPerson	HeaderPartner	ContactPerson	Contact Person Key
	FullName	HeaderPartner	FullName	Name
	SDDocumentPartnerType	HeaderPartner	SDDocumentPartnerType	Partner Type
	Partner	HeaderPartner	Partner	With Partner
	ReferenceBusinessPartner	HeaderPartner	ReferenceBusinessPartner	Busn. Partner
	FormOfAddress	HeaderPartner	FormOfAddress	Title Key
	PostalCode	HeaderPartner	PostalCode	Postal Code
	CityName	HeaderPartner	CityName	Name
	DistrictName	HeaderPartner	DistrictName	District
	Country	HeaderPartner	Country	Venue: Ctry/Reg
	Region	HeaderPartner	Region	Venue Region
	StreetName	HeaderPartner	StreetName	Text
	StreetPrefixName1	HeaderPartner	StreetPrefixName1	Street 2
	StreetPrefixName2	HeaderPartner	StreetPrefixName2	Street 3
	StreetSuffixName1	HeaderPartner	StreetSuffixName1	Street 4
	StreetSuffixName2	HeaderPartner	StreetSuffixName2	Street 5
	HouseNumber	HeaderPartner	HouseNumber	House Number
	InternationalPhoneNumber	HeaderPartner	InternationalPhoneNumber	Telephone no.
	InternationalMobilePhoneNumber	HeaderPartner	InternationalMobilePhoneNumber
	InternationalFaxNumber	HeaderPartner	InternationalFaxNumber	Fax Number
	EmailAddress	HeaderPartner	EmailAddress	E-Mail Address
	POBox	HeaderPartner	POBox	PO Box
	POBoxPostalCode	HeaderPartner	POBoxPostalCode	PO Box Postal Code
	CorrespondenceLanguage	HeaderPartner	CorrespondenceLanguage	Correspondence Language
	TaxJurisdiction	HeaderPartner	TaxJurisdiction	Tax Jurisdiction
	TransportZone	HeaderPartner	TransportZone	Transport Zone
	UnloadingPointName	HeaderPartner	UnloadingPointName	Unloading Point Name
	VATRegistration	HeaderPartner	VATRegistration	VAT Registration No.
	AddressID	HeaderPartner	AddressID	Ship-to address
	AddressPersonID	HeaderPartner	AddressPersonID	Person Number
	AddressObjectType	HeaderPartner	AddressObjectType	Address Type
	SDDocPartnerAddrIsDocSpecific	HeaderPartner	SDDocPartnerAddrIsDocSpecific
	virtualBusinessPartnerName1ad_name1
	virtualBusinessPartnerName2ad_name2
	virtualBusinessPartnerName3ad_name3
	virtualBusinessPartnerName4ad_name4
	virtualSDCustomerAddressIDadrnr
	virtualSDContactPersonAddressIDadrnr
	virtualUICT_VATRegistrationboole_d
	virtualUICT_UnloadingPointNameboole_d
	virtualUICT_BusinessPartnerName3boole_d
	virtualUICT_BusinessPartnerName4boole_d
	DebitMemoRequestType	HeaderPartner	DebitMemoRequestType
	SalesOrganization	HeaderPartner	SalesOrganization	Sales Organization
	DistributionChannel	HeaderPartner	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	HeaderPartner	OrganizationDivision	Org. Division
	_PartnerFunction		_PartnerFunction
	_FormOfAddress	HeaderPartner	_FormOfAddress
	_Country	HeaderPartner	_Country
	_Region	HeaderPartner	_Region
	_CorrespondenceLanguage	HeaderPartner	_CorrespondenceLanguage
	_TransportationZone	HeaderPartner	_TransportationZone

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_DebitMemoReqPartnerManageTP.
-- 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_DebitMemoReqPartnerManageTP AS
SELECT
  HeaderPartner.DebitMemoRequest AS DebitMemoRequest,
  HeaderPartner.PartnerFunction AS PartnerFunction,
  HeaderPartner.PartnerFunctionForEdit AS PartnerFunctionForEdit,
  HeaderPartner.Customer AS Customer,
  HeaderPartner.Supplier AS Supplier,
  HeaderPartner.Personnel AS Personnel,
  HeaderPartner.ContactPerson AS ContactPerson,
  HeaderPartner.FullName AS FullName,
  HeaderPartner.SDDocumentPartnerType AS SDDocumentPartnerType,
  HeaderPartner.Partner AS Partner,
  HeaderPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  HeaderPartner.FormOfAddress AS FormOfAddress,
  HeaderPartner.PostalCode AS PostalCode,
  HeaderPartner.CityName AS CityName,
  HeaderPartner.DistrictName AS DistrictName,
  HeaderPartner.Country AS Country,
  HeaderPartner.Region AS Region,
  HeaderPartner.StreetName AS StreetName,
  HeaderPartner.StreetPrefixName1 AS StreetPrefixName1,
  HeaderPartner.StreetPrefixName2 AS StreetPrefixName2,
  HeaderPartner.StreetSuffixName1 AS StreetSuffixName1,
  HeaderPartner.StreetSuffixName2 AS StreetSuffixName2,
  HeaderPartner.HouseNumber AS HouseNumber,
  HeaderPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  HeaderPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  HeaderPartner.InternationalFaxNumber AS InternationalFaxNumber,
  HeaderPartner.EmailAddress AS EmailAddress,
  HeaderPartner.POBox AS POBox,
  HeaderPartner.POBoxPostalCode AS POBoxPostalCode,
  HeaderPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  HeaderPartner.TaxJurisdiction AS TaxJurisdiction,
  HeaderPartner.TransportZone AS TransportZone,
  HeaderPartner.UnloadingPointName AS UnloadingPointName,
  HeaderPartner.VATRegistration AS VATRegistration,
  HeaderPartner.AddressID AS AddressID,
  HeaderPartner.AddressPersonID AS AddressPersonID,
  HeaderPartner.AddressObjectType AS AddressObjectType,
  HeaderPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  virtual BusinessPartnerName1 : ad_name1 AS virtualBusinessPartnerName1ad_name1,
  virtual BusinessPartnerName2 : ad_name2 AS virtualBusinessPartnerName2ad_name2,
  virtual BusinessPartnerName3 : ad_name3 AS virtualBusinessPartnerName3ad_name3,
  virtual BusinessPartnerName4 : ad_name4 AS virtualBusinessPartnerName4ad_name4,
  virtual SDCustomerAddressID : adrnr AS virtualSDCustomerAddressIDadrnr,
  virtual SDContactPersonAddressID : adrnr AS virtualSDContactPersonAddressIDadrnr,
  virtual UICT_VATRegistration : boole_d AS virtualUICT_VATRegistrationboole_d,
  virtual UICT_UnloadingPointName : boole_d AS virtualUICT_UnloadingPointNameboole_d,
  virtual UICT_BusinessPartnerName3 : boole_d AS virtualUICT_BusinessPartnerName3boole_d,
  virtual UICT_BusinessPartnerName4 : boole_d AS virtualUICT_BusinessPartnerName4boole_d,
  HeaderPartner.DebitMemoRequestType AS DebitMemoRequestType,
  HeaderPartner.SalesOrganization AS SalesOrganization,
  HeaderPartner.DistributionChannel AS DistributionChannel,
  HeaderPartner.OrganizationDivision AS OrganizationDivision,
  HeaderPartner._FormOfAddress AS _FormOfAddress,
  HeaderPartner._Country AS _Country,
  HeaderPartner._Region AS _Region,
  HeaderPartner._CorrespondenceLanguage AS _CorrespondenceLanguage,
  HeaderPartner._TransportationZone AS _TransportationZone
FROM R_DebitMemoRequestPartnerTP
LEFT OUTER JOIN C_PartnerFunctionUnconverted AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
;

Depth:

C_DebitMemoReqPartnerManageTP view_entity

R_DebitMemoRequestPartnerTP view_entity