C_FldLogsToBeReceivedItmTypeTP
Projection View for To be Received by Item Type
C_FldLogsToBeReceivedItmTypeTP is a Consumption CDS View that provides data about "Projection View for To be Received by Item Type" in SAP S/4HANA. It reads from 1 data source (I_FldLogsDateFuncVH) and exposes 13 fields with key field FldLogsSuplrItemUUID. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_FldLogsDateFuncVH | I_FldLogsDateFuncVH | from |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_DateFunction | datefunctionid |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_FldLogsToBeReceivedItmType | _ReceivedItmType | ( _ReceivedItmType.DeliveryDate >= _DateFunVH.StartDate and _ReceivedItmType.DeliveryDate <= _DateFunVH.EndDate ) |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| EndUserText.label | Projection View for To be Received by Item Type | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| VDM.viewType | #CONSUMPTION | view |
Fields (13)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | FldLogsSuplrItemUUID | |||
| CalendarDate | CalendarDate | |||
| FirstDayOfWeekDate | FirstDayOfWeekDate | |||
| StartDate | StartDate | |||
| EndDate | EndDate | |||
| FldLogsItemType | ||||
| DeliveryDate | ||||
| FldLogsNumberOfItmsToBeRcvd | ||||
| Plant | ||||
| Supplier | ||||
| Material | ||||
| FldLogsPurOrdItem | ||||
| _ItemTypeText | _ItemTypeText |
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Projection View for To be Received by Item Type'
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #M,
dataClass: #MIXED
}
@VDM.viewType: #CONSUMPTION
define view entity C_FldLogsToBeReceivedItmTypeTP
with parameters
P_DateFunction : datefunctionid
as select from I_FldLogsDateFuncVH ( P_DateFunction :$parameters.P_DateFunction ) as _DateFunVH
association [0..1] to I_FldLogsToBeReceivedItmType as _ReceivedItmType on (
_ReceivedItmType.DeliveryDate >= _DateFunVH.StartDate
and _ReceivedItmType.DeliveryDate <= _DateFunVH.EndDate
)
association to I_FldLogsItemTypeVH as _ItemTypeText on $projection.fldlogsitemtype = _ItemTypeText.FldLogsItemType
and _ItemTypeText.Language = $session.system_language
{
key _ReceivedItmType( P_DateFunction : $parameters.P_DateFunction ).FldLogsSuplrItemUUID,
CalendarDate,
FirstDayOfWeekDate,
StartDate,
EndDate,
@ObjectModel.text.association: '_ItemTypeText'
_ReceivedItmType( P_DateFunction : $parameters.P_DateFunction ).FldLogsItemType,
_ReceivedItmType( P_DateFunction : $parameters.P_DateFunction ).DeliveryDate,
@DefaultAggregation: #SUM
_ReceivedItmType( P_DateFunction : $parameters.P_DateFunction ).FldLogsNumberOfItmsToBeRcvd,
_ReceivedItmType( P_DateFunction : $parameters.P_DateFunction ).Plant,
_ReceivedItmType( P_DateFunction : $parameters.P_DateFunction ).Supplier,
_ReceivedItmType( P_DateFunction : $parameters.P_DateFunction ).Material,
_ReceivedItmType( P_DateFunction : $parameters.P_DateFunction ).FldLogsPurOrdItem,
_ItemTypeText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FLDLOGSDATEFUNCVH",
"I_FLDLOGSTOBERECEIVEDITMTYPE"
],
"ASSOCIATED":
[
"I_FLDLOGSITEMTYPEVH"
],
"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