P_MFGORDEROPRESERVATIONITEM
Manufacturing Order Operation Reservation Item
P_MFGORDEROPRESERVATIONITEM is a CDS View in S/4HANA. Manufacturing Order Operation Reservation Item. It contains 78 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MfgOrderOperationComponent | view | from | BASIC | Manufacturing Order Operation Component |
| I_OperationActivityPlndMatlRet | view | inner | BASIC | Operation Activity Planned Material Return |
Fields (78)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | matnr | Material | 2 |
| KEY | rsnum | Reservation | 1 |
| KEY | werks | Plant | 2 |
| ablad | UnloadingPointName | 1 | |
| aennr | ChangeNumber | 1 | |
| afpos | ManufacturingOrderItem | 1 | |
| alpos | MaterialCompIsAlternativeItem | 1 | |
| aplzl | OrderOperationInternalID | 1 | |
| aufpl | OrderInternalID | 1 | |
| aufst | OrderLevelValue | 1 | |
| aufwg | OrderPathValue | 1 | |
| ausch | ComponentScrapInPercent | 1 | |
| avoau | OperationScrapInPercent | 1 | |
| baugr | Assembly | 2 | |
| baust | AssemblyOrderLevelValue | 1 | |
| bauwg | AssemblyOrderPathValue | 1 | |
| bdmng | RequiredQuantity | 1 | |
| berkz | MaterialStaging | 1 | |
| bom_versn | BillOfMaterialVersion | 2 | |
| bukrs | CompanyCode | 1 | |
| bwart | GoodsMovementType | 1 | |
| charg | Batch | 1 | |
| chobj | BatchClassification | 1 | |
| clakz | MaterialComponentIsClassified | 1 | |
| cuobj | ProductConfiguration | 1 | |
| enwrt | WithdrawnQuantityAmount | 1 | |
| ewahr | UsageProbabilityPercent | 1 | |
| fkber | FunctionalArea | 1 | |
| fmeng | QuantityIsFixed | 1 | |
| gsber | BusinessArea | 1 | |
| inpos | MaterialCompIsIntraMaterial | 1 | |
| kfpos | MatlCompIsConfigurable | 1 | |
| kokrs | ControllingArea | 1 | |
| kzaus | MatlCompDiscontinuationType | 2 | |
| kzear | ReservationIsFinallyIssued | 1 | |
| kzkup | MaterialIsCoProduct | 1 | |
| lgnum | Warehouse | 1 | |
| lgpla | StorageBin | 1 | |
| lgtyp | StorageType | 1 | |
| lifnr | Supplier | 1 | |
| ltxsp | LongTextLanguageCode | 1 | |
| matkl | MaterialGroup | 1 | |
| meins | BaseUnit | 1 | |
| netau | IsNetScrap | 1 | |
| objnr | MaterialComponentObject,ObjectInternalID | 2 | |
| OrderObjectInternalID | OrderObjectInternalID | 1 | |
| posnr | BillOfMaterialItemNumber | 1 | |
| potx1 | BOMItemDescription | 1 | |
| potx2 | BOMItemText2 | 1 | |
| pwerk | ProductionPlant | 1 | |
| rform | FormulaKey | 2 | |
| rgekz | MatlCompIsMarkedForBackflush | 1 | |
| roame | VariableSizeItemUnit | 1 | |
| rohps | MaterialCompIsVariableSized | 1 | |
| romei | VariableSizeDimensionUnit | 1 | |
| roms1 | VariableSizeDimension1 | 2 | |
| roms2 | VariableSizeDimension2 | 2 | |
| roms3 | VariableSizeDimension3 | 2 | |
| saknr | GLAccount | 1 | |
| sanka | MaterialCompIsCostRelevant | 1 | |
| schgt | IsBulkMaterialComponent | 1 | |
| sgt_rcat | RequirementSegment | 1 | |
| sgt_scat | StockSegment | 1 | |
| sortf | MaterialComponentSortText,SortField | 1 | |
| splkz | BatchSplitType | 1 | |
| stlal | BillOfMaterialVariant | 2 | |
| stlan | BillOfMaterialVariantUsage | 1 | |
| stlnr | BillOfMaterialInternalID | 2 | |
| stlnr2 | BillOfMaterial | 2 | |
| stpoz | BOMItemInternalChangeCount | 2 | |
| stvkn | InheritedBOMItemNode | 2 | |
| techs | EffectivityParameterVariant | 2 | |
| txtps | MatlCompIsTextItem | 1 | |
| umren | MaterialQtyToBaseQtyDnmntr | 1 | |
| umrez | MaterialQtyToBaseQtyNmrtr | 1 | |
| waers | Currency | 1 | |
| xfehl | MaterialComponentIsMissing | 1 | |
| xwaok | GoodsMovementIsAllowed | 2 |
@AbapCatalog.sqlViewName: 'PMFGORDOPRESITM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.private: true
@VDM.viewType: #BASIC
//preselect view for I_MfgOrderOperationComponent
define view P_MfgOrderOpReservationItem
as select from resb as resb
left outer to one join caufv as aufv on aufv.aufnr = resb.aufnr
left outer to one join tcs03 as tcs03 on agb29 = '29'
{
// Key
key resb.rsnum,
key resb.rspos,
key resb.rsart,
//Material data
resb.matkl,
resb.matnr,
resb.werks,
// Order and Operation data
aufv.autyp,
aufv.auart,
aufv.objnr as OrderObjectInternalID,
resb.aufnr,
resb.plnfl,
resb.flgat,
resb.vornr,
aufv.werks as pwerk,
resb.aufpl,
resb.aplzl,
aufv.dispo,
aufv.fevor,
// Date and Time
resb.bdter,
resb.bdztp,
resb.sbter,
aufv.ftrmi,
// Attributes
resb.rssta,
resb.kzear,
resb.xloek,
resb.xfehl,
resb.schgt,
resb.dbskz,
resb.objnr,
resb.rgekz,
resb.txtps,
resb.kzkup,
resb.afpos,
resb.kfpos,
resb.sanka,
resb.clakz,
resb.inpos,
resb.no_disp,
// Long Text
resb.ltxsp,
// Assignments
resb.bdart,
resb.kdauf,
resb.kdpos,
resb.pspel,
resb.cuobj,
resb.aennr,
resb.techs,
resb.sortf,
resb.revlv,
// Assignments BOM
resb.stlty,
resb.stlnr,
aufv.stlan,
resb.stlal,
aufv.stlnr as stlnr2,
resb.stlkn,
resb.bom_versn,
resb.stpoz,
resb.stvkn,
resb.postp,
resb.posnr,
resb.potx1,
resb.potx2,
resb.sernr,
// Assignments Purchasing
resb.infnr,
resb.ekgrp,
resb.banfn,
resb.bnfpo,
resb.ebeln,
resb.ebelp,
resb.ebele,
resb.lifnr,
resb.lifzt,
resb.gpreis,
resb.peinh,
// Goods Movement data
resb.xwaok,
resb.lgort,
resb.shkzg,
resb.bwart,
resb.sobkz,
resb.kzbws,
resb.kzvbr,
resb.prvbe,
resb.wempf,
resb.ablad,
resb.webaz,
resb.sgt_scat,
resb.sgt_rcat,
// Batch data
resb.charg,
resb.kzech,
resb.splkz,
resb.splrv,
resb.chobj,
// Assignments WM
resb.berkz,
resb.lgnum,
resb.lgtyp,
resb.lgpla,
// Assignments FI/CO
resb.gsber,
aufv.bukrs,
resb.saknr,
resb.fkber,
aufv.kokrs,
resb.knttp,
resb.kblnr,
resb.kblpos,
resb.fipos,
resb.fipex,
resb.fistl,
resb.geber,
// Variable-size comp. data
resb.rohps,
resb.roanz,
resb.rokme,
resb.romen,
resb.romei,
resb.roms1,
resb.roms2,
resb.roms3,
resb.rform,
tcs03.roame,
// Alternative comp. data
resb.alpos,
resb.alpgr,
resb.alpst,
resb.alprf,
resb.ewahr,
// Phantom assembly
resb.dumps,
resb.aufwg,
resb.aufst,
resb.baugr,
resb.bauwg,
resb.baust,
// Discontinuation
resb.nfeag,
resb.kzaus,
resb.nfpkz,
resb.nfgrp,
resb.nomat,
resb.nafkz,
// Material provision
resb.beikz,
// Spare parts
resb.erskz,
// Lead-Time offset
resb.nlfzt,
resb.nlfmv,
resb.nlfzv,
// Quantities and UoM
resb.fmeng,
resb.netau,
resb.ausch,
resb.avoau,
resb.umrez,
resb.umren,
resb.meins,
resb.bdmng,
resb.enmng,
resb.vmeng,
resb.nomng,
resb.erfme,
resb.erfmg,
// Amount and Currency
resb.waers,
resb.enwrt,
// Fashion Manufacturing Fields
resb.fsh_critical_comp,
resb.fsh_critical_level
}
where aufv.autyp = '10'
or aufv.autyp = '40';