I_SlsDocChangeDocumentItem

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_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 I_SlsDocChangeDocumentItem AS
SELECT
  SlsDocChangeDocumentItem.SalesDocument AS SalesDocument,
  SlsDocChangeDocumentItem.ChangeDocument AS ChangeDocument,
  SlsDocChangeDocumentItem.DatabaseTable AS DatabaseTable,
  SlsDocChangeDocumentItem.ChangeDocTableKey AS ChangeDocTableKey,
  SlsDocChangeDocumentItem.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  SlsDocChangeDocumentItem.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  SlsDocChangeDocumentItem.ChangeDocObjectClass AS ChangeDocObjectClass,
  SlsDocChangeDocumentItem.SDDocumentCategory AS SDDocumentCategory,
  SlsDocChangeDocumentItem.SalesDocumentType AS SalesDocumentType,
  SlsDocChangeDocumentItem.SalesOrganization AS SalesOrganization,
  SlsDocChangeDocumentItem.DistributionChannel AS DistributionChannel,
  SlsDocChangeDocumentItem.OrganizationDivision AS OrganizationDivision,
  SlsDocChangeDocumentItem.SoldToParty AS SoldToParty,
  cast( SlsDocChangeDocumentItem._ChangeDocument.CreatedByUser as changd_by preserving type ) AS CreatedByUser,
  cast( SlsDocChangeDocumentItem._ChangeDocument.CreationDate as aedat preserving type ) AS CreationDate,
  SlsDocChangeDocumentItem._ChangeDocument.CreationTime AS CreationTime,
  cast( dats_tims_to_tstmp( SlsDocChangeDocumentItem._ChangeDocument.CreationDate, SlsDocChangeDocumentItem._ChangeDocument.CreationTime, abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' ) as timestamp ) as CreationDateTime AS clientNULLastimestampasCreationDateTime,
  SlsDocChangeDocumentItem.ChangeDocPreviousUnit AS ChangeDocPreviousUnit,
  SlsDocChangeDocumentItem.ChangeDocNewUnit AS ChangeDocNewUnit,
  SlsDocChangeDocumentItem.ChangeDocPreviousCurrency AS ChangeDocPreviousCurrency,
  SlsDocChangeDocumentItem.ChangeDocNewCurrency AS ChangeDocNewCurrency,
  SlsDocChangeDocumentItem.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  SlsDocChangeDocumentItem.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  SlsDocChangeDocumentItem.SalesDocumentItem AS SalesDocumentItem,
  SlsDocChangeDocumentItem.SDPricingProcedure AS SDPricingProcedure,
  SlsDocChangeDocumentItem.ScheduleLine AS ScheduleLine,
  SlsDocChangeDocumentItem.PartnerFunction AS PartnerFunction,
  SlsDocChangeDocumentItem.ConditionType AS ConditionType,
  SlsDocChangeDocumentItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SlsDocChangeDocumentItem.BusinessSolutionOrder AS BusinessSolutionOrder,
  _TableNameText.Text AS DatabaseTableText,
  _FieldNameText.ABAPLongFieldLabel AS ABAPLongFieldLabel,
  _FieldNameText.ABAPMediumFieldLabel AS ABAPMediumFieldLabel,
  _FieldNameText.ABAPShortFieldLabel AS ABAPShortFieldLabel,
  _FieldNameText.DatabaseTableFieldText AS DatabaseTableFieldText,
  _SalesDocument._SoldToParty.CustomerName AS CustomerName
FROM I_SlsDocChgDocumentItemBasic AS SlsDocChangeDocumentItem
LEFT OUTER JOIN I_SDDocumentCategoryText AS _SDDocumentCategoryText ON SDDocumentCategory = _SDDocumentCategoryText.SDDocumentCategory AND _SDDocumentCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentTypeText AS _SalesDocumentTypeText ON SalesDocumentType = _SalesDocumentTypeText.SalesDocumentType AND _SalesDocumentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocChangeIndT AS _ChangeTypeText ON ChangeDocItemChangeType = _ChangeTypeText.Value AND _ChangeTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocTableNames AS _TableNameText ON DatabaseTable = _TableNameText.Value AND _TableNameText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SlsDocChgDocumentFieldName AS _FieldNameText ON _FieldNameText.DatabaseTable = DatabaseTable AND _FieldNameText.DatabaseTableField = ChangeDocDatabaseTableField AND _FieldNameText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON SalesOrganization = _SalesOrganizationText.SalesOrganization AND _SalesOrganizationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannelText AS _DistributionChannelText ON DistributionChannel = _DistributionChannelText.DistributionChannel AND _DistributionChannelText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DivisionText AS _DivisionText ON OrganizationDivision = _DivisionText.Division AND _DivisionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ConditionTypeText AS _ConditionTypeText ON ConditionType = _ConditionTypeText.ConditionType AND _ConditionTypeText.Language = $session.system_language AND _ConditionTypeText.ConditionUsage = 'A' AND _ConditionTypeText.ConditionApplication = 'V'  -- association [0..1]
LEFT OUTER JOIN I_PartnerFunctionText AS _PartnerFunctionText ON PartnerFunction = _PartnerFunctionText.PartnerFunction AND _PartnerFunctionText.Language = $session.system_language  -- association [0..1]
;