I_SlsDocFldRecmdnLogBasic

DDL: I_SLSDOCFLDRECMDNLOGBASIC Type: view_entity BASIC Package: VDM_SD_SLS_AUTOCOMPLTN
21 Fields 1 Data Sources 1 Associations

Recommendation Log of Sales Doc Field

I_SlsDocFldRecmdnLogBasic is a Basic CDS View that provides data about "Recommendation Log of Sales Doc Field" in SAP S/4HANA. It reads from 1 data source (sdac_log) and exposes 21 fields with key field SlsDocFldRecommendationLogUUID. It has 1 association to related views. Part of development package VDM_SD_SLS_AUTOCOMPLTN.

Data Sources (1)

SourceAliasJoin Type
sdac_log sdac_log from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SalesDocument _SalesDocument $projection.SalesDocument = _SalesDocument.SalesDocument

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Recommendation Log of Sales Doc Field view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SlsDocFldRecommendationLogUUID slsdocautomcompltnlguuid
SalesDocument salesdocument SD Document
SalesDocumentItem salesdocumentitem Sales Document Item
DatabaseTableFieldName databasetablefieldname
DatabaseTable databasetable Table Name
SlsDocInferenceObjectUUID inferenceobjectuuid
SlsDocumentInferenceFieldName inferencefieldname
SlsDocRecommendationFieldName salesdocumentglobalfieldname
SalesDocumentFieldValue currentfieldvalue
SlsDocRecmdnProbability currentfieldvalueprobability
LastChangeDateTime fieldlastchangedatetime Last Changed On
LastChangedByUser fieldlastchangedbyuser Last Changed By
CreationDate _SalesDocument CreationDate Time Stamp
CreationTime _SalesDocument CreationTime Time of Change
CreatedByUser _SalesDocument CreatedByUser User Name
SalesDocumentType _SalesDocument SalesDocumentType Sales Doc. Type
SalesOrganization _SalesDocument SalesOrganization Sales Organization
DistributionChannel _SalesDocument DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesDocument OrganizationDivision Org. Division
SlsDocFldRecommendationStatus fieldrecommendationstatus
_SalesDocument _SalesDocument

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_SlsDocFldRecmdnLogBasic.
-- 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_SlsDocFldRecmdnLogBasic AS
SELECT
  slsdocautomcompltnlguuid AS SlsDocFldRecommendationLogUUID,
  SalesDocument,
  SalesDocumentItem,
  DatabaseTableFieldName,
  DatabaseTable,
  inferenceobjectuuid AS SlsDocInferenceObjectUUID,
  inferencefieldname AS SlsDocumentInferenceFieldName,
  salesdocumentglobalfieldname AS SlsDocRecommendationFieldName,
  currentfieldvalue AS SalesDocumentFieldValue,
  currentfieldvalueprobability AS SlsDocRecmdnProbability,
  fieldlastchangedatetime AS LastChangeDateTime,
  fieldlastchangedbyuser AS LastChangedByUser,
  _SalesDocument.CreationDate AS CreationDate,
  _SalesDocument.CreationTime AS CreationTime,
  _SalesDocument.CreatedByUser AS CreatedByUser,
  _SalesDocument.SalesDocumentType AS SalesDocumentType,
  _SalesDocument.SalesOrganization AS SalesOrganization,
  _SalesDocument.DistributionChannel AS DistributionChannel,
  _SalesDocument.OrganizationDivision AS OrganizationDivision,
  fieldrecommendationstatus AS SlsDocFldRecommendationStatus
FROM sdac_log
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [1..1]
;

Learn More