I_SrvcTransMstrAgrmtItmPartner

DDL: I_SRVCTRANSMSTRAGRMTITMPARTNER Type: view_entity COMPOSITE
10 Fields 1 Data Sources 4 Associations

Master Agreement Item Partner

I_SrvcTransMstrAgrmtItmPartner is a Composite CDS View that provides data about "Master Agreement Item Partner" in SAP S/4HANA. It reads from 1 data source (P_SrvcTransMstrAgrmtItmPartner) and exposes 10 fields with key fields SrvcTransMstrAgrmtID, SrvcTransMstrAgrmtItem, CustMgmtPartnerFunction, CustMgmtBusinessPartner. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_SrvcTransMstrAgrmtItmPartner MstrAgrmtItemPartner from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_SrvcTransMasterAgreementItem _MstrAgrmtItem MstrAgrmtItemPartner. SrvcTransMstrAgrmtID = _MstrAgrmtItem.SrvcTransMstrAgrmtID and MstrAgrmtItemPartner.SrvcTransMstrAgrmtItem = _MstrAgrmtItem.SrvcDocItmPartReferenceItem and MstrAgrmtItemPartner.ServiceDocumentType = _MstrAgrmtItem.ServiceDocumentType
[0..1] I_CustMgmtPartnerFuncText _PartnerFunction $projection.CustMgmtPartnerFunction = _PartnerFunction.PartnerFunction and _PartnerFunction.Language = $session.system_language
[0..1] I_BusinessPartner _BusinessPartner $projection.CustMgmtBusinessPartner = _BusinessPartner.BusinessPartner
[1..1] I_SrvcTransMasterAgreement _MasterAgreement $projection.SrvcTransMstrAgrmtID = _MasterAgreement.SrvcTransMstrAgrmtID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Master Agreement Item Partner view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SrvcTransMstrAgrmtID SrvcTransMstrAgrmtID
KEY SrvcTransMstrAgrmtItem SrvcTransMstrAgrmtItem
KEY CustMgmtPartnerFunction P_SrvcTransMstrAgrmtItmPartner CustMgmtPartnerFunction
KEY CustMgmtBusinessPartner P_SrvcTransMstrAgrmtItmPartner CustMgmtBusinessPartner
CustMgmtPartFunctionCategory P_SrvcTransMstrAgrmtItmPartner CustMgmtPartFunctionCategory
CustMgmtPartner P_SrvcTransMstrAgrmtItmPartner CustMgmtPartner
CustMgmtPartnerNumberType CustMgmtPartnerNumberType
_PartnerFunction _PartnerFunction
_BusinessPartner _BusinessPartner
_MasterAgreement _MasterAgreement

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 I_SrvcTransMstrAgrmtItmPartner.
-- 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 I_SrvcTransMstrAgrmtItmPartner AS
SELECT
  SrvcTransMstrAgrmtID,
  SrvcTransMstrAgrmtItem,
  MstrAgrmtItemPartner.CustMgmtPartnerFunction AS CustMgmtPartnerFunction,
  MstrAgrmtItemPartner.CustMgmtBusinessPartner AS CustMgmtBusinessPartner,
  MstrAgrmtItemPartner.CustMgmtPartFunctionCategory AS CustMgmtPartFunctionCategory,
  MstrAgrmtItemPartner.CustMgmtPartner AS CustMgmtPartner,
  CustMgmtPartnerNumberType
FROM P_SrvcTransMstrAgrmtItmPartner AS MstrAgrmtItemPartner
LEFT OUTER JOIN I_SrvcTransMasterAgreementItem AS _MstrAgrmtItem ON MstrAgrmtItemPartner. SrvcTransMstrAgrmtID = _MstrAgrmtItem.SrvcTransMstrAgrmtID AND MstrAgrmtItemPartner.SrvcTransMstrAgrmtItem = _MstrAgrmtItem.SrvcDocItmPartReferenceItem AND MstrAgrmtItemPartner.ServiceDocumentType = _MstrAgrmtItem.ServiceDocumentType  -- association [0..*]
LEFT OUTER JOIN I_CustMgmtPartnerFuncText AS _PartnerFunction ON CustMgmtPartnerFunction = _PartnerFunction.PartnerFunction AND _PartnerFunction.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON CustMgmtBusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_SrvcTransMasterAgreement AS _MasterAgreement ON SrvcTransMstrAgrmtID = _MasterAgreement.SrvcTransMstrAgrmtID  -- association [1..1]
;

Learn More