P_MFGORDEROPRESERVATIONITEM

CDS View
81 Fields 2 CDS Views

P_MFGORDEROPRESERVATIONITEM is a CDS View in S/4HANA. It contains 81 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MfgOrderOperationComponent view from BASIC Manufacturing Order Operation Component
I_OperationActivityPlndMatlRet view inner BASIC Operation Activity Planned Material Return

Fields (81)

KeyField CDS FieldsUsed 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
erfme EntryUnit 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 2
netau IsNetScrap 1
objnr MaterialComponentObject,ObjectInternalID 2
OrderObjectInternalID OrderObjectInternalID 1
original_rsnum OriginalReservation 1
original_rspos OriginalReservationItem 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 2
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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MFGORDEROPRESERVATIONITEM (
    MATNR,
    RSNUM,
    WERKS,
    ABLAD,
    AENNR,
    AFPOS,
    ALPOS,
    APLZL,
    AUFPL,
    AUFST,
    AUFWG,
    AUSCH,
    AVOAU,
    BAUGR,
    BAUST,
    BAUWG,
    BDMNG,
    BERKZ,
    BOM_VERSN,
    BUKRS,
    BWART,
    CHARG,
    CHOBJ,
    CLAKZ,
    CUOBJ,
    ENWRT,
    ERFME,
    EWAHR,
    FKBER,
    FMENG,
    GSBER,
    INPOS,
    KFPOS,
    KOKRS,
    KZAUS,
    KZEAR,
    KZKUP,
    LGNUM,
    LGPLA,
    LGTYP,
    LIFNR,
    LTXSP,
    MATKL,
    MEINS,
    NETAU,
    OBJNR,
    ORDEROBJECTINTERNALID,
    ORIGINAL_RSNUM,
    ORIGINAL_RSPOS,
    POSNR,
    POTX1,
    POTX2,
    PWERK,
    RFORM,
    RGEKZ,
    ROAME,
    ROHPS,
    ROMEI,
    ROMS1,
    ROMS2,
    ROMS3,
    SAKNR,
    SANKA,
    SCHGT,
    SGT_RCAT,
    SGT_SCAT,
    SORTF,
    SPLKZ,
    STLAL,
    STLAN,
    STLNR,
    STLNR2,
    STPOZ,
    STVKN,
    TECHS,
    TXTPS,
    UMREN,
    UMREZ,
    WAERS,
    XFEHL,
    XWAOK,
    PRIMARY KEY (MATNR, RSNUM, WERKS)
);

Learn More