R_SlsSchedgAgrmtPartnerTP

DDL: R_SLSSCHEDGAGRMTPARTNERTP Type: view_entity TRANSACTIONAL
53 Fields 1 Data Sources 4 Associations

Partner for Sls Schedg Agrmt - TP

R_SlsSchedgAgrmtPartnerTP is a Transactional CDS View that provides data about "Partner for Sls Schedg Agrmt - TP" in SAP S/4HANA. It reads from 1 data source (I_SalesSchedgAgrmtPartner) and exposes 53 fields with key fields SalesSchedulingAgreement, PartnerFunction. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesSchedgAgrmtPartner SalesSchedgAgrmtPartner from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_PartnerFunction _PartnerFunction $projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction
[1] I_PersonWorkAgreement_1 _WorkAgreement $projection.Personnel = _WorkAgreement.PersonWorkAgreement
[0..1] I_FormOfAddress _FormOfAddress $projection.FormOfAddress = _FormOfAddress.FormOfAddress
[0..1] I_Language _CorrespondenceLanguage $projection.correspondencelanguage = _CorrespondenceLanguage.Language

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 Partner for Sls Schedg Agrmt - TP view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY SalesSchedulingAgreement SalesSchedulingAgreement Sales Document
KEY PartnerFunction
PartnerFunctionForEdit
Customer I_SalesSchedgAgrmtPartner Customer Sold-to Party
Supplier I_SalesSchedgAgrmtPartner Supplier Supplier
Personnel I_SalesSchedgAgrmtPartner Personnel Personnel No.
ContactPerson I_SalesSchedgAgrmtPartner ContactPerson Contact Person Key
ReferenceBusinessPartner I_SalesSchedgAgrmtPartner ReferenceBusinessPartner Busn. Partner
Partner I_SalesSchedgAgrmtPartner Partner With Partner
FullName I_SalesSchedgAgrmtPartner FullName Name
SDDocumentPartnerType _PartnerFunction SDDocumentPartnerType Partner Type
FormOfAddress I_SalesSchedgAgrmtPartner FormOfAddress Title Key
PostalCode
CityName
DistrictName
Country
Region
StreetName
StreetPrefixName1
StreetPrefixName2
StreetSuffixName1
StreetSuffixName2
HouseNumber
InternationalPhoneNumber I_SalesSchedgAgrmtPartner InternationalPhoneNumber Telephone no.
InternationalFaxNumber I_SalesSchedgAgrmtPartner InternationalFaxNumber Fax Number
InternationalMobilePhoneNumber I_SalesSchedgAgrmtPartner InternationalMobilePhoneNumber
EmailAddress I_SalesSchedgAgrmtPartner EmailAddress E-Mail Address
POBox
POBoxPostalCode
CorrespondenceLanguage
TaxJurisdiction
TransportZone
UnloadingPointName I_SalesSchedgAgrmtPartner UnloadingPointName Unloading Point Name
VATRegistration I_SalesSchedgAgrmtPartner VATRegistration VAT Registration No.
AddressID I_SalesSchedgAgrmtPartner AddressID Ship-to address
AddressPersonID I_SalesSchedgAgrmtPartner AddressPersonID Person Number
AddressObjectType I_SalesSchedgAgrmtPartner AddressObjectType Address Type
SDDocPartnerAddressRefType I_SalesSchedgAgrmtPartner SDDocPartnerAddressRefType Adress ind.
BPAddrDeterminationTransaction I_SalesSchedgAgrmtPartner BPAddrDeterminationTransaction Address Detn
BPRefAddressIDForDocSpcfcAddr I_SalesSchedgAgrmtPartner BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
SalesSchedgAgrmtType _SalesSchedulingAgreement SalesSchedgAgrmtType
SalesOrganization _SalesSchedulingAgreement SalesOrganization Sales Organization
DistributionChannel _SalesSchedulingAgreement DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesSchedulingAgreement OrganizationDivision Org. Division
_SalesSchedulingAgreement _SalesSchedulingAgreement
_CorrespondenceLanguage _CorrespondenceLanguage
_FormOfAddress _FormOfAddress
_PartnerFunction _PartnerFunction
_DfltAddrRprstn I_SalesSchedgAgrmtPartner _DfltAddrRprstn
_BusinessPartnerAddress I_SalesSchedgAgrmtPartner _BusinessPartnerAddress
_TransportationZone
_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_SlsSchedgAgrmtPartnerTP.
-- 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_SlsSchedgAgrmtPartnerTP AS
SELECT
  SalesSchedulingAgreement,
  cast(SalesSchedgAgrmtPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  cast(SalesSchedgAgrmtPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunctionForEdit,
  SalesSchedgAgrmtPartner.Customer AS Customer,
  SalesSchedgAgrmtPartner.Supplier AS Supplier,
  SalesSchedgAgrmtPartner.Personnel AS Personnel,
  SalesSchedgAgrmtPartner.ContactPerson AS ContactPerson,
  SalesSchedgAgrmtPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  SalesSchedgAgrmtPartner.Partner AS Partner,
  SalesSchedgAgrmtPartner.FullName AS FullName,
  _PartnerFunction.SDDocumentPartnerType AS SDDocumentPartnerType,
  SalesSchedgAgrmtPartner.FormOfAddress AS FormOfAddress,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.PostalCode AS PostalCode,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.CityName AS CityName,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.DistrictName AS DistrictName,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.Country AS Country,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.Region AS Region,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.StreetName AS StreetName,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.StreetPrefixName1 AS StreetPrefixName1,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.StreetPrefixName2 AS StreetPrefixName2,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.StreetSuffixName1 AS StreetSuffixName1,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.StreetSuffixName2 AS StreetSuffixName2,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.HouseNumber AS HouseNumber,
  SalesSchedgAgrmtPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  SalesSchedgAgrmtPartner.InternationalFaxNumber AS InternationalFaxNumber,
  SalesSchedgAgrmtPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  SalesSchedgAgrmtPartner.EmailAddress AS EmailAddress,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.POBox AS POBox,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.POBoxPostalCode AS POBoxPostalCode,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.CorrespondenceLanguage AS CorrespondenceLanguage,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.TaxJurisdiction AS TaxJurisdiction,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress.TransportZone AS TransportZone,
  SalesSchedgAgrmtPartner.UnloadingPointName AS UnloadingPointName,
  SalesSchedgAgrmtPartner.VATRegistration AS VATRegistration,
  SalesSchedgAgrmtPartner.AddressID AS AddressID,
  SalesSchedgAgrmtPartner.AddressPersonID AS AddressPersonID,
  SalesSchedgAgrmtPartner.AddressObjectType AS AddressObjectType,
  SalesSchedgAgrmtPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  SalesSchedgAgrmtPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  SalesSchedgAgrmtPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  _SalesSchedulingAgreement.SalesSchedgAgrmtType AS SalesSchedgAgrmtType,
  _SalesSchedulingAgreement.SalesOrganization AS SalesOrganization,
  _SalesSchedulingAgreement.DistributionChannel AS DistributionChannel,
  _SalesSchedulingAgreement.OrganizationDivision AS OrganizationDivision,
  SalesSchedgAgrmtPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  SalesSchedgAgrmtPartner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress._TransportationZone AS _TransportationZone,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress._Country AS _Country,
  SalesSchedgAgrmtPartner._OrgNamePostalAddress._Region AS _Region
FROM I_SalesSchedgAgrmtPartner AS SalesSchedgAgrmtPartner
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _WorkAgreement ON Personnel = _WorkAgreement.PersonWorkAgreement  -- association [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]
;

Learn More