R_MaterialDocumentItemDraft

DDL: R_MATERIALDOCUMENTITEMDRAFT Type: view_entity BASIC Package: MM_IM_RAP_MATDOC
96 Fields 1 Data Sources 4 Associations

View for Matdoc Item table-draft

R_MaterialDocumentItemDraft is a Basic CDS View that provides data about "View for Matdoc Item table-draft" in SAP S/4HANA. It reads from 1 data source (dmatdocitemdraft) and exposes 96 fields with key fields MaterialDocumentYear, MaterialDocument, MaterialDocumentItem, DraftUUID. It has 4 associations to related views. Part of development package MM_IM_RAP_MATDOC.

Data Sources (1)

SourceAliasJoin Type
dmatdocitemdraft dmatdocitemdraft from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..1] I_Plant _IssuingOrReceivingPlant $projection.IssuingOrReceivingPlant = _IssuingOrReceivingPlant.Plant
[0..1] I_GoodsMovementType _GoodsMovementType $projection.GoodsMovementType = _GoodsMovementType.GoodsMovementType
[1..1] E_MaterialDocumentItemDraft _Extension $projection.MaterialDocument = _Extension.MaterialDocument and $projection.MaterialDocumentItem = _Extension.MaterialDocumentItem and $projection.MaterialDocumentYear = _Extension.MaterialDocumentYear and $projection.DraftUUID = _Extension.DraftUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label View for Matdoc Item table-draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (96)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocumentYear materialdocumentyear Material Document Year
KEY MaterialDocument materialdocument Material Doc.
KEY MaterialDocumentItem materialdocumentitem Material Document Item
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
Material material Vehicle Model
Plant plant Valuation Area
StorageLocation storagelocation StorageLocation
MaterialDocumentLine materialdocumentline Line ID
MaterialDocumentParentLine materialdocumentparentline Parent ID
GoodsMovementType goodsmovementtype Movement Type
StorageType storagetype Storage Type
StorageBin storagebin Storage Bin
InventoryUsabilityCode inventoryusabilitycode Stock Type
QuantityInEntryUnit quantityinentryunit Quantity in Unit of Entry
EntryUnit entryunit Unit of Entry
QuantityInBaseUnit quantityinbaseunit Quantity
MaterialBaseUnit materialbaseunit Valuation Unit
Batch batch Lot No.
ShelfLifeExpirationDate shelflifeexpirationdate SLED/BBD
ManufactureDate manufacturedate Date of Manuf.
InventorySpecialStockType inventoryspecialstocktype Special Stock Type
InventoryStockType inventorystocktype Stock Type
Customer customer Sold-to Party
Supplier supplier Supplier
IssgOrRcvgMaterial issgorrcvgmaterial Transfer Material
IssuingOrReceivingPlant issuingorreceivingplant Transfer Plant
IssuingOrReceivingStorageLoc issuingorreceivingstorageloc Receiving SLoc.
IssgOrRcvgBatch issgorrcvgbatch Transfer Batch
IssgOrRcvgSpclStockInd issgorrcvgspclstockind Special Stock
IssuingOrReceivingValType issuingorreceivingvaltype Val. Type Tfr.
WBSElementInternalID wbselementinternalid WBS Internal ID
Reservation reservation Reservation
ReservationItem reservationitem Reservation Item
OriginalMaterialDocumentItem originalmaterialdocumentitem Orig. line itm
GoodsMovementRefDocType goodsmovementrefdoctype Reference Doc. Type
GoodsMovementReasonCode goodsmovementreasoncode Reason for Mvmt
MaterialDocumentPostingType materialdocumentpostingtype Type of posting
PurchaseOrder purchaseorder Purchasing Document
PurchaseOrderItem purchaseorderitem Purchasing Document Item
CostCenter costcenter Cost Center
GLAccount glaccount General Ledger
CompanyCode companycode Receiver Company Code
PostingDate postingdate Posting Date for GR
DocumentDate documentdate Journal Entry Date
ControllingArea controllingarea Controlling Area
CostObject costobject Cost Object
ProfitCenter profitcenter Profit Center
FunctionalArea functionalarea Sendr Fctl Area
AccountAssignmentCategory accountassignmentcategory Acct Assgmt Cat
BusinessArea businessarea Business Area
SalesOrder salesorder SD Document
SalesOrderItem salesorderitem Sales Order Item
SalesOrderScheduleLine salesorderscheduleline SOrder schedule
ReferenceDocumentFiscalYear referencedocumentfiscalyear Year Cur.Period
InvtryMgmtRefDocumentItem invtrymgmtrefdocumentitem Ref. Doc. Item
InvtryMgmtReferenceDocument invtrymgmtreferencedocument Reference Doc.
DeliveryDocument deliverydocument Outbound Delivery
DeliveryDocumentItem deliverydocumentitem Outb. Delivery Item
ReversedMaterialDocumentYear reversedmaterialdocumentyear Reversed Doc Year
ReversedMaterialDocument reversedmaterialdocument Reversed Mat Doc
ReversedMaterialDocumentItem reversedmaterialdocumentitem Reversed Doc Item
InventoryValuationType inventoryvaluationtype Valuation Type
GoodsMovementIsCancelled goodsmovementiscancelled Is Item Cancelled
GoodsRecipientName goodsrecipientname Recipient Name
UnloadingPointName unloadingpointname Unloading Point Name
ReservationIsFinallyIssued reservationisfinallyissued Res Final Issue
ProjectNetwork projectnetwork Order
ManufacturingOrder manufacturingorder Order
ManufacturingOrderItem manufacturingorderitem Manufacturing Order Item
SpecialStockIdfgSalesOrder specialstockidfgsalesorder Stock Ident Header
SpecialStockIdfgSalesOrderItem specialstockidfgsalesorderitem Stock Ident Item
FiscalYear fiscalyear G/L Fiscal Year
FiscalYearPeriod fiscalyearperiod Period/Year
FiscalYearVariant fiscalyearvariant FY Variant
IsCompletelyDelivered iscompletelydelivered Is completely delivered
MaterialDocumentItemText materialdocumentitemtext Text
EWMWarehouse ewmwarehouse Warehouse No.
EWMStorageBin ewmstoragebin Storage Bin
CompanyCodeCurrency companycodecurrency Local Currency
GdsMvtExtAmtInCoCodeCrcy gdsmvtextamtincocodecrcy Ext. Amount LC
ProductStandardID productstandardid GTIN
IsAutomaticallyCreated isautomaticallycreated Is Automatically Created
SerialNumbersAreCreatedAutomly serialnumbersarecreatedautomly SerialNo. auto.
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes
DebitCreditCode debitcreditcode Single-Character Flag
ReservationItemRecordType reservationitemrecordtype Reservation Record Type
SpecialStockIdfgWBSElement specialstockidfgwbselement WBS Internal ID
_Plant _Plant
_IssuingOrReceivingPlant _IssuingOrReceivingPlant
_GoodsMovementType _GoodsMovementType

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_MaterialDocumentItemDraft.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_MaterialDocumentItemDraft AS
SELECT
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  DraftUUID,
  ParentDraftUUID,
  Material,
  Plant,
  StorageLocation,
  MaterialDocumentLine,
  MaterialDocumentParentLine,
  GoodsMovementType,
  StorageType,
  StorageBin,
  InventoryUsabilityCode,
  QuantityInEntryUnit,
  EntryUnit,
  QuantityInBaseUnit,
  MaterialBaseUnit,
  Batch,
  ShelfLifeExpirationDate,
  ManufactureDate,
  InventorySpecialStockType,
  InventoryStockType,
  Customer,
  Supplier,
  IssgOrRcvgMaterial,
  IssuingOrReceivingPlant,
  IssuingOrReceivingStorageLoc,
  IssgOrRcvgBatch,
  IssgOrRcvgSpclStockInd,
  IssuingOrReceivingValType,
  WBSElementInternalID,
  Reservation,
  ReservationItem,
  OriginalMaterialDocumentItem,
  GoodsMovementRefDocType,
  GoodsMovementReasonCode,
  MaterialDocumentPostingType,
  PurchaseOrder,
  PurchaseOrderItem,
  CostCenter,
  GLAccount,
  CompanyCode,
  PostingDate,
  DocumentDate,
  ControllingArea,
  CostObject,
  ProfitCenter,
  FunctionalArea,
  AccountAssignmentCategory,
  BusinessArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  ReferenceDocumentFiscalYear,
  InvtryMgmtRefDocumentItem,
  InvtryMgmtReferenceDocument,
  DeliveryDocument,
  DeliveryDocumentItem,
  ReversedMaterialDocumentYear,
  ReversedMaterialDocument,
  ReversedMaterialDocumentItem,
  InventoryValuationType,
  GoodsMovementIsCancelled,
  GoodsRecipientName,
  UnloadingPointName,
  ReservationIsFinallyIssued,
  ProjectNetwork,
  ManufacturingOrder,
  ManufacturingOrderItem,
  SpecialStockIdfgSalesOrder,
  SpecialStockIdfgSalesOrderItem,
  FiscalYear,
  FiscalYearPeriod,
  FiscalYearVariant,
  IsCompletelyDelivered,
  MaterialDocumentItemText,
  EWMWarehouse,
  EWMStorageBin,
  CompanyCodeCurrency,
  GdsMvtExtAmtInCoCodeCrcy,
  ProductStandardID,
  IsAutomaticallyCreated,
  SerialNumbersAreCreatedAutomly,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges,
  DebitCreditCode,
  ReservationItemRecordType,
  SpecialStockIdfgWBSElement
FROM dmatdocitemdraft
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _IssuingOrReceivingPlant ON IssuingOrReceivingPlant = _IssuingOrReceivingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..1]
LEFT OUTER JOIN E_MaterialDocumentItemDraft AS _Extension ON MaterialDocument = _Extension.MaterialDocument AND MaterialDocumentItem = _Extension.MaterialDocumentItem AND MaterialDocumentYear = _Extension.MaterialDocumentYear AND DraftUUID = _Extension.DraftUUID  -- association [1..1]
;

Learn More