I_OperationDateOffsetRefCode

DDL: I_OPERATIONDATEOFFSETREFCODE SQL: IPPOPDATREFCD Type: view BASIC
2 Fields 1 Data Sources 1 Associations

Operation Date Offset Reference Code

I_OperationDateOffsetRefCode (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

BOOOpDateOffsetRefCode · Manufacturing

I_OperationDateOffsetRefCode is a Basic CDS View (Dimension) that provides data about "Operation Date Offset Reference Code" in SAP S/4HANA. It reads from 1 data source (tca54) and exposes 2 fields with key field OperationDateOffsetRefCode. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM-MD
CapabilitiesAnalytical Dimension, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Search, Data Provider for Value Help, Data Source for Data Extraction
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which operation date offset reference codes are maintained?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
tca54 tca54 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_OperationDateOffstRefCodeTxt _Text $projection.OperationDateOffsetRefCode = _Text.OperationDateOffsetRefCode

Annotations (22)

NameValueLevelField
AbapCatalog.sqlViewName IPPOPDATREFCD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.numberOfKeyFields 000 view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey OperationDateOffsetRefCode view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label Operation Date Offset Reference Code view
ObjectModel.sapObjectNodeType.name BOOOpDateOffsetRefCode view
Analytics.dataExtraction.enabled true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY OperationDateOffsetRefCode bzoff Key for Reference Dates Used in Offset Scheduling
_Text _Text

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_OperationDateOffsetRefCode.
-- 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.
-- SQL view name: IPPOPDATREFCD

CREATE VIEW I_OperationDateOffsetRefCode AS
SELECT
  bzoff AS OperationDateOffsetRefCode
FROM tca54
LEFT OUTER JOIN I_OperationDateOffstRefCodeTxt AS _Text ON OperationDateOffsetRefCode = _Text.OperationDateOffsetRefCode  -- association [0..*]
;

Learn More