I_CycleCountingSettings

DDL: I_CYCLECOUNTINGSETTINGS Type: view BASIC
6 Fields 1 Data Sources

Cycle Counting Settings exposed

I_CycleCountingSettings is a Basic CDS View that provides data about "Cycle Counting Settings exposed" in SAP S/4HANA. It reads from 1 data source (t159c) and exposes 6 fields with key fields Plant, CycleCountType.

SAP Help Documentation

CategoryCDS Views for Physical Inventory
Purpose
The CDS view provides the configuration settings for the physical inventory process of cycle counting. You define the individual cycle counting indicators for the given plant. Cycle counting indicators categorize materials into specific groups. This CDS view provides the data to answer the following business questions: Which plants are eligible for cycle counting? What cycle counting types are available for each plant? How frequently are materials counted each year? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: M_MSEG_WMB (Material Documents: Plant)

Structure
Important Fields Important fields in this view include the following: Field Name Description Plant Plant CycleCountType Cycle Counting Type NmbrOfPhysInvtryPerFiscalYear Number of Cycle Counts per Fiscal Year PhysInvtryIntvlForCycCounting Cycle Counting Interval PhysInvtryFloatTimeCycCounting Cycle Counting Float Time ConfigDeprecationCode Deprecated Entries

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
t159c t159c from

Annotations (22)

NameValueLevelField
AbapCatalog.sqlViewName ICYCCOUNTSET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 2 view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Cycle Counting Settings exposed view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey CycleCountType view
ObjectModel.sapObjectNodeType.name PhysInvtryCycleCntImportance view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
VDM.private false view
VDM.viewType #BASIC view
Search.searchable true view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Plant werks Receiving Plant
KEY CycleCountType CC Phys. Inv.
NmbrOfPhysInvtryPerFiscalYear No.of phys.inv.
PhysInvtryIntvlForCycCounting Ph.inv.interval
PhysInvtryFloatTimeCycCounting Float time
ConfigDeprecationCode Validity

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CycleCountingSettings.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_CycleCountingSettings AS
SELECT
  werks AS Plant,
  cast( abcin as mmim_cycle_count_type ) AS CycleCountType,
  cast( aninv as mmim_cycle_count_per_fisc_year ) AS NmbrOfPhysInvtryPerFiscalYear,
  cast( ininv as mmim_cycle_count_interval ) AS PhysInvtryIntvlForCycCounting,
  cast( pzinv as mmim_cycle_count_float_time ) AS PhysInvtryFloatTimeCycCounting,
  cast( configurationdeprecationcode as config_deprecation_code ) AS ConfigDeprecationCode
FROM t159c
;

Learn More