C_SlsDocChangeDocumentItem

DDL: C_SLSDOCCHANGEDOCUMENTITEM Type: view_entity CONSUMPTION Package: VDM_SD_ANALYTICS
57 Fields 1 Data Sources 2 OData Services

Change Document Item for Sales Document

C_SlsDocChangeDocumentItem is a Consumption CDS View that provides data about "Change Document Item for Sales Document" in SAP S/4HANA. It reads from 1 data source (I_SlsDocChangeDocumentItem) and exposes 57 fields with key fields SalesDocument, ChangeDocument, DatabaseTable, ChangeDocTableKey, ChangeDocItemChangeType. It is exposed through 2 OData services (ASQL_F7356, C_SLSDOCCHANGEDOCUMENTITEM_SD). Part of development package VDM_SD_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
I_SlsDocChangeDocumentItem I_SlsDocChangeDocumentItem from

Annotations (8)

NameValueLevelField
EndUserText.label Change Document Item for Sales Document view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7356 ASQL_F7356 C2 NOT_RELEASED
C_SLSDOCCHANGEDOCUMENTITEM_SD C_SLSDOCCHANGEDOCUMENTITEM_SRV V4 C1 NOT_RELEASED

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
KEY ChangeDocument ChangeDocument Document Number
KEY DatabaseTable DatabaseTable Table Name
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocItemChangeType ChangeDocItemChangeType
ChangeDocObjectClass ChangeDocObjectClass Change Doc. Object
SDDocumentCategory SDDocumentCategory Document Cat.
SDDocumentCategoryName _SDDocumentCategoryText SDDocumentCategoryName
SalesDocumentType SalesDocumentType Sales Doc. Type
SalesDocumentTypeName _SalesDocumentTypeText SalesDocumentTypeName
SalesOrganization SalesOrganization Sales Organization
SalesOrganizationName _SalesOrganizationText SalesOrganizationName Sales Organization Description
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
DistributionChannelName _DistributionChannelText DistributionChannelName
OrganizationDivision OrganizationDivision Org. Division
DivisionName _DivisionText DivisionName Division Description
SoldToParty SoldToParty Sold-to Party
ChangeDocPreviousUnit ChangeDocPreviousUnit
ChangeDocNewUnit ChangeDocNewUnit
ChangeDocPreviousCurrency ChangeDocPreviousCurrency
ChangeDocNewCurrency ChangeDocNewCurrency
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue
ChangedFieldFormattedOldValue
ChangeDocNewFieldValue ChangeDocNewFieldValue
ChangedFieldFormattedNewValue
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CreationDateTime CreationDateTime Timestamp
SalesDocumentItem SalesDocumentItem Sales Document Item
ScheduleLine ScheduleLine Schedule Line
PartnerFunction PartnerFunction Partner Functn
PartnerFunctionName _PartnerFunctionText PartnerFunctionName Name
SDPricingProcedure SDPricingProcedure Pric. Procedure
ConditionType ConditionType Condition type
ConditionTypeName _ConditionTypeText ConditionTypeName Name
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
DatabaseTableText DatabaseTableText User Group
TableChangeLogTableFieldLabel
DatabaseTableFieldText DatabaseTableFieldText
ABAPLongFieldLabel ABAPLongFieldLabel
ABAPMediumFieldLabel ABAPMediumFieldLabel
ABAPShortFieldLabel ABAPShortFieldLabel
CustomerName CustomerName Name of Customer
CreatedByUserName _CreatedByUser UserDescription Full Name
SalesDocumentChangeDescription
SemanticObject
SalesDocumentChangeIsHidden
BusinessSolutionOrder BusinessSolutionOrder Solution Order
_ChangeTypeText _ChangeTypeText
_SDDocumentCategoryText _SDDocumentCategoryText
_SalesDocumentTypeText _SalesDocumentTypeText
_SalesOrganizationText _SalesOrganizationText
_DistributionChannelText _DistributionChannelText
_DivisionText _DivisionText
_PartnerFunctionText _PartnerFunctionText
_ConditionTypeText _ConditionTypeText

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_SlsDocChangeDocumentItem.
-- 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_SlsDocChangeDocumentItem AS
SELECT
  SalesDocument,
  ChangeDocument,
  DatabaseTable,
  ChangeDocTableKey,
  ChangeDocItemChangeType,
  ChangeDocObjectClass,
  SDDocumentCategory,
  _SDDocumentCategoryText.SDDocumentCategoryName AS SDDocumentCategoryName,
  SalesDocumentType,
  _SalesDocumentTypeText.SalesDocumentTypeName AS SalesDocumentTypeName,
  SalesOrganization,
  _SalesOrganizationText.SalesOrganizationName AS SalesOrganizationName,
  DistributionChannel,
  _DistributionChannelText.DistributionChannelName AS DistributionChannelName,
  OrganizationDivision,
  _DivisionText.DivisionName AS DivisionName,
  SoldToParty,
  ChangeDocPreviousUnit,
  ChangeDocNewUnit,
  ChangeDocPreviousCurrency,
  ChangeDocNewCurrency,
  ChangeDocPreviousFieldValue,
  cast( '' as cdfldvalo ) AS ChangedFieldFormattedOldValue,
  ChangeDocNewFieldValue,
  cast( '' as cdfldvaln ) AS ChangedFieldFormattedNewValue,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CreationDateTime,
  SalesDocumentItem,
  ScheduleLine,
  PartnerFunction,
  _PartnerFunctionText.PartnerFunctionName AS PartnerFunctionName,
  SDPricingProcedure,
  ConditionType,
  _ConditionTypeText.ConditionTypeName AS ConditionTypeName,
  PurchaseOrderByCustomer,
  DatabaseTableText,
  cast( '' as scrtext_l ) AS TableChangeLogTableFieldLabel,
  DatabaseTableFieldText,
  ABAPLongFieldLabel,
  ABAPMediumFieldLabel,
  ABAPShortFieldLabel,
  CustomerName,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  cast( '' as sls_doc_chg_desc ) AS SalesDocumentChangeDescription,
  cast( '' as semanticobject ) AS SemanticObject,
  cast( '' as sls_doc_chg_is_hidn ) AS SalesDocumentChangeIsHidden,
  BusinessSolutionOrder
FROM I_SlsDocChangeDocumentItem
;

Learn More