I_ServiceDocumentItemPrdcssr_2
Preceding Transaction of Srvc Trans Item
I_ServiceDocumentItemPrdcssr_2 is a Basic CDS View (Fact) that provides data about "Preceding Transaction of Srvc Trans Item" in SAP S/4HANA. It reads from 1 data source (crmd_brelvonai) and exposes 9 fields with key fields ServiceDocumentItmRelationUUID, ServiceDocItmRltnSqncNumber. It has 1 association to related views. Part of development package CRMS4_REPORT.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| crmd_brelvonai | crmd_brelvonai | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1] | I_ServiceDocumentItemEnhcd | _ServiceDocItm | $projection.ServiceDocItmPrdcssrCharUUID = _ServiceDocItm.ServiceDocumentItemCharUUID |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Preceding Transaction of Srvc Trans Item | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #BASIC | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| Analytics.dataCategory | #FACT | view | |
| Analytics.dataExtraction.enabled | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AbapCatalog.sqlViewName | ISERVDOCITMPRE2 | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.sapObjectNodeType.name | ServiceDocumentItemPredecessor | view |
Fields (9)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ServiceDocumentItmRelationUUID | relationid | ||
| KEY | ServiceDocItmRltnSqncNumber | posno | ||
| ServiceDocItmPrdcssrCharUUID | ||||
| ServiceDocumentItemCharUUID | ||||
| ServiceDocumentItmRelationType | breltyp | |||
| ServiceDocItmPrdcssrBusObjType | objtype_a | |||
| ServiceDocumentItmRelationKind | vona_kind | |||
| ServiceDocumentItemObjectType | objtype_b | |||
| _ServiceDocItm | _ServiceDocItm |
@EndUserText.label: 'Preceding Transaction of Srvc Trans Item'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@Analytics: {
dataCategory: #FACT,
dataExtraction: {
enabled: true,
delta.changeDataCapture: {
mapping:[
{
// filter: [{operator: #EQ, tableElement: 'objtype_a', value: 'BUS2000%'}],
table: 'crmd_brelvonai', role: #MAIN,
viewElement: ['ServiceDocumentItmRelationUUID', 'ServiceDocItmRltnSqncNumber'],
tableElement: ['relationid', 'posno']
}
]
}
}
}
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
sqlViewName: 'ISERVDOCITMPRE2',
compiler.compareFilter: true ,
preserveKey: true
}
@ObjectModel: {
// representativeKey: 'ServiceDocumentItmRelationUUID',
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #A,
sizeCategory: #XL
},
supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #EXTRACTION_DATA_SOURCE]
}
//@Analytics.dataCategory: #DIMENSION
//@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations: true
//! Business Object SONT for the Service Document Item Predecessor
@ObjectModel.sapObjectNodeType.name: 'ServiceDocumentItemPredecessor'
/*
1902CE: Data preview might give you an error because hextobin conversion may not work on properly on junk data. Hence dump occurs.
To view the data, you have to apply the condition "CharcLength = 32" to get the results for Service scenario only.
1911CE: DONOT use hextobin converted attribute.
*/
/*
If there is any new Business object addition in service document view (e.g. BUS2000116 )
then the same business object has to be added in DCL "I_ServiceDocumentItemPrdcssr" as well.
*/
define view I_ServiceDocumentItemPrdcssr_2
as select from crmd_brelvonai
association [1] to I_ServiceDocumentItemEnhcd as _ServiceDocItm on $projection.ServiceDocItmPrdcssrCharUUID = _ServiceDocItm.ServiceDocumentItemCharUUID
{
key relationid as ServiceDocumentItmRelationUUID,
key posno as ServiceDocItmRltnSqncNumber,
/* CRMT_BRELVONAI */
cast(objkey_a as crms4_object_charguid32 preserving type ) as ServiceDocItmPrdcssrCharUUID,
cast(objkey_b as crms4_object_charguid32 preserving type ) as ServiceDocumentItemCharUUID,
breltyp as ServiceDocumentItmRelationType,
objtype_a as ServiceDocItmPrdcssrBusObjType,
vona_kind as ServiceDocumentItmRelationKind,
objtype_b as ServiceDocumentItemObjectType,
//Associations
_ServiceDocItm
}
where
objtype_a like 'BUS2000%'
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA