I_SrvcTransMasterAgreement

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_SrvcTransMasterAgreement.
-- 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_SrvcTransMasterAgreement AS
SELECT
  object_id AS SrvcTransMstrAgrmtID,
  header_guid AS SrvcTransMstrAgrmtUUID,
  objtype_h AS SrvcTransMstrAgrmtType,
  process_type AS ServiceDocumentType,
  posting_date AS PostingDate,
  description_h AS ServiceDocumentDescription,
  descr_language AS Language,
  created_at_h AS ServiceDocCreationDateTime,
  created_by_h AS ServiceDocumentCreatedByUser,
  changed_at_h AS ServiceDocChangedDateTime,
  changed_by_h AS ServiceDocumentChangedByUser,
  contstart AS SrvcTransMstrAgrmtStrtDteTme,
  contend AS SrvcTransMstrAgrmtEndDteTme,
  sales_org AS SalesOrganizationOrgUnitID,
  sales_office AS SalesOfficeOrgUnitID,
  sales_group AS SalesGroupOrgUnitID,
  sales_org_resp AS ResponsibleSalesOrganization,
  sales_org_sd AS SalesOrganization,
  dis_channel AS DistributionChannel,
  Division,
  sales_office_sd AS SalesOffice,
  sales_group_sd AS SalesGroup,
  service_org AS ServiceOrganization,
  service_org_resp AS ResponsibleServiceOrganization,
  sold_to_party AS SoldToParty,
  cast( person_resp as abap.char( 12 )) AS PersonResponsible,
  cast( contact_person as abap.numc( 10 )) AS ContactPerson,
  payer AS PayerParty,
  stat_open AS SrvcTransMstrAgrmtIsOpen,
  stat_released AS SrvcTransMstrAgrmtIsReleased,
  stat_cancelled AS SrvcTransMstrAgrmtIsRejected,
  stat_lifecycle AS SrvcTransMstrAgrmtStatus,
  cast( ac_assignment as abap.char( 24 )) AS WBSElementExternalID
FROM crms4d_magr_h
LEFT OUTER JOIN I_CustMgmtBusObjType AS _ServiceObjType ON SrvcTransMstrAgrmtType = _ServiceObjType.BusinessObjectType  -- association [1..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentStatus AS _ServiceDocumentStatus ON SrvcTransMstrAgrmtStatus = _ServiceDocumentStatus.ServiceDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _SalesOrganizationOrgUnit ON SalesOrganizationOrgUnitID = _SalesOrganizationOrgUnit.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _SalesOfficeOrgUnit ON SalesOfficeOrgUnitID = _SalesOfficeOrgUnit.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _SalesGroupOrgUnit ON SalesGroupOrgUnitID = _SalesGroupOrgUnit.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _ServiceOrganizationOrgUnit ON ServiceOrganization = _ServiceOrganizationOrgUnit.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _RespSrvcOrganizationOrgUnit ON ResponsibleServiceOrganization = _RespSrvcOrganizationOrgUnit.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _RespSalesOrganizationOrgUnit ON ResponsibleSalesOrganization = _RespSalesOrganizationOrgUnit.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _SoldToParty ON SoldToParty = _SoldToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _RespPerson ON PersonResponsible = _RespPerson.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ContactPerson ON ContactPerson = _ContactPerson.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _PayerParty ON PayerParty = _PayerParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_SrvcTransMasterAgreementItem AS _MasterAgreementItem ON SrvcTransMstrAgrmtID = _MasterAgreementItem.SrvcTransMstrAgrmtID  -- association [0..*]
LEFT OUTER JOIN I_SrvcTransMstrAgrmtPartner AS _MstrAgrmtPartner ON SrvcTransMstrAgrmtID = _MstrAgrmtPartner.SrvcTransMstrAgrmtID  -- association [0..*]
LEFT OUTER JOIN I_SrvcTransMstrAgrmtUserStatus AS _MstrAgrmtUserStatus ON SrvcTransMstrAgrmtID = _MstrAgrmtUserStatus.SrvcTransMstrAgrmtID  -- association [0..*]
LEFT OUTER JOIN E_SrvcTransMasterAgreement AS _Extension ON SrvcTransMstrAgrmtID = _Extension.SrvcTransMstrAgrmtID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementExternalID = _WBSElement.WBSElementExternalID  -- association [0..*]
;