I_SDDocumentIncompletionLog

DDL: I_SDDOCUMENTINCOMPLETIONLOG Type: view BASIC
11 Fields 1 Data Sources 2 Associations

SD Document Incompletion Log

I_SDDocumentIncompletionLog is a Basic CDS View that provides data about "SD Document Incompletion Log" in SAP S/4HANA. It reads from 1 data source (vbuv) and exposes 11 fields with key fields SDDocument, SDDocumentItem, ScheduleLine, PartnerFunction, SDDocumentTextID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
vbuv vbuv from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SalesDocumentScheduleLine _ScheduleLine $projection.SDDocument = _ScheduleLine.SalesDocument and $projection.SDDocumentItem = _ScheduleLine.SalesDocumentItem and $projection.ScheduleLine = _ScheduleLine.ScheduleLine
[0..1] I_PartnerFunction _PartnerFunction $projection.PartnerFunction = _PartnerFunction.PartnerFunction

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName ISDDOCINCMPLTLOG view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label SD Document Incompletion Log view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SDDocument vbeln SD Sched. Agmt
KEY SDDocumentItem posnr WBS Element
KEY ScheduleLine etenr Schedule Line
KEY PartnerFunction parvw Task Processor
KEY SDDocumentTextID tdid Text ID Header
KEY SDDocumentTable tbnam Tables
KEY SDDocumentTableField fdnam Field name
IncompletionProcedure fehgr Incompl.Proced.
IncompletionStatusGroup statg Status Group
_ScheduleLine _ScheduleLine
_PartnerFunction _PartnerFunction

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_SDDocumentIncompletionLog.
-- 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_SDDocumentIncompletionLog AS
SELECT
  vbeln AS SDDocument,
  posnr AS SDDocumentItem,
  etenr AS ScheduleLine,
  parvw AS PartnerFunction,
  tdid AS SDDocumentTextID,
  tbnam AS SDDocumentTable,
  fdnam AS SDDocumentTableField,
  fehgr AS IncompletionProcedure,
  statg AS IncompletionStatusGroup
FROM vbuv
LEFT OUTER JOIN I_SalesDocumentScheduleLine AS _ScheduleLine ON SDDocument = _ScheduleLine.SalesDocument AND SDDocumentItem = _ScheduleLine.SalesDocumentItem AND ScheduleLine = _ScheduleLine.ScheduleLine  -- association [1..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON PartnerFunction = _PartnerFunction.PartnerFunction  -- association [0..1]
;

Learn More