I_SalesOffice

DDL: I_SALESOFFICE SQL: ISDSALESOFFICE Type: view BASIC

Sales Office

I_SalesOffice is a Basic CDS View (Dimension) that provides data about "Sales Office" in SAP S/4HANA. It reads from 1 data source (tvbur) and exposes 2 fields with key field SalesOffice. It has 1 association to related views. It is exposed through 7 OData services (C_SALESORDERMANAGE_SD, UI_CREDITMEMOREQUESTMANAGE, UI_CUSTOMERRETURNMANAGE, ...). It is used in 2 Fiori applications: Monitor Sales Order Progress - Fashion, Manage Provisional Sales Contracts - Fashion.

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

Data Sources (1)

SourceAliasJoin Type
tvbur tvbur from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SalesOfficeText _Text $projection.SalesOffice = _Text.SalesOffice

Annotations (19)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey SalesOffice view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Sales Office view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDSALESOFFICE view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.preserveKey true view
Metadata.allowExtensions true view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
Consumption.ranked true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

OData Services (7)

ServiceBindingVersionContractRelease
C_SALESORDERMANAGE_SD C_SALESORDERMANAGE_SRV V4 C1 NOT_RELEASED
UI_CREDITMEMOREQUESTMANAGE UI_CREDITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_CUSTOMERRETURNMANAGE UI_CUSTOMERRETURNMANAGE 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
UI_SALESQUOTATIONMANAGE UI_SALESQUOTATIONMANAGE 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 (2)

KeyFieldSource TableSource FieldDescription
KEY SalesOffice vkbur
_Text _Text 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'SalesOffice'
@ObjectModel.usageType.dataClass: #ORGANIZATIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Sales Office'
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ISDSALESOFFICE'
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@AbapCatalog.preserveKey: true
@Metadata.allowExtensions: true
@AbapCatalog.compiler.compareFilter: true
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true
@Consumption.ranked: true
@ObjectModel.modelingPattern:           #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities:  [  #SQL_DATA_SOURCE,
                                        #CDS_MODELING_DATA_SOURCE,
                                        #CDS_MODELING_ASSOCIATION_TARGET,
                                        #ANALYTICAL_DIMENSION, 
                                        #SEARCHABLE_ENTITY  ]
define view I_SalesOffice 
as select from tvbur
association [0..*] to I_SalesOfficeText  as _Text on $projection.SalesOffice = _Text.SalesOffice
{   
    @Search.defaultSearchElement: true
    @Search.ranking: #HIGH
    @Search.fuzzinessThreshold: 0.8
    @ObjectModel.text.association: '_Text'
    key vkbur as SalesOffice,
    _Text
};

Learn More