C_CrdtMemoReqItemPrtnManageTP

DDL: C_CRDTMEMOREQITEMPRTNMANAGETP Type: view_entity CONSUMPTION
55 Fields 1 Data Sources 1 Associations

Credit Memo Request Item Partners

C_CrdtMemoReqItemPrtnManageTP is a Consumption CDS View that provides data about "Credit Memo Request Item Partners" in SAP S/4HANA. It reads from 1 data source (R_CreditMemoReqItemPartnerTP) and exposes 55 fields with key fields CreditMemoRequest, CreditMemoRequestItem, PartnerFunction. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_CreditMemoReqItemPartnerTP R_CreditMemoReqItemPartnerTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_PartnerFunctionUnconverted _PartnerFunction $projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction

Annotations (10)

NameValueLevelField
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 Credit Memo Request Item Partners view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY CreditMemoRequest ItemPartner CreditMemoRequest
KEY CreditMemoRequestItem ItemPartner CreditMemoRequestItem
KEY PartnerFunction ItemPartner PartnerFunction Partner Functn
PartnerFunctionForEdit ItemPartner PartnerFunctionForEdit Partner Funct.
Customer ItemPartner Customer Sold-to Party
Supplier ItemPartner Supplier Supplier
Personnel ItemPartner Personnel Personnel No.
ContactPerson ItemPartner ContactPerson Contact Person Key
Partner ItemPartner Partner With Partner
ReferenceBusinessPartner ItemPartner ReferenceBusinessPartner Busn. Partner
FullName ItemPartner FullName Name
SDDocumentPartnerType ItemPartner SDDocumentPartnerType Partner Type
PartnerIsSpecificForSDDocItem ItemPartner PartnerIsSpecificForSDDocItem
UnloadingPointName ItemPartner UnloadingPointName Unloading Point Name
VATRegistration ItemPartner VATRegistration VAT Registration No.
virtualSDCustomerAddressIDadrnr
virtualSDContactPersonAddressIDadrnr
SDDocPartnerAddrIsDocSpecific ItemPartner SDDocPartnerAddrIsDocSpecific
AddressID ItemPartner AddressID Ship-to address
AddressPersonID ItemPartner AddressPersonID Person Number
AddressObjectType ItemPartner AddressObjectType Address Type
virtualBusinessPartnerName1ad_name1
virtualBusinessPartnerName2ad_name2
virtualBusinessPartnerName3ad_name3
virtualBusinessPartnerName4ad_name4
FormOfAddress ItemPartner FormOfAddress Title Key
PostalCode ItemPartner PostalCode Postal Code
CityName ItemPartner CityName Name
Country ItemPartner Country Venue: Ctry/Reg
Region ItemPartner Region Venue Region
DistrictName ItemPartner DistrictName District
StreetName ItemPartner StreetName Text
HouseNumber ItemPartner HouseNumber House Number
POBox ItemPartner POBox PO Box
POBoxPostalCode ItemPartner POBoxPostalCode PO Box Postal Code
CorrespondenceLanguage ItemPartner CorrespondenceLanguage Correspondence Language
TaxJurisdiction ItemPartner TaxJurisdiction Tax Jurisdiction
TransportZone ItemPartner TransportZone Transport Zone
InternationalPhoneNumber ItemPartner InternationalPhoneNumber Telephone no.
InternationalMobilePhoneNumber ItemPartner InternationalMobilePhoneNumber
EmailAddress ItemPartner EmailAddress E-Mail Address
virtualUICT_VATRegistrationboole_d
virtualUICT_UnloadingPointNameboole_d
virtualUICT_BusinessPartnerName3boole_d
virtualUICT_BusinessPartnerName4boole_d
CreditMemoRequestType ItemPartner CreditMemoRequestType
SalesOrganization ItemPartner SalesOrganization Sales Organization
DistributionChannel ItemPartner DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision ItemPartner OrganizationDivision Org. Division
_PartnerFunction _PartnerFunction
_FormOfAddress ItemPartner _FormOfAddress
_Country ItemPartner _Country
_Region ItemPartner _Region
_CorrespondenceLanguage ItemPartner _CorrespondenceLanguage
_TransportationZone ItemPartner _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_CrdtMemoReqItemPrtnManageTP.
-- 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_CrdtMemoReqItemPrtnManageTP AS
SELECT
  ItemPartner.CreditMemoRequest AS CreditMemoRequest,
  ItemPartner.CreditMemoRequestItem AS CreditMemoRequestItem,
  ItemPartner.PartnerFunction AS PartnerFunction,
  ItemPartner.PartnerFunctionForEdit AS PartnerFunctionForEdit,
  ItemPartner.Customer AS Customer,
  ItemPartner.Supplier AS Supplier,
  ItemPartner.Personnel AS Personnel,
  ItemPartner.ContactPerson AS ContactPerson,
  ItemPartner.Partner AS Partner,
  ItemPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  ItemPartner.FullName AS FullName,
  ItemPartner.SDDocumentPartnerType AS SDDocumentPartnerType,
  ItemPartner.PartnerIsSpecificForSDDocItem AS PartnerIsSpecificForSDDocItem,
  ItemPartner.UnloadingPointName AS UnloadingPointName,
  ItemPartner.VATRegistration AS VATRegistration,
  virtual SDCustomerAddressID : adrnr AS virtualSDCustomerAddressIDadrnr,
  virtual SDContactPersonAddressID : adrnr AS virtualSDContactPersonAddressIDadrnr,
  ItemPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  ItemPartner.AddressID AS AddressID,
  ItemPartner.AddressPersonID AS AddressPersonID,
  ItemPartner.AddressObjectType AS AddressObjectType,
  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,
  ItemPartner.FormOfAddress AS FormOfAddress,
  ItemPartner.PostalCode AS PostalCode,
  ItemPartner.CityName AS CityName,
  ItemPartner.Country AS Country,
  ItemPartner.Region AS Region,
  ItemPartner.DistrictName AS DistrictName,
  ItemPartner.StreetName AS StreetName,
  ItemPartner.HouseNumber AS HouseNumber,
  ItemPartner.POBox AS POBox,
  ItemPartner.POBoxPostalCode AS POBoxPostalCode,
  ItemPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  ItemPartner.TaxJurisdiction AS TaxJurisdiction,
  ItemPartner.TransportZone AS TransportZone,
  ItemPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  ItemPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  ItemPartner.EmailAddress AS EmailAddress,
  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,
  ItemPartner.CreditMemoRequestType AS CreditMemoRequestType,
  ItemPartner.SalesOrganization AS SalesOrganization,
  ItemPartner.DistributionChannel AS DistributionChannel,
  ItemPartner.OrganizationDivision AS OrganizationDivision,
  ItemPartner._FormOfAddress AS _FormOfAddress,
  ItemPartner._Country AS _Country,
  ItemPartner._Region AS _Region,
  ItemPartner._CorrespondenceLanguage AS _CorrespondenceLanguage,
  ItemPartner._TransportationZone AS _TransportationZone
FROM R_CreditMemoReqItemPartnerTP
LEFT OUTER JOIN C_PartnerFunctionUnconverted AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
;

Learn More