C_CrdtMemoReqItemPrtnManageTP
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. It is exposed through 1 OData service (UI_CREDITMEMOREQUESTMANAGE). Part of development package ODATA_SD_CREDITMEMOREQUEST.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_CreditMemoReqItemPartnerTP | R_CreditMemoReqItemPartnerTP | projection |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | C_PartnerFunctionUnconverted | _PartnerFunction | $projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| 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 |
OData Services (1)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| UI_CREDITMEMOREQUESTMANAGE | UI_CREDITMEMOREQUESTMANAGE | V4 | C1 | NOT_RELEASED |
Fields (55)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- OData Services in SAP S/4HANA Explained
- Service Bindings and Service Definitions in SAP S/4HANA
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA