MAINTORDOPCOMP_D
Draft table for entity R_MAINTORDEROPCOMPONENTTP
MAINTORDOPCOMP_D is an SAP database table in S/4HANA. Draft table for entity R_MAINTORDEROPCOMPONENTTP. It contains 100 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_MaintOrderOpComponentDraft | view_entity | from | BASIC | Maint Ord Oper Component Draft data |
Fields (100)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | maintenanceorder | aufnr | Order | |||
| KEY | maintenanceorderoperation | maintenanceorderoperation | Operation | |||
| KEY | maintenanceordersuboperation | maintenanceordersuboperation | Suboperation | |||
| KEY | maintenanceordercomponent | maintenanceordercomponent | BOM item | |||
| KEY | draftuuid | sdraft_uuid | Draft Document ID | |||
| parentdraftuuid | sdraft_uuid | Draft Document ID | ||||
| maintorderoperationforedit | maintenanceorderoperation | Operation | ||||
| maintordersuboperationforedit | maintenanceordersuboperation | Suboperation | ||||
| maintordercomponentforedit | maintenanceordercomponent | BOM item | ||||
| 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 | ||||
| maintordopcompismrprelevant | 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 | ||||
| maintordercomponentinternalid | j_objnr | Object number | ||||
| 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 |
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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MAINTORDOPCOMP_D (
MANDT, -- Client [mandt]
MAINTENANCEORDER, -- Order [aufnr]
MAINTENANCEORDEROPERATION, -- Operation [maintenanceorderoperation]
MAINTENANCEORDERSUBOPERATION, -- Suboperation [maintenanceordersuboperation]
MAINTENANCEORDERCOMPONENT, -- BOM item [maintenanceordercomponent]
DRAFTUUID, -- Draft Document ID [sdraft_uuid]
PARENTDRAFTUUID, -- Draft Document ID [sdraft_uuid]
MAINTORDEROPERATIONFOREDIT, -- Operation [maintenanceorderoperation]
MAINTORDERSUBOPERATIONFOREDIT, -- Suboperation [maintenanceordersuboperation]
MAINTORDERCOMPONENTFOREDIT, -- BOM item [maintenanceordercomponent]
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]
MAINTORDOPCOMPISMRPRELEVANT, -- 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]
MAINTORDERCOMPONENTINTERNALID, -- Object number [j_objnr]
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]
PRIMARY KEY (MANDT, MAINTENANCEORDER, MAINTENANCEORDEROPERATION, MAINTENANCEORDERSUBOPERATION, MAINTENANCEORDERCOMPONENT, DRAFTUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA