I_ORDERMISSINGPARTBASIC
Missing Parts of Orders
I_ORDERMISSINGPARTBASIC is a CDS View in S/4HANA. Missing Parts of Orders. It contains 8 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_OrderMissingPart | view_entity | from | COMPOSITE | Missing Parts of Orders |
Fields (8)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Reservation | Reservation | 1 |
| KEY | ReservationItem | ReservationItem | 1 |
| KEY | ReservationRecordType | ReservationRecordType | 1 |
| _Order | _Order | 1 | |
| Material | Material | 1 | |
| OrderID | OrderID | 1 | |
| Plant | Plant | 1 | |
| RequirementDate | RequirementDate | 1 |
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Missing Parts of Orders'
// Basic view (FTIND only) for missing parts of any order category
define view entity I_OrderMissingPartBasic
as select from ftind as ftind
association [1..1] to I_LogisticsOrder as _Order on $projection.OrderID = _Order.OrderID
{
key ftind.werks as Plant,
key ftind.matnr as Material,
key ftind.rsnum as Reservation,
key cast(ftind.rspos as pph_rspos preserving type) as ReservationItem,
key cast(ftind.rsart as pph_rsart preserving type) as ReservationRecordType,
cast(ftind.bdter as pph_bdter preserving type) as RequirementDate,
ftind.aufnr as OrderID,
_Order //(for DCLS)
};