R_LastMileVisitListTP

DDL: R_LASTMILEVISITLISTTP Type: view_entity TRANSACTIONAL
32 Fields 1 Data Sources 5 Associations

LMD Visit list - Transactional View

R_LastMileVisitListTP is a Transactional CDS View that provides data about "LMD Visit list - Transactional View" in SAP S/4HANA. It reads from 1 data source (I_LastMileVisitList) and exposes 32 fields with key field LastMileVisitListUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LastMileVisitList I_LastMileVisitList from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner $projection.LastMileVisitListDriverID = _BusinessPartner.BusinessPartner
[0..1] I_LastMileVisitListCalculated _VisitListCalculated $projection.LastMileVisitListUUID = _VisitListCalculated.LastMileVisitListUUID
[1] E_LastMileVisitList _Extension $projection.LastMileVisitListUUID = _Extension.LastMileVisitListUUID
[0..*] R_LastMileVisitTP _Visit
[0..*] R_LastMileLoadPrpslTP _LoadProposal

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label LMD Visit list - Transactional View view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name LastMileVisitList view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY LastMileVisitListUUID LastMileVisitListUUID Visit List UUID
LastMileVisitListID LastMileVisitListID Visit List ID
LastMileVisitListExtUUID LastMileVisitListExtUUID Visit List Ext. UUID
LastMileVisitListExternalID LastMileVisitListExternalID Visit List External ID
LastMileVisitListType LastMileVisitListType Visit List Type
LastMileVisitListDriverID LastMileVisitListDriverID Driver Name
LastMileVisitListExecutionDate LastMileVisitListExecutionDate Execution date
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SourceLocation SourceLocation Source Location
LastMileVisitListDescription LastMileVisitListDescription Well Code Des.
LastMileVisitListStatus LastMileVisitListStatus Visit Status
LastMileVisitListLastChnDteTme LastMileVisitListLastChnDteTme Timestamp
TimeZoneID TimeZoneID Time Zone
LastMileVisitListCrtnDateTime LastMileVisitListCrtnDateTime Variant created on
LstMiRteExecutionOrganization LstMiRteExecutionOrganization Exec. Organization
LastMileVisitListErrorsExist LastMileVisitListErrorsExist Log Message Status
LastMileVisitListStatusUpdtExt LastMileVisitListStatusUpdtExt Status Update in External System
_Visit _Visit
_LoadProposal _LoadProposal
_BusinessPartner _BusinessPartner
_VisitListCalculated _VisitListCalculated
_VisitListIDVH _VisitListIDVH
_VisitListExtIDVH _VisitListExtIDVH
_VisitListTypeVH _VisitListTypeVH
_VisitListStatusVH _VisitListStatusVH
_ErrorsExistVH _ErrorsExistVH
_OrganizationVH _OrganizationVH
_DistributionChannelVH _DistributionChannelVH
_DivisionVH _DivisionVH
_StartLocVH _StartLocVH

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_LastMileVisitListTP.
-- 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_LastMileVisitListTP AS
SELECT
  LastMileVisitListUUID,
  LastMileVisitListID,
  LastMileVisitListExtUUID,
  LastMileVisitListExternalID,
  LastMileVisitListType,
  LastMileVisitListDriverID,
  LastMileVisitListExecutionDate,
  SalesOrganization,
  DistributionChannel,
  Division,
  SourceLocation,
  LastMileVisitListDescription,
  LastMileVisitListStatus,
  LastMileVisitListLastChnDteTme,
  TimeZoneID,
  LastMileVisitListCrtnDateTime,
  LstMiRteExecutionOrganization,
  LastMileVisitListErrorsExist,
  LastMileVisitListStatusUpdtExt
FROM I_LastMileVisitList
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON LastMileVisitListDriverID = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_LastMileVisitListCalculated AS _VisitListCalculated ON LastMileVisitListUUID = _VisitListCalculated.LastMileVisitListUUID  -- association [0..1]
LEFT OUTER JOIN E_LastMileVisitList AS _Extension ON LastMileVisitListUUID = _Extension.LastMileVisitListUUID  -- association [1]
LEFT OUTER JOIN R_LastMileVisitTP AS _Visit ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_LastMileLoadPrpslTP AS _LoadProposal ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More