I_MaterialDocumentItemTP

DDL: I_MATERIALDOCUMENTITEMTP Type: view_entity TRANSACTIONAL
77 Fields 1 Data Sources

Material Documentitem Interface - TP

I_MaterialDocumentItemTP is a Transactional CDS View that provides data about "Material Documentitem Interface - TP" in SAP S/4HANA. It reads from 1 data source (R_MaterialDocumentItemTP) and exposes 77 fields with key fields MaterialDocumentYear, MaterialDocument, MaterialDocumentItem.

Data Sources (1)

SourceAliasJoin Type
R_MaterialDocumentItemTP R_MaterialDocumentItemTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Material Documentitem Interface - TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_PROJECTED_ENTITY view
Metadata.ignorePropagatedAnnotations true view

Fields (77)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
MaterialDocumentLine MaterialDocumentLine Line ID
MaterialDocumentParentLine MaterialDocumentParentLine Parent ID
GoodsMovementType GoodsMovementType Movement Type
Material Material Vehicle Model
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
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
Customer Customer Sold-to Party
Supplier Supplier Supplier
InventoryStockType InventoryStockType Stock Type
InventoryValuationType InventoryValuationType Valuation Type
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
ReversedMaterialDocumentYear ReversedMaterialDocumentYear Reversed Doc Year
ReversedMaterialDocument ReversedMaterialDocument Reversed Mat Doc
ReversedMaterialDocumentItem ReversedMaterialDocumentItem Reversed Doc Item
GoodsMovementIsCancelled GoodsMovementIsCancelled Is Item Cancelled
FiscalYearPeriod FiscalYearPeriod Period/Year
FiscalYearVariant FiscalYearVariant FY Variant
IsAutomaticallyCreated IsAutomaticallyCreated Is Automatically Created
MaterialDocumentPostingType MaterialDocumentPostingType Type of posting
ReservationItemRecordType ReservationItemRecordType Reservation Record Type
DebitCreditCode DebitCreditCode Single-Character Flag
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
GoodsMovementRefDocType GoodsMovementRefDocType Reference Doc. Type
GoodsMovementReasonCode GoodsMovementReasonCode Reason for Mvmt
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
SerialNumbersAreCreatedAutomly SerialNumbersAreCreatedAutomly SerialNo. auto.
CostCenter CostCenter Cost Center
GLAccount GLAccount General Ledger
ProfitCenter ProfitCenter Profit Center
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
SalesOrderScheduleLine SalesOrderScheduleLine SOrder schedule
DeliveryDocument DeliveryDocument Outbound Delivery
DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
GoodsRecipientName GoodsRecipientName Recipient Name
UnloadingPointName UnloadingPointName Unloading Point Name
ReservationIsFinallyIssued ReservationIsFinallyIssued Res Final Issue
ManufacturingOrder ManufacturingOrder Order
ManufacturingOrderItem ManufacturingOrderItem Manufacturing Order Item
SpecialStockIdfgSalesOrder SpecialStockIdfgSalesOrder Stock Ident Header
SpecialStockIdfgSalesOrderItem SpecialStockIdfgSalesOrderItem Stock Ident Item
MaterialDocumentItemText MaterialDocumentItemText Text
GdsMvtExtAmtInCoCodeCrcy GdsMvtExtAmtInCoCodeCrcy Ext. Amount LC
ProductStandardID ProductStandardID GTIN
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear Year Cur.Period
InvtryMgmtRefDocumentItem InvtryMgmtRefDocumentItem Ref. Doc. Item
InvtryMgmtReferenceDocument InvtryMgmtReferenceDocument Reference Doc.
_GoodsMovementType _GoodsMovementType
_Product _Product
_Plant _Plant
_StorageLocation _StorageLocation
_GoodsMovementReasonCode _GoodsMovementReasonCode
_EntryUnit _EntryUnit
_MaterialBaseUnit _MaterialBaseUnit

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 I_MaterialDocumentItemTP.
-- 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 I_MaterialDocumentItemTP AS
SELECT
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentLine,
  MaterialDocumentParentLine,
  GoodsMovementType,
  Material,
  Plant,
  StorageLocation,
  InventoryUsabilityCode,
  QuantityInEntryUnit,
  EntryUnit,
  QuantityInBaseUnit,
  MaterialBaseUnit,
  Batch,
  ShelfLifeExpirationDate,
  ManufactureDate,
  InventorySpecialStockType,
  Customer,
  Supplier,
  InventoryStockType,
  InventoryValuationType,
  AccountAssignmentCategory,
  ReversedMaterialDocumentYear,
  ReversedMaterialDocument,
  ReversedMaterialDocumentItem,
  GoodsMovementIsCancelled,
  FiscalYearPeriod,
  FiscalYearVariant,
  IsAutomaticallyCreated,
  MaterialDocumentPostingType,
  ReservationItemRecordType,
  DebitCreditCode,
  IssgOrRcvgMaterial,
  IssuingOrReceivingPlant,
  IssuingOrReceivingStorageLoc,
  IssgOrRcvgBatch,
  IssgOrRcvgSpclStockInd,
  IssuingOrReceivingValType,
  WBSElementInternalID,
  Reservation,
  ReservationItem,
  GoodsMovementRefDocType,
  GoodsMovementReasonCode,
  PurchaseOrder,
  PurchaseOrderItem,
  IsCompletelyDelivered,
  SerialNumbersAreCreatedAutomly,
  CostCenter,
  GLAccount,
  ProfitCenter,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  DeliveryDocument,
  DeliveryDocumentItem,
  GoodsRecipientName,
  UnloadingPointName,
  ReservationIsFinallyIssued,
  ManufacturingOrder,
  ManufacturingOrderItem,
  SpecialStockIdfgSalesOrder,
  SpecialStockIdfgSalesOrderItem,
  MaterialDocumentItemText,
  GdsMvtExtAmtInCoCodeCrcy,
  ProductStandardID,
  CompanyCodeCurrency,
  ReferenceDocumentFiscalYear,
  InvtryMgmtRefDocumentItem,
  InvtryMgmtReferenceDocument
FROM R_MaterialDocumentItemTP
;

Learn More