I_TotalBlockStatus

DDL: I_TOTALBLOCKSTATUS SQL: ISDTOTBLKSTS Type: view BASIC

Total Block Status

I_TotalBlockStatus is a Basic CDS View (Dimension) that provides data about "Total Block Status" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 3 fields with key field TotalBlockStatus. It has 1 association to related views. It is exposed through 4 OData services (C_SALESORDERMANAGE_SD, UI_RFM_PRVSNLSLSCONTR, UI_RFM_SLSORD_PRGS_MONITOR, ...). It is used in 2 Fiori applications: Monitor Sales Order Progress - Fashion, Manage Provisional Sales Contracts - Fashion.

1 data source(s) Exposed by 4 service(s) Used in 2 Fiori app(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_TotalBlockStatusText _Text $projection.TotalBlockStatus = _Text.TotalBlockStatus

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey TotalBlockStatus view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Total Block Status view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled false view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDTOTBLKSTS view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.resultSet.sizeCategory #XS view
Search.searchable true view
Consumption.ranked true view

OData Services (4)

ServiceBindingVersionContractRelease
C_SALESORDERMANAGE_SD C_SALESORDERMANAGE_SRV V4 C1 NOT_RELEASED
UI_RFM_PRVSNLSLSCONTR UI_RFM_PRVSNLSLSCONTR V2 C1 NOT_RELEASED
UI_RFM_SLSORD_PRGS_MONITOR UI_RFM_SLSORD_PRGS_MONITOR V2 C1 NOT_RELEASED
UI_SALESCONTRACTMANAGE UI_SALESCONTRACTMANAGE V4 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F5392 Monitor Sales Order Progress - Fashion Transactional Monitor Sales Order Progress - Fashion : This app is used to track and further monitor for the different status of the Sales Orders and thereby further actions can be taken accordingly by the business,
F5398 Manage Provisional Sales Contracts - Fashion Transactional Manage Provisional Sales Contracts - Fashion. This is used to create the special types of contracts and the call off

Monitor Sales Order Progress - Fashion

Business Role: Order Fulfillment Specialist (Retail)

With this app, you can monitor the status, that is, the overall progress of account assigned sales orders. This application allows you to identify the conditions based on quantity and status. It checks for exceptions and helps you take informed decisions and necessary actions.

Manage Provisional Sales Contracts - Fashion

Business Role: Order Fulfillment Specialist (Retail)

With this app, you can display the provisional sales contract details at header and generic product levels, so you can get a complete view of different items in these contracts. You can also use this app to create provisional sales contracts as well as create subsequent orders (call-offs) for these contracts.

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY TotalBlockStatus
DomainValue domvalue_l
_Text _Text 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.representativeKey: 'TotalBlockStatus'
@ObjectModel.usageType.dataClass: #META 
@ObjectModel.usageType.serviceQuality: #A 
@ObjectModel.usageType.sizeCategory: #S 
@EndUserText.label: 'Total Block Status'
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: false }
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ISDTOTBLKSTS'
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #ANALYTICAL_DIMENSION ]
@ObjectModel.modelingPattern: [ #ANALYTICAL_DIMENSION ] 
@ObjectModel.resultSet.sizeCategory: #XS
@Search.searchable: true
@Consumption.ranked: true

define view I_TotalBlockStatus
as select from dd07l

association [0..*] to I_TotalBlockStatusText as _Text on $projection.TotalBlockStatus = _Text.TotalBlockStatus
{
    @ObjectModel.text.association: '_Text'
    key substring(dd07l.domvalue_l, 1, 1) as TotalBlockStatus,
    
    @Analytics.hidden: true
    @Consumption.hidden: true
    @Search.defaultSearchElement: true
    @Search.ranking: #HIGH
    domvalue_l as DomainValue,
    
    _Text
}
where (dd07l.domname = 'STATV') and (dd07l.as4local = 'A')
  and ((dd07l.domvalue_l = '') or (dd07l.domvalue_l = 'B') or (dd07l.domvalue_l = 'C'));

Learn More