I_ServiceDocumentItemPrdcssr
Service Document Item Predecessor
I_ServiceDocumentItemPrdcssr is a Basic CDS View that provides data about "Service Document Item Predecessor" in SAP S/4HANA. It reads from 1 data source (crmd_brelvonai) and exposes 20 fields with key fields ServiceDocumentItmRelationUUID, ServiceDocItmRltnSqncNumber. It has 3 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| crmd_brelvonai | crmd_brelvonai | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1] | I_ServiceDocumentItemEnhcd | _ServiceDocItm | $projection.ServiceDocumentItmPrdcssrUUID = _ServiceDocItm.ServiceDocumentItemUUID and $projection.ServiceDocItmPrdcssrBusObjType = _ServiceDocItm.ServiceDocumentItemObjectType |
| [0..1] | I_UnitOfMeasure | _BaseUnit | $projection.SrvcDocItmDocFlowQuantityUnit = _BaseUnit.UnitOfMeasure |
| [0..1] | I_Currency | _TransactionCurrency | $projection.SrvcDocItmDocFlowCurrency = _TransactionCurrency.Currency |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Service Document Item Predecessor | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #BASIC | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| VDM.lifecycle.status | #DEPRECATED | view | |
| VDM.lifecycle.successor | I_ServiceDocumentItemPrdcssr_2 | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AbapCatalog.sqlViewName | ISERVDOCITMPRE | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (20)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ServiceDocumentItmRelationUUID | relationid | ||
| KEY | ServiceDocItmRltnSqncNumber | posno | ||
| ServiceDocItmPrdcssrCharUUID | objkey_a | |||
| ServiceDocumentItemCharUUID | objkey_b | |||
| ServiceDocumentItmRelationType | breltyp | |||
| CharcLength | ||||
| ServiceDocumentItmPrdcssrUUID | ||||
| ServiceDocItmPrdcssrBusObjType | objtype_a | |||
| ServiceDocumentItmRelationKind | vona_kind | |||
| ServiceDocumentItemUUID | ||||
| ServiceDocumentItemObjectType | objtype_b | |||
| SrvcDocItmDocFlowQuantityUnit | quantity_unit | |||
| SrvcDocItmDocFlowQuantity | quantity | |||
| SrvcDocItmDocFlowCurrency | currency | |||
| SrvcDocumentItmDocFlowAmount | value | |||
| SrvcDocItmDocFlowBillingInfo | doc_info | |||
| SrvcDocItmDocFlowQtyIsDiffnt | qty_difference | |||
| _ServiceDocItm | _ServiceDocItm | |||
| _TransactionCurrency | _TransactionCurrency | |||
| _BaseUnit | _BaseUnit |
@EndUserText.label: 'Service Document Item Predecessor'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #PUBLIC_LOCAL_API,
lifecycle.status: #DEPRECATED,
lifecycle.successor: 'I_ServiceDocumentItemPrdcssr_2'
}
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
sqlViewName: 'ISERVDOCITMPRE',
compiler.compareFilter: true ,
preserveKey: true
}
@ObjectModel: {
// representativeKey: 'ServiceDocumentItmRelationUUID',
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #B,
sizeCategory: #XL
}
}
//@Analytics.dataCategory: #DIMENSION
//@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations: true
/*
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.
*/
/* !!!DONOT USE THIS VIEW. SOON IT IS GOING TO BE DEPRECATED!!! */
define view I_ServiceDocumentItemPrdcssr
as select from crmd_brelvonai
association [1] to I_ServiceDocumentItemEnhcd as _ServiceDocItm on $projection.ServiceDocumentItmPrdcssrUUID = _ServiceDocItm.ServiceDocumentItemUUID
and $projection.ServiceDocItmPrdcssrBusObjType = _ServiceDocItm.ServiceDocumentItemObjectType
association [0..1] to I_UnitOfMeasure as _BaseUnit on $projection.SrvcDocItmDocFlowQuantityUnit = _BaseUnit.UnitOfMeasure
association [0..1] to I_Currency as _TransactionCurrency on $projection.SrvcDocItmDocFlowCurrency = _TransactionCurrency.Currency
{
key relationid as ServiceDocumentItmRelationUUID,
key posno as ServiceDocItmRltnSqncNumber,
objkey_a as ServiceDocItmPrdcssrCharUUID,
objkey_b as ServiceDocumentItemCharUUID,
breltyp as ServiceDocumentItmRelationType,
/* CRMT_BRELVONAI */
length(objkey_a) as CharcLength,
hextobin(objkey_a) as ServiceDocumentItmPrdcssrUUID,
objtype_a as ServiceDocItmPrdcssrBusObjType,
vona_kind as ServiceDocumentItmRelationKind,
hextobin(objkey_b) as ServiceDocumentItemUUID,
objtype_b as ServiceDocumentItemObjectType,
@ObjectModel.foreignKey.association: '_BaseUnit'
@Semantics.unitOfMeasure:true
quantity_unit as SrvcDocItmDocFlowQuantityUnit,
//@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'SrvcDocItmDocFlowQuantityUnit'} }
quantity as SrvcDocItmDocFlowQuantity,
// @ObjectModel.foreignKey.association: '_TransactionCurrency'
@API.element.releaseState: #DEPRECATED
@Semantics.currencyCode:true
currency as SrvcDocItmDocFlowCurrency,
@API.element.releaseState: #DEPRECATED
@Semantics: { amount : {currencyCode: 'SrvcDocItmDocFlowCurrency'} }
value as SrvcDocumentItmDocFlowAmount,
doc_info as SrvcDocItmDocFlowBillingInfo,
qty_difference as SrvcDocItmDocFlowQtyIsDiffnt,
//Associations
_ServiceDocItm,
_TransactionCurrency,
_BaseUnit
}
where
objtype_a like 'BUS2000%'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CRMD_BRELVONAI"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_SERVICEDOCUMENTITEMENHCD",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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