R_CreditMemoReqItemPartnerTP

DDL: R_CREDITMEMOREQITEMPARTNERTP Type: view_entity TRANSACTIONAL
54 Fields 2 Data Sources 5 Associations

Credit Memo Request Item Partner - TP

R_CreditMemoReqItemPartnerTP is a Transactional CDS View that provides data about "Credit Memo Request Item Partner - TP" in SAP S/4HANA. It reads from 2 data sources (I_SalesDocumentBasic, I_SalesDocItemCompletePartner) and exposes 54 fields with key fields CreditMemoRequest, CreditMemoRequestItem, PartnerFunction. It has 5 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_SalesDocumentBasic CreditMemoRequest inner
I_SalesDocItemCompletePartner ItemPartner from

Associations (5)

CardinalityTargetAliasCondition
[1..1] R_CreditMemoRequestTP _CreditMemoRequest $projection.CreditMemoRequest = _CreditMemoRequest.CreditMemoRequest
[0..1] I_PartnerFunction _PartnerFunction $projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction
[0..1] I_FormOfAddress _FormOfAddress $projection.FormOfAddress = _FormOfAddress.FormOfAddress
[0..1] I_Language _CorrespondenceLanguage $projection.CorrespondenceLanguage = _CorrespondenceLanguage.Language
[0..1] I_TransportationZone _TransportationZone $projection.transportzone = _TransportationZone.TransportZone and $projection.country = _TransportationZone.CountryCode

Annotations (8)

NameValueLevelField
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 Item Partner - TP view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY CreditMemoRequest
KEY CreditMemoRequestItem
KEY PartnerFunction
PartnerFunctionForEdit
Customer I_SalesDocItemCompletePartner Customer Sold-to Party
Supplier I_SalesDocItemCompletePartner Supplier Supplier
Personnel I_SalesDocItemCompletePartner Personnel Personnel No.
ContactPerson I_SalesDocItemCompletePartner ContactPerson Contact Person Key
Partner I_SalesDocItemCompletePartner Partner With Partner
FullName I_SalesDocItemCompletePartner FullName Name
SDDocumentPartnerType _PartnerFunction SDDocumentPartnerType Partner Type
PartnerIsSpecificForSDDocItem I_SalesDocItemCompletePartner PartnerIsSpecificForSDDocItem
ReferenceBusinessPartner I_SalesDocItemCompletePartner ReferenceBusinessPartner Busn. Partner
SDDocPartnerAddrIsDocSpecific I_SalesDocItemCompletePartner SDDocPartnerAddrIsDocSpecific
FormOfAddress I_SalesDocItemCompletePartner FormOfAddress Title Key
StreetName
HouseNumber
PostalCode
Country
Region
DistrictName
CityName
POBox
POBoxPostalCode
CorrespondenceLanguage I_SalesDocItemCompletePartner CorrespondenceLanguage Language
TaxJurisdiction
TransportZone
VATRegistration I_SalesDocItemCompletePartner VATRegistration VAT Registration No.
UnloadingPointName I_SalesDocItemCompletePartner UnloadingPointName Unloading Point Name
InternationalPhoneNumber I_SalesDocItemCompletePartner InternationalPhoneNumber Telephone no.
InternationalMobilePhoneNumber I_SalesDocItemCompletePartner InternationalMobilePhoneNumber
EmailAddress I_SalesDocItemCompletePartner EmailAddress E-Mail Address
AddressID I_SalesDocItemCompletePartner AddressID Ship-to address
AddressPersonID I_SalesDocItemCompletePartner AddressPersonID Person Number
AddressObjectType I_SalesDocItemCompletePartner AddressObjectType Address Type
SDDocPartnerAddressRefType I_SalesDocItemCompletePartner SDDocPartnerAddressRefType Adress ind.
BPAddrDeterminationTransaction I_SalesDocItemCompletePartner BPAddrDeterminationTransaction Address Detn
BPRefAddressIDForDocSpcfcAddr I_SalesDocItemCompletePartner BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
CreditMemoRequestType _CreditMemoRequest CreditMemoRequestType
SalesOrganization _CreditMemoRequest SalesOrganization Sales Organization
DistributionChannel _CreditMemoRequest DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _CreditMemoRequest OrganizationDivision Org. Division
_Item _Item
_CreditMemoRequest _CreditMemoRequest
_PartnerFunction _PartnerFunction
_CorrespondenceLanguage _CorrespondenceLanguage
_TransportationZone _TransportationZone
_FormOfAddress _FormOfAddress
_ContactPerson I_SalesDocItemCompletePartner _ContactPerson
_DfltAddrRprstn I_SalesDocItemCompletePartner _DfltAddrRprstn
_BusinessPartnerAddress I_SalesDocItemCompletePartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_SalesDocItemCompletePartner _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_CreditMemoReqItemPartnerTP.
-- 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_CreditMemoReqItemPartnerTP AS
SELECT
  cast(ItemPartner.SalesDocument as credit_memo_request preserving type) AS CreditMemoRequest,
  cast(ItemPartner.SalesDocumentItem as credit_memo_request_item preserving type) AS CreditMemoRequestItem,
  cast(ItemPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  cast(ItemPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunctionForEdit,
  ItemPartner.Customer AS Customer,
  ItemPartner.Supplier AS Supplier,
  ItemPartner.Personnel AS Personnel,
  ItemPartner.ContactPerson AS ContactPerson,
  ItemPartner.Partner AS Partner,
  ItemPartner.FullName AS FullName,
  _PartnerFunction.SDDocumentPartnerType AS SDDocumentPartnerType,
  ItemPartner.PartnerIsSpecificForSDDocItem AS PartnerIsSpecificForSDDocItem,
  ItemPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  ItemPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  ItemPartner.FormOfAddress AS FormOfAddress,
  ItemPartner._OrgNamePostalAddress.StreetName AS StreetName,
  ItemPartner._OrgNamePostalAddress.HouseNumber AS HouseNumber,
  ItemPartner._OrgNamePostalAddress.PostalCode AS PostalCode,
  ItemPartner._OrgNamePostalAddress.Country AS Country,
  ItemPartner._OrgNamePostalAddress.Region AS Region,
  ItemPartner._OrgNamePostalAddress.DistrictName AS DistrictName,
  ItemPartner._OrgNamePostalAddress.CityName AS CityName,
  ItemPartner._OrgNamePostalAddress.POBox AS POBox,
  ItemPartner._OrgNamePostalAddress.POBoxPostalCode AS POBoxPostalCode,
  ItemPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  ItemPartner._OrgNamePostalAddress.TaxJurisdiction AS TaxJurisdiction,
  ItemPartner._OrgNamePostalAddress.TransportZone AS TransportZone,
  ItemPartner.VATRegistration AS VATRegistration,
  ItemPartner.UnloadingPointName AS UnloadingPointName,
  ItemPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  ItemPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  ItemPartner.EmailAddress AS EmailAddress,
  ItemPartner.AddressID AS AddressID,
  ItemPartner.AddressPersonID AS AddressPersonID,
  ItemPartner.AddressObjectType AS AddressObjectType,
  ItemPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  ItemPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  ItemPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  _CreditMemoRequest.CreditMemoRequestType AS CreditMemoRequestType,
  _CreditMemoRequest.SalesOrganization AS SalesOrganization,
  _CreditMemoRequest.DistributionChannel AS DistributionChannel,
  _CreditMemoRequest.OrganizationDivision AS OrganizationDivision,
  ItemPartner._ContactPerson AS _ContactPerson,
  ItemPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  ItemPartner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  ItemPartner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  ItemPartner._OrgNamePostalAddress._Country AS _Country,
  ItemPartner._OrgNamePostalAddress._Region AS _Region
FROM I_SalesDocItemCompletePartner AS ItemPartner
INNER JOIN I_SalesDocumentBasic AS CreditMemoRequest ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_CreditMemoRequestTP AS _CreditMemoRequest ON CreditMemoRequest = _CreditMemoRequest.CreditMemoRequest  -- association [1..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_FormOfAddress AS _FormOfAddress ON FormOfAddress = _FormOfAddress.FormOfAddress  -- association [0..1]
LEFT OUTER JOIN I_Language AS _CorrespondenceLanguage ON CorrespondenceLanguage = _CorrespondenceLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_TransportationZone AS _TransportationZone ON transportzone = _TransportationZone.TransportZone AND country = _TransportationZone.CountryCode  -- association [0..1]
;

Learn More