I_CustMgmtExtRefID

DDL: I_CUSTMGMTEXTREFID Type: view BASIC Package: CRMS4_REPORT

External Reference ID

I_CustMgmtExtRefID is a Basic CDS View that provides data about "External Reference ID" in SAP S/4HANA. It reads from 1 data source (crms4d_ext_ref) and exposes 8 fields with key fields CustMgmtObjectType, CustMgmtDocument, CustMgmtDocumentItem, CustMgmtExtRefIDSequenceNumber. Part of development package CRMS4_REPORT.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
crms4d_ext_ref crms4d_ext_ref from

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label External Reference ID view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName ICUSTMGTEXTREFID view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CustMgmtObjectType objtype_h
KEY CustMgmtDocument object_id
KEY CustMgmtDocumentItem number_int
KEY CustMgmtExtRefIDSequenceNumber counter
CustMgmtExtRefIDType reference_type
CustMgmtExtRefID reference_number
CustMgmtExtRefIDTypeOwner owner
CustMgmtExtRefIDLogicalSystem reference_logsys 
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'External Reference ID'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ICUSTMGTEXTREFID',
  compiler.compareFilter: true,
  preserveKey: true
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}

@Metadata.ignorePropagatedAnnotations: true

define view I_CustMgmtExtRefID
  as select from crms4d_ext_ref
{
  key objtype_h                                   as CustMgmtObjectType,
  key object_id                                   as CustMgmtDocument,
  key number_int                                  as CustMgmtDocumentItem,
  key counter                                     as CustMgmtExtRefIDSequenceNumber,

      reference_type                              as CustMgmtExtRefIDType,
      reference_number                            as CustMgmtExtRefID,
      owner                                       as CustMgmtExtRefIDTypeOwner,
      reference_logsys                            as CustMgmtExtRefIDLogicalSystem
}

Learn More