R_SlsSchedgAgrmtItemPartnerTP

DDL: R_SLSSCHEDGAGRMTITEMPARTNERTP Type: view_entity TRANSACTIONAL Package: RAP_SD_SLS_SCHEDGAGRMT
29 Fields 2 Data Sources 2 Associations

Partner for Sls Sched Agr Item - TP

R_SlsSchedgAgrmtItemPartnerTP is a Transactional CDS View that provides data about "Partner for Sls Sched Agr Item - TP" in SAP S/4HANA. It reads from 2 data sources (I_SalesDocItemCompletePartner, I_SalesDocumentBasic) and exposes 29 fields with key fields SalesSchedulingAgreement, SalesSchedulingAgreementItem, PartnerFunction. It has 2 associations to related views. Part of development package RAP_SD_SLS_SCHEDGAGRMT.

Data Sources (2)

SourceAliasJoin Type
I_SalesDocItemCompletePartner ItemPartner from
I_SalesDocumentBasic SalesSchedulingAgreement inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_SalesSchedgAgrmtTP _SalesSchedulingAgreement $projection.SalesSchedulingAgreement = _SalesSchedulingAgreement.SalesSchedulingAgreement
[0..1] I_PartnerFunction _PartnerFunction $projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction

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 Sched Agr Item - TP view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY SalesSchedulingAgreement
KEY SalesSchedulingAgreementItem
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
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.
SalesSchedgAgrmtType _SalesSchedulingAgreement SalesSchedgAgrmtType
SalesOrganization _SalesSchedulingAgreement SalesOrganization Sales Organization
DistributionChannel _SalesSchedulingAgreement DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesSchedulingAgreement OrganizationDivision Org. Division
_Item _Item
_SalesSchedulingAgreement _SalesSchedulingAgreement
_PartnerFunction _PartnerFunction
_DfltAddrRprstn I_SalesDocItemCompletePartner _DfltAddrRprstn
_BusinessPartnerAddress I_SalesDocItemCompletePartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_SalesDocItemCompletePartner _BPRefAddressForDocSpcfcAddr

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_SlsSchedgAgrmtItemPartnerTP.
-- 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_SlsSchedgAgrmtItemPartnerTP AS
SELECT
  cast(ItemPartner.SalesDocument as vdm_sales_schedg_agrmt preserving type) AS SalesSchedulingAgreement,
  cast(ItemPartner.SalesDocumentItem as vdm_sales_schedg_agrmt_item preserving type) AS SalesSchedulingAgreementItem,
  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.AddressID AS AddressID,
  ItemPartner.AddressPersonID AS AddressPersonID,
  ItemPartner.AddressObjectType AS AddressObjectType,
  ItemPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  ItemPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  ItemPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  _SalesSchedulingAgreement.SalesSchedgAgrmtType AS SalesSchedgAgrmtType,
  _SalesSchedulingAgreement.SalesOrganization AS SalesOrganization,
  _SalesSchedulingAgreement.DistributionChannel AS DistributionChannel,
  _SalesSchedulingAgreement.OrganizationDivision AS OrganizationDivision,
  ItemPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  ItemPartner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  ItemPartner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr
FROM I_SalesDocItemCompletePartner AS ItemPartner
INNER JOIN I_SalesDocumentBasic AS SalesSchedulingAgreement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_SalesSchedgAgrmtTP AS _SalesSchedulingAgreement ON SalesSchedulingAgreement = _SalesSchedulingAgreement.SalesSchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
;

Learn More