I_MRPREQUESTNOTE
MRP Request Note
I_MRPREQUESTNOTE is a CDS View in S/4HANA. MRP Request Note. It contains 7 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MRPChangeReqNewProposal | view | from | COMPOSITE | |
| I_MRPChangeRequest | view | from | COMPOSITE | MRP Change Request |
| I_MRPChangeRequestCalcValue | view | from | COMPOSITE | |
| I_MRPChangeRequestNote | view | from | TRANSACTIONAL | |
| I_MRPDiscardedChangeRequest | view | from | TRANSACTIONAL | |
| P_MRPChangeRequest | view | from | COMPOSITE |
Fields (7)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ChangeRequestUUID | ChangeRequestUUID | 2 |
| KEY | MRPElement | MRPElement | 1 |
| KEY | MRPElementItem | MRPElementItem | 1 |
| KEY | MRPElementScheduleLine | MRPElementScheduleLine | 1 |
| ChangeRequestNote | ChangeRequestNote | 1 | |
| Material | Material | 1 | |
| SolutionRequestStatus | SolutionRequestStatus | 1 |
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IMRPREQUESTNOTE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl: {
authorizationCheck: #NOT_REQUIRED,
personalData.blocking: #NOT_REQUIRED
}
@ObjectModel: {
usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL },
semanticKey: [ 'ChangeRequestUUID' ]
}
@EndUserText.label: 'MRP Request Note'
@VDM.viewType: #BASIC
define view I_MRPRequestNote
as select from mrp_req_note
{
key request_id as ChangeRequestUUID,
mrpplant as MRPPlant,
matnr as Material,
mrparea as MRPArea,
createdon as CreationDateTime,
crenam as CreatedByUser,
materialgoodsreceiptduration as GoodsReceiptDuration,
mrpelement as MRPElement,
mrpelementitem as MRPElementItem,
mrpelementscheduleline as MRPElementScheduleLine,
mrpplanningsegmentnumber as MRPPlanningSegment,
mrpplanningsegmenttype as MRPPlanningSegmentType,
note as ChangeRequestNote,
status as SolutionRequestStatus,
type as ChangeRequestType,
updatedon as ChangedDateTime,
updnam as LastChangedByUser,
vendor as Supplier,
vendorplant as SupplierPlant,
vendorstatus as MRPRequestSupplierResponse,
mrpcrstate as MRPRequestDistributionStatus,
distributedon as MRPRequestDistributedDateTime,
prioritycode as MRPRequestPriority,
reasoncode as MRPRequestReason,
rejectioncode as MRPRequestRejection,
costofchange as MRPRequestCostOfChangeAmount,
currencykey as Currency,
attachment as HasAttachment
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MRP_REQ_NOTE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/