I_SlsDocChgDocumentItemBasic

DDL: I_SLSDOCCHGDOCUMENTITEMBASIC Type: view_entity COMPOSITE Package: VDM_SD_ANALYTICS

Change Document Item for Sales Document

I_SlsDocChgDocumentItemBasic is a Composite CDS View that provides data about "Change Document Item for Sales Document" in SAP S/4HANA. It reads from 1 data source (I_ChangeDocumentItem) and exposes 28 fields with key fields ChangeDocObject, ChangeDocument, DatabaseTable, ChangeDocTableKey, ChangeDocDatabaseTableField. It has 1 association to related views. Part of development package VDM_SD_ANALYTICS.

1 data source(s) 28 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from

Associations (1)

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

Annotations (7)

NameValueLevelField
EndUserText.label Change Document Item for Sales Document view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject ChangeDocObject
KEY ChangeDocument ChangeDocument
KEY DatabaseTable DatabaseTable
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType ChangeDocItemChangeType
ChangeDocObjectClass ChangeDocObjectClass
ChangeDocPreviousUnit ChangeDocPreviousUnit
ChangeDocNewUnit ChangeDocNewUnit
ChangeDocPreviousCurrency ChangeDocPreviousCurrency
ChangeDocNewCurrency ChangeDocNewCurrency
ChangeDocNewFieldValue ChangeDocNewFieldValue
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue
SalesDocument _SalesDocument SalesDocument
SDDocumentCategory _SalesDocument SDDocumentCategory
SalesDocumentType _SalesDocument SalesDocumentType
SalesOrganization _SalesDocument SalesOrganization
DistributionChannel _SalesDocument DistributionChannel
OrganizationDivision _SalesDocument OrganizationDivision
SDPricingProcedure _SalesDocument SDPricingProcedure
SoldToParty _SalesDocument SoldToParty
PurchaseOrderByCustomer _SalesDocument PurchaseOrderByCustomer
BusinessSolutionOrder _SalesDocument BusinessSolutionOrder
_SalesDocument _SalesDocument
_ChangeDocLongTableKey _ChangeDocLongTableKey
_ChangeDocument _ChangeDocument
_ChangeDocumentItemExtension _ChangeDocumentItemExtension
_SoldToParty _SalesDocument _SoldToParty 
@EndUserText.label: 'Change Document Item for Sales Document'
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM: {
  viewType: #COMPOSITE
}
define view entity I_SlsDocChgDocumentItemBasic
  as select from I_ChangeDocumentItem                                                           
  association [0..1] to I_SalesDocument     as _SalesDocument     on  $projection.ChangeDocObject = _SalesDocument.SalesDocument

{
  key ChangeDocObject,
  key ChangeDocument,
  key DatabaseTable,
  key ChangeDocTableKey,
  key ChangeDocDatabaseTableField,
  key ChangeDocItemChangeType,
  
      ChangeDocObjectClass,
      ChangeDocPreviousUnit,
      ChangeDocNewUnit,
      ChangeDocPreviousCurrency,
      ChangeDocNewCurrency,
      ChangeDocNewFieldValue,
      ChangeDocPreviousFieldValue,
      _SalesDocument.SalesDocument,
      _SalesDocument.SDDocumentCategory,
      _SalesDocument.SalesDocumentType,
      _SalesDocument.SalesOrganization,
      _SalesDocument.DistributionChannel,
      _SalesDocument.OrganizationDivision,
      _SalesDocument.SDPricingProcedure,
      _SalesDocument.SoldToParty,
      _SalesDocument.PurchaseOrderByCustomer,
      _SalesDocument.BusinessSolutionOrder,

      cast (
        case DatabaseTable
        when 'KONVC' 
          then substring(ChangeDocTableKey, 1, 6)
        when 'VBAP'
          then substring(ChangeDocTableKey, 14, 6)
        when 'VBEP'
          then substring(ChangeDocTableKey, 14, 6)
        when 'VBKD'
          then substring(ChangeDocTableKey, 14, 6)
        when 'VBPA'
          then substring(ChangeDocTableKey, 14, 6)
        else '000000'
        end as posnr_va )                             as SalesDocumentItem, 

      cast ( 
        case DatabaseTable
        when 'VBEP' 
          then substring(ChangeDocTableKey, 20, 4)
        when 'VBSN' 
          then substring(ChangeDocTableKey, 20, 4)
        else '0000'  
          end as  etenr )                              as ScheduleLine,

      cast ( 
        case DatabaseTable
        when 'VBPA'  then substring(ChangeDocTableKey, 20, 2)
        when 'VBPA2' then substring(ChangeDocTableKey, 20, 2)
        when 'VBPA3' then substring(ChangeDocTableKey, 20, 2)
        else '' end as  parvw_unv )                    as PartnerFunction,

      cast (
        case DatabaseTable
        when 'KONVC' then substring(ChangeDocTableKey, 13, 4)  
        else '' end as kschl preserving type )         as ConditionType,

      /* Associations */
      _SalesDocument,
      _ChangeDocLongTableKey,
      _ChangeDocument,
      _ChangeDocumentItemExtension,
      _SalesDocument._SoldToParty
      
} where ChangeDocObjectClass = 'VERKBELEG' and
  (
       DatabaseTable = 'KONVC' or DatabaseTable = 'VBEP' or DatabaseTable = 'VBAP' 
    or DatabaseTable = 'VBPA'  or DatabaseTable = 'VBKD' or DatabaseTable = 'VBAK'
    or DatabaseTable = 'FPLTC' or DatabaseTable = 'FPLT' or DatabaseTable = 'FPLA'
    or DatabaseTable = 'VBLB'  or DatabaseTable = 'VBSN' or DatabaseTable = 'MSR_SD_CD'
    or DatabaseTable = 'VBPA3' or DatabaseTable = 'VBPA2'
  )

Learn More