MAINTORDOPCMP2_D

Transparent Table Application Table
105 Fields 1 CDS Views

Draft table for entity R_MAINTORDEROPCOMPONENTTP_2

MAINTORDOPCMP2_D is an SAP database table in S/4HANA. Draft table for entity R_MAINTORDEROPCOMPONENTTP_2. It contains 105 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_MaintOrderOpComponentDraft_2 view_entity from BASIC Maint Ord Oper Component Draft data

Fields (105)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY maintenanceorder AUFNR Order
KEY maintenanceorderoperation MAINTENANCEORDEROPERATION Operation
KEY maintenanceordersuboperation MAINTENANCEORDERSUBOPERATION Suboperation
KEY maintordercomponentinternalid J_OBJNR Object number
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
maintenanceordercomponent MAINTENANCEORDERCOMPONENT BOM item
maintorderoperationforedit MAINTENANCEORDEROPERATION Operation
maintordersuboperationforedit MAINTENANCEORDERSUBOPERATION Suboperation
reservation RSNUM Reservation
reservationitem RSPOS Item no.
reservationtype RSART Record type
maintorderroutingnumber CO_AUFPL Plan No.f.Oper.
maintorderoperationcounter CIM_COUNT Counter
product MATNR Material
maintordoperationcomponenttext abap.char
maintordopcomprequiredquantity BDMNG Requirement qty
baseunit MEINS Base Unit
quantityinunitofentry ERFMG Quantity in UnE
unitofentry ERFME Unit of Entry
requirementdate abap.dats
requirementtime abap.tims
requirementdatetime TIMESTAMP Time Stamp
supplier LIFNR Supplier
plant WERKS_D Plant
storagelocation LGORT_D Location
maintordopcompitemcategory POSTP Item Category
goodsmovementtype BWART Movement Type
reservationisfinallyissued KZEAR Final Issue
materialgroup MATKL Material Group
purreqnorresvngeneration PURREQNORRESVNGENERATION Purchase Reqn. / Resvn. Generation
materialcompisprocureddirectly XFELD Checkbox
producttypecode PRODUCT_TYPE Product Type Group
serviceperformer SERVICEPERFORMER Service Performer
performanceperiodstartdatetime TIMESTAMP Time Stamp
performanceperiodstartdate abap.dats
performanceperiodstarttime abap.tims
performanceperiodenddatetime TIMESTAMP Time Stamp
performanceperiodenddate abap.dats
performanceperiodendtime abap.tims
leanserviceduration SERVICEDURATION Service Duration
leanservicedurationunit SERVICEDURATIONUNIT Serv. Dur. Unit
distributionfunction CY_FUNCT Function
maintordcompdeliverydateadjmt CC4_DELVRY_DATE_ADJ Align Req. Date
srvcschedgisalignedwthopwrkctr OPERATIONWORKCENTERALIGNMENT Align with Work Center
maintordercompdebitcreditcode SHKZG Debit/Credit
goodsmovementisallowed XWAOK Mvt Allowed
maintenanceordercomponentbatch CHARG_D Batch
quantityisfixed FMENG Qty. is fixed
maintordopcomponentcurrency WAERS Currency
maintordopcomponentglaccount SAKNR G/L Account
maintordopcompcostingrelevancy CK_SELKZ CostingRelevncy
maintcompaltvprodusgerateinpct EWAHR Usage Prob.
maintorderopcomponentsorttext SORTP Sort String
maintordopcompisbulkproduct SCHGT Bulk material
materialprovisiontype BEIKZ Mat. Prov. Ind.
maintordopcompassgdwbselmntint PS_S4_PSPNR WBS Internal ID
wbselement VDM_PS_POSID WBS Element
maintorderopcomponentprice PPCOMP Price/currency
maintordopcomppriceunitqty PEINH Price unit
matlcompismarkedforbackflush RGEKZ Backflush
purchasinggroup EKGRP Purch. Group
deliverytimeindays LIFZT Del time (days)
maintordopcompgdsrecipientname WEMPF Recipient
maintordopcompunloadingpttxt ABLAD Unloading Point
goodsreceiptdurationinworkdays WEBAZ GR proc. time
purchasinginforecord INFNR Info Record
operationleadtimeoffset CS_NLFZV Oper. LT offset
opsleadtimeoffsetunit CS_NLFMV Oper. LTO unit
maintordopcomprequisitioner AFNAM Requisitioner
maintordopcompprocmttrckgnmbr BEDNR Tracking Number
responsiblepurchaseorg EKORG Purchasing Org.
purchaserequisition BANFN Purchase Req.
purchaserequisitionitem BNFPO Requisn. item
overalllimitamount SUMLIMIT Overall Limit
expectedoveralllimitamount COMMITMENT Expected Value
maintordopcompspecialstocktype SOBKZ Special Stock
variablesizedimension1 ROMS1 Size 1
variablesizedimensionunit ROMEI Size unit
variablesizecompformulakey RFORM VSI Formula
variablesizedimension2 ROMS2 Size 2
numberofvariablesizeitem VDM_ROANZ Number of Variable-Size Items
variablesizedimension3 ROMS3 Size 3
variablesizeitemquantity ROMEN VSI Quantity
variablesizecomponentunit ROKME VSI UoM
rqmtdateisenteredmanually KZMPF Man. Reqmt Date
supplierproduct IDNLF Supp. Mat. No.
maintordcompcmtdqtyiskept MAINTORDCOMPCMTDQTYISKEPT Keep Committed Qties
maintordopcomppuroutlineagrmt EBELN Purchasing Doc.
maintordcomppuroutlineagrmtitm EBELP Item
isdeleted XLOEK Deleted
maintordopcompprocmtcatalog KATALOGID Catalog ID
maintordopcompprocmtcatalogitm CATALOG_PROD_ID Product ID
quantitywithdrawninbaseunit ENMNG Withdrawal Qty
confirmedavailablequantity PPH_VMENG Available Quantity
recipientlocationcode RECIPIENT_LOCATION_CODE Recipient Loc.
controllingarea KOKRS CO Area
maintenanceorderdraftuuid SDRAFT_UUID Draft Document ID
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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.

-- Draft table for entity R_MAINTORDEROPCOMPONENTTP_2
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MAINTORDOPCMP2_D (
    MANDT,                           -- Client [MANDT]
    MAINTENANCEORDER,                -- Order [AUFNR]
    MAINTENANCEORDEROPERATION,       -- Operation [MAINTENANCEORDEROPERATION]
    MAINTENANCEORDERSUBOPERATION,    -- Suboperation [MAINTENANCEORDERSUBOPERATION]
    MAINTORDERCOMPONENTINTERNALID,   -- Object number [J_OBJNR]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    MAINTENANCEORDERCOMPONENT,       -- BOM item [MAINTENANCEORDERCOMPONENT]
    MAINTORDEROPERATIONFOREDIT,      -- Operation [MAINTENANCEORDEROPERATION]
    MAINTORDERSUBOPERATIONFOREDIT,   -- Suboperation [MAINTENANCEORDERSUBOPERATION]
    RESERVATION,                     -- Reservation [RSNUM]
    RESERVATIONITEM,                 -- Item no. [RSPOS]
    RESERVATIONTYPE,                 -- Record type [RSART]
    MAINTORDERROUTINGNUMBER,         -- Plan No.f.Oper. [CO_AUFPL]
    MAINTORDEROPERATIONCOUNTER,      -- Counter [CIM_COUNT]
    PRODUCT,                         -- Material [MATNR]
    MAINTORDOPERATIONCOMPONENTTEXT,  -- abap.char
    MAINTORDOPCOMPREQUIREDQUANTITY,  -- Requirement qty [BDMNG]
    BASEUNIT,                        -- Base Unit [MEINS]
    QUANTITYINUNITOFENTRY,           -- Quantity in UnE [ERFMG]
    UNITOFENTRY,                     -- Unit of Entry [ERFME]
    REQUIREMENTDATE,                 -- abap.dats
    REQUIREMENTTIME,                 -- abap.tims
    REQUIREMENTDATETIME,             -- Time Stamp [TIMESTAMP]
    SUPPLIER,                        -- Supplier [LIFNR]
    PLANT,                           -- Plant [WERKS_D]
    STORAGELOCATION,                 -- Location [LGORT_D]
    MAINTORDOPCOMPITEMCATEGORY,      -- Item Category [POSTP]
    GOODSMOVEMENTTYPE,               -- Movement Type [BWART]
    RESERVATIONISFINALLYISSUED,      -- Final Issue [KZEAR]
    MATERIALGROUP,                   -- Material Group [MATKL]
    PURREQNORRESVNGENERATION,        -- Purchase Reqn. / Resvn. Generation [PURREQNORRESVNGENERATION]
    MATERIALCOMPISPROCUREDDIRECTLY,  -- Checkbox [XFELD]
    PRODUCTTYPECODE,                 -- Product Type Group [PRODUCT_TYPE]
    SERVICEPERFORMER,                -- Service Performer [SERVICEPERFORMER]
    PERFORMANCEPERIODSTARTDATETIME,  -- Time Stamp [TIMESTAMP]
    PERFORMANCEPERIODSTARTDATE,      -- abap.dats
    PERFORMANCEPERIODSTARTTIME,      -- abap.tims
    PERFORMANCEPERIODENDDATETIME,    -- Time Stamp [TIMESTAMP]
    PERFORMANCEPERIODENDDATE,        -- abap.dats
    PERFORMANCEPERIODENDTIME,        -- abap.tims
    LEANSERVICEDURATION,             -- Service Duration [SERVICEDURATION]
    LEANSERVICEDURATIONUNIT,         -- Serv. Dur. Unit [SERVICEDURATIONUNIT]
    DISTRIBUTIONFUNCTION,            -- Function [CY_FUNCT]
    MAINTORDCOMPDELIVERYDATEADJMT,   -- Align Req. Date [CC4_DELVRY_DATE_ADJ]
    SRVCSCHEDGISALIGNEDWTHOPWRKCTR,  -- Align with Work Center [OPERATIONWORKCENTERALIGNMENT]
    MAINTORDERCOMPDEBITCREDITCODE,   -- Debit/Credit [SHKZG]
    GOODSMOVEMENTISALLOWED,          -- Mvt Allowed [XWAOK]
    MAINTENANCEORDERCOMPONENTBATCH,  -- Batch [CHARG_D]
    QUANTITYISFIXED,                 -- Qty. is fixed [FMENG]
    MAINTORDOPCOMPONENTCURRENCY,     -- Currency [WAERS]
    MAINTORDOPCOMPONENTGLACCOUNT,    -- G/L Account [SAKNR]
    MAINTORDOPCOMPCOSTINGRELEVANCY,  -- CostingRelevncy [CK_SELKZ]
    MAINTCOMPALTVPRODUSGERATEINPCT,  -- Usage Prob. [EWAHR]
    MAINTORDEROPCOMPONENTSORTTEXT,   -- Sort String [SORTP]
    MAINTORDOPCOMPISBULKPRODUCT,     -- Bulk material [SCHGT]
    MATERIALPROVISIONTYPE,           -- Mat. Prov. Ind. [BEIKZ]
    MAINTORDOPCOMPASSGDWBSELMNTINT,  -- WBS Internal ID [PS_S4_PSPNR]
    WBSELEMENT,                      -- WBS Element [VDM_PS_POSID]
    MAINTORDEROPCOMPONENTPRICE,      -- Price/currency [PPCOMP]
    MAINTORDOPCOMPPRICEUNITQTY,      -- Price unit [PEINH]
    MATLCOMPISMARKEDFORBACKFLUSH,    -- Backflush [RGEKZ]
    PURCHASINGGROUP,                 -- Purch. Group [EKGRP]
    DELIVERYTIMEINDAYS,              -- Del time (days) [LIFZT]
    MAINTORDOPCOMPGDSRECIPIENTNAME,  -- Recipient [WEMPF]
    MAINTORDOPCOMPUNLOADINGPTTXT,    -- Unloading Point [ABLAD]
    GOODSRECEIPTDURATIONINWORKDAYS,  -- GR proc. time [WEBAZ]
    PURCHASINGINFORECORD,            -- Info Record [INFNR]
    OPERATIONLEADTIMEOFFSET,         -- Oper. LT offset [CS_NLFZV]
    OPSLEADTIMEOFFSETUNIT,           -- Oper. LTO unit [CS_NLFMV]
    MAINTORDOPCOMPREQUISITIONER,     -- Requisitioner [AFNAM]
    MAINTORDOPCOMPPROCMTTRCKGNMBR,   -- Tracking Number [BEDNR]
    RESPONSIBLEPURCHASEORG,          -- Purchasing Org. [EKORG]
    PURCHASEREQUISITION,             -- Purchase Req. [BANFN]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [BNFPO]
    OVERALLLIMITAMOUNT,              -- Overall Limit [SUMLIMIT]
    EXPECTEDOVERALLLIMITAMOUNT,      -- Expected Value [COMMITMENT]
    MAINTORDOPCOMPSPECIALSTOCKTYPE,  -- Special Stock [SOBKZ]
    VARIABLESIZEDIMENSION1,          -- Size 1 [ROMS1]
    VARIABLESIZEDIMENSIONUNIT,       -- Size unit [ROMEI]
    VARIABLESIZECOMPFORMULAKEY,      -- VSI Formula [RFORM]
    VARIABLESIZEDIMENSION2,          -- Size 2 [ROMS2]
    NUMBEROFVARIABLESIZEITEM,        -- Number of Variable-Size Items [VDM_ROANZ]
    VARIABLESIZEDIMENSION3,          -- Size 3 [ROMS3]
    VARIABLESIZEITEMQUANTITY,        -- VSI Quantity [ROMEN]
    VARIABLESIZECOMPONENTUNIT,       -- VSI UoM [ROKME]
    RQMTDATEISENTEREDMANUALLY,       -- Man. Reqmt Date [KZMPF]
    SUPPLIERPRODUCT,                 -- Supp. Mat. No. [IDNLF]
    MAINTORDCOMPCMTDQTYISKEPT,       -- Keep Committed Qties [MAINTORDCOMPCMTDQTYISKEPT]
    MAINTORDOPCOMPPUROUTLINEAGRMT,   -- Purchasing Doc. [EBELN]
    MAINTORDCOMPPUROUTLINEAGRMTITM,  -- Item [EBELP]
    ISDELETED,                       -- Deleted [XLOEK]
    MAINTORDOPCOMPPROCMTCATALOG,     -- Catalog ID [KATALOGID]
    MAINTORDOPCOMPPROCMTCATALOGITM,  -- Product ID [CATALOG_PROD_ID]
    QUANTITYWITHDRAWNINBASEUNIT,     -- Withdrawal Qty [ENMNG]
    CONFIRMEDAVAILABLEQUANTITY,      -- Available Quantity [PPH_VMENG]
    RECIPIENTLOCATIONCODE,           -- Recipient Loc. [RECIPIENT_LOCATION_CODE]
    CONTROLLINGAREA,                 -- CO Area [KOKRS]
    MAINTENANCEORDERDRAFTUUID,       -- Draft Document ID [SDRAFT_UUID]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, MAINTENANCEORDER, MAINTENANCEORDEROPERATION, MAINTENANCEORDERSUBOPERATION, MAINTORDERCOMPONENTINTERNALID, DRAFTUUID)
);

Learn More