C_SlsDocAutocompletionLog

DDL: C_SLSDOCAUTOCOMPLETIONLOG Type: view_entity CONSUMPTION Package: VDM_SD_SLS_AUTOCOMPLTN
31 Fields 1 Data Sources 2 Associations 2 OData Services

Sales Document Autocompletion Monitoring

C_SlsDocAutocompletionLog is a Consumption CDS View that provides data about "Sales Document Autocompletion Monitoring" in SAP S/4HANA. It reads from 1 data source (I_SlsDocAutocompletionLog) and exposes 31 fields with key field SalesDocument. It has 2 associations to related views. It is exposed through 2 OData services (ASQL_F7515, UI_MONITORSLSDOCAUTOCOMPLETION). Part of development package VDM_SD_SLS_AUTOCOMPLTN.

Data Sources (1)

SourceAliasJoin Type
I_SlsDocAutocompletionLog AutocompletionLog from

Associations (2)

CardinalityTargetAliasCondition
[1..*] C_SlsDocFieldRecommendationLog _RecommendationLog $projection.SalesDocument = _RecommendationLog.SalesDocument
[0..1] I_SlsDocDataCompletenessStatus _SlsDocDataCompletenessStatus $projection.SlsDocDataCompletenessStatus = _SlsDocDataCompletenessStatus.SlsDocDataCompletenessStatus

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Sales Document Autocompletion Monitoring view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7515 ASQL_F7515 C2 NOT_RELEASED
UI_MONITORSLSDOCAUTOCOMPLETION UI_MONITORSLSDOCAUTOCOMPLETION V4 C1 NOT_RELEASED

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
SalesDocumentType SalesDocumentType Sales Doc. Type
SalesDocumentTypeName
SalesOrganization SalesOrganization Sales Organization
SalesOrganizationName
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
DistributionChannelName
OrganizationDivision OrganizationDivision Org. Division
DivisionName
SoldToParty _SalesDocument SoldToParty Sold-to Party
CustomerName
PurchaseOrderByCustomer _SalesDocument PurchaseOrderByCustomer Purchase Order Number
SalesDocumentDate _SalesDocument SalesDocumentDate Document Date
RequestedDeliveryDate _SalesDocument RequestedDeliveryDate Requested Delivery Date
OverallSDProcessStatus _SalesDocument OverallSDProcessStatus
OverallSDProcessStatusDesc
LastChangedByUser _SalesDocument LastChangedByUser User Name
UserDescription
SlsDocDataCompletenessStatus SlsDocDataCompletenessStatus
SlsDocDataCmpltnsStatusText
NmbrOfSlsDocRecmdnAccptdField NmbrOfSlsDocRecmdnAccptdField
NmbrOfSlsDocMnlChangedField NmbrOfSlsDocMnlChangedField
NmbrOfSlsDocWithRecmdnField NmbrOfSlsDocWithRecmdnField
_RecommendationLog _RecommendationLog
_SalesDocument _SalesDocument
_SalesDocumentType _SalesDocumentType
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_OrganizationDivision _OrganizationDivision
_SlsDocDataCompletenessStatus _SlsDocDataCompletenessStatus
_OverallSDProcessStatus _SalesDocument _OverallSDProcessStatus

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 C_SlsDocAutocompletionLog.
-- 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 C_SlsDocAutocompletionLog AS
SELECT
  SalesDocument,
  SalesDocumentType,
  _SalesDocumentType._Text[1: Language=$session.system_language].SalesDocumentTypeName AS SalesDocumentTypeName,
  SalesOrganization,
  _SalesOrganization._Text[1: Language=$session.system_language].SalesOrganizationName AS SalesOrganizationName,
  DistributionChannel,
  _DistributionChannel._Text[1: Language=$session.system_language].DistributionChannelName AS DistributionChannelName,
  OrganizationDivision,
  _OrganizationDivision._Text[1: Language=$session.system_language].DivisionName AS DivisionName,
  _SalesDocument.SoldToParty AS SoldToParty,
  _SalesDocument._SoldToParty.CustomerName AS CustomerName,
  _SalesDocument.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _SalesDocument.SalesDocumentDate AS SalesDocumentDate,
  _SalesDocument.RequestedDeliveryDate AS RequestedDeliveryDate,
  _SalesDocument.OverallSDProcessStatus AS OverallSDProcessStatus,
  _SalesDocument._OverallSDProcessStatus._Text[ 1: Language = $session.system_language ].OverallSDProcessStatusDesc AS OverallSDProcessStatusDesc,
  _SalesDocument.LastChangedByUser AS LastChangedByUser,
  _SalesDocument._LastChangedByUser.UserDescription AS UserDescription,
  SlsDocDataCompletenessStatus,
  _SlsDocDataCompletenessStatus._Text[1: Language=$session.system_language].SlsDocDataCmpltnsStatusText AS SlsDocDataCmpltnsStatusText,
  NmbrOfSlsDocRecmdnAccptdField,
  NmbrOfSlsDocMnlChangedField,
  NmbrOfSlsDocWithRecmdnField,
  _SalesDocument._OverallSDProcessStatus AS _OverallSDProcessStatus
FROM I_SlsDocAutocompletionLog AS AutocompletionLog
LEFT OUTER JOIN C_SlsDocFieldRecommendationLog AS _RecommendationLog ON SalesDocument = _RecommendationLog.SalesDocument  -- association [1..*]
LEFT OUTER JOIN I_SlsDocDataCompletenessStatus AS _SlsDocDataCompletenessStatus ON SlsDocDataCompletenessStatus = _SlsDocDataCompletenessStatus.SlsDocDataCompletenessStatus  -- association [0..1]
;

Learn More