R_SalesContractItemPartnerTP

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

Sales Contract Item Partner - TP

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

Data Sources (2)

SourceAliasJoin Type
I_SalesDocItemCompletePartner ItemPartner from
I_SalesDocumentBasic SalesContract inner

Associations (5)

CardinalityTargetAliasCondition
[1..1] R_SalesContractTP _SalesContract $projection.SalesContract = _SalesContract.SalesContract
[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 Sales Contract Item Partner - TP view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY SalesContract
KEY SalesContractItem
KEY PartnerFunction
PartnerFunctionForEdit
Customer I_SalesDocItemCompletePartner Customer Sold-to Party
Supplier I_SalesDocItemCompletePartner Supplier Supplier
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
Personnel I_SalesDocItemCompletePartner Personnel Personnel No.
ContactPerson I_SalesDocItemCompletePartner ContactPerson Contact Person Key
SDDocPartnerAddrIsDocSpecific I_SalesDocItemCompletePartner SDDocPartnerAddrIsDocSpecific
FormOfAddress I_SalesDocItemCompletePartner FormOfAddress Title Key
CorrespondenceLanguage I_SalesDocItemCompletePartner CorrespondenceLanguage Language
TransportZone
StreetName
HouseNumber
PostalCode
Country
Region
DistrictName
CityName
POBox
POBoxPostalCode
TaxJurisdiction
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.
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
SalesContractType _SalesContract SalesContractType
SalesOrganization _SalesContract SalesOrganization Sales Organization
DistributionChannel _SalesContract DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesContract OrganizationDivision Org. Division
_Item _Item
_SalesContract _SalesContract
_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_SalesContractItemPartnerTP.
-- 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_SalesContractItemPartnerTP AS
SELECT
  cast(ItemPartner.SalesDocument as sales_contract preserving type) AS SalesContract,
  cast(ItemPartner.SalesDocumentItem as sales_contract_item preserving type) AS SalesContractItem,
  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.Partner AS Partner,
  ItemPartner.FullName AS FullName,
  _PartnerFunction.SDDocumentPartnerType AS SDDocumentPartnerType,
  ItemPartner.PartnerIsSpecificForSDDocItem AS PartnerIsSpecificForSDDocItem,
  ItemPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  ItemPartner.Personnel AS Personnel,
  ItemPartner.ContactPerson AS ContactPerson,
  ItemPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  ItemPartner.FormOfAddress AS FormOfAddress,
  ItemPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  ItemPartner._OrgNamePostalAddress.TransportZone AS TransportZone,
  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._OrgNamePostalAddress.TaxJurisdiction AS TaxJurisdiction,
  ItemPartner.AddressID AS AddressID,
  ItemPartner.AddressPersonID AS AddressPersonID,
  ItemPartner.AddressObjectType AS AddressObjectType,
  ItemPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  ItemPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  ItemPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  ItemPartner.VATRegistration AS VATRegistration,
  ItemPartner.UnloadingPointName AS UnloadingPointName,
  ItemPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  ItemPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  ItemPartner.EmailAddress AS EmailAddress,
  _SalesContract.SalesContractType AS SalesContractType,
  _SalesContract.SalesOrganization AS SalesOrganization,
  _SalesContract.DistributionChannel AS DistributionChannel,
  _SalesContract.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 SalesContract ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_SalesContractTP AS _SalesContract ON SalesContract = _SalesContract.SalesContract  -- 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