C_SlsContrItemPartnerManageTP

DDL: C_SLSCONTRITEMPARTNERMANAGETP Type: view_entity CONSUMPTION
55 Fields 1 Data Sources 1 Associations 1 OData Services

Sales Contract Item Partner

C_SlsContrItemPartnerManageTP is a Consumption CDS View that provides data about "Sales Contract Item Partner" in SAP S/4HANA. It reads from 1 data source (R_SalesContractItemPartnerTP) and exposes 55 fields with key fields SalesContract, SalesContractItem, PartnerFunction. It has 1 association to related views. It is exposed through 1 OData service (UI_SALESCONTRACTMANAGE).

Data Sources (1)

SourceAliasJoin Type
R_SalesContractItemPartnerTP R_SalesContractItemPartnerTP projection

Associations (1)

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

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK 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 Sales Contract Item Partner view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SALESCONTRACTMANAGE UI_SALESCONTRACTMANAGE V4 C1 NOT_RELEASED

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY SalesContract ItemPartner SalesContract Sales Document
KEY SalesContractItem ItemPartner SalesContractItem Item
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
virtualSDCustomerAddressIDadrnr
virtualSDContactPersonAddressIDadrnr
PartnerIsSpecificForSDDocItem ItemPartner PartnerIsSpecificForSDDocItem
UnloadingPointName ItemPartner UnloadingPointName Unloading Point Name
VATRegistration ItemPartner VATRegistration VAT Registration No.
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
virtualUICT_BusinessPartnerName3boole_d
virtualUICT_BusinessPartnerName4boole_d
FormOfAddress
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
InternationalMobilePhoneNumber
EmailAddress
virtualUICT_VATRegistrationboole_d
virtualUICT_UnloadingPointNameboole_d
SalesContractType ItemPartner SalesContractType
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_SlsContrItemPartnerManageTP.
-- 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_SlsContrItemPartnerManageTP AS
SELECT
  ItemPartner.SalesContract AS SalesContract,
  ItemPartner.SalesContractItem AS SalesContractItem,
  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,
  virtual SDCustomerAddressID : adrnr AS virtualSDCustomerAddressIDadrnr,
  virtual SDContactPersonAddressID : adrnr AS virtualSDContactPersonAddressIDadrnr,
  ItemPartner.PartnerIsSpecificForSDDocItem AS PartnerIsSpecificForSDDocItem,
  ItemPartner.UnloadingPointName AS UnloadingPointName,
  ItemPartner.VATRegistration AS VATRegistration,
  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,
  virtual UICT_BusinessPartnerName3 : boole_d AS virtualUICT_BusinessPartnerName3boole_d,
  virtual UICT_BusinessPartnerName4 : boole_d AS virtualUICT_BusinessPartnerName4boole_d,
  cast( ItemPartner.FormOfAddress as ad_title preserving type ) 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,
  cast( ItemPartner.InternationalPhoneNumber as ad_telnrlg preserving type ) AS InternationalPhoneNumber,
  cast( ItemPartner.InternationalMobilePhoneNumber as ad_telnrlg preserving type ) AS InternationalMobilePhoneNumber,
  cast( ItemPartner.EmailAddress as ad_smtpadr preserving type ) AS EmailAddress,
  virtual UICT_VATRegistration : boole_d AS virtualUICT_VATRegistrationboole_d,
  virtual UICT_UnloadingPointName : boole_d AS virtualUICT_UnloadingPointNameboole_d,
  ItemPartner.SalesContractType AS SalesContractType,
  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_SalesContractItemPartnerTP
LEFT OUTER JOIN C_PartnerFunctionUnconverted AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
;

Learn More