I_FldLogsMatlDocumentRecord
Field Logistics Material Document Record
I_FldLogsMatlDocumentRecord is a Basic CDS View that provides data about "Field Logistics Material Document Record" in SAP S/4HANA. It reads from 1 data source (matdoc) and exposes 30 fields with key fields MaterialDocument, MaterialDocumentYear, MaterialDocumentItem.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| matdoc | matdoc | from |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Field Logistics Material Document Record | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| VDM.private | false | view | |
| VDM.viewType | #BASIC | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view |
Fields (30)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaterialDocument | mblnr | ||
| KEY | MaterialDocumentYear | mjahr | ||
| KEY | MaterialDocumentItem | zeile | ||
| QuantityInBaseUnit | menge | |||
| MaterialBaseUnit | meins | |||
| PurchaseOrder | ebeln | |||
| PurchaseOrderItem | ebelp | |||
| GoodsMovementType | bwart | |||
| ReversedMaterialDocumentYear | ||||
| ReversedMaterialDocument | ||||
| ReversedMaterialDocumentItem | ||||
| Material | matnr | |||
| MaterialDocumentRecordType | record_type | |||
| IsMaterialDocumentHeader | header_counter | |||
| Plant | werks | |||
| IssuingOrReceivingPlant | ||||
| DeliveryDocument | vbeln_im | |||
| DeliveryDocumentItem | vbelp_im | |||
| GoodsMovementIsCancelled | cancelled | |||
| IsReversalMovementType | reversal_movement | |||
| IsAutomaticallyCreated | xauto | |||
| StockIdentifyingMaterial | matbf | |||
| InventoryStockType | lbbsa_sid | |||
| StockIdfgStorageLocation | lgort_sid | |||
| SpecialStockIdfgWBSElement | ||||
| MatlStkChangeQtyInBaseUnit | stock_qty | |||
| Batch | charg_sid | |||
| ValuationType | bwtar | |||
| PostingDate | budat | |||
| bstmeasOrderQuantityUnitInc2380137735 |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Field Logistics Material Document Record'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #A,
sizeCategory: #XXL,
dataClass: #TRANSACTIONAL
}
@VDM: {
private: false,
viewType: #BASIC,
lifecycle.contract.type: #SAP_INTERNAL_API
}
define view entity I_FldLogsMatlDocumentRecord
as select from matdoc
{
key mblnr as MaterialDocument,
key mjahr as MaterialDocumentYear,
key zeile as MaterialDocumentItem,
// @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit' //v2813353
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit' --Inc# 2380137735
@DefaultAggregation: #NONE
bstmg as GoodsReceiptQtyInOrderUnit,
@Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
@DefaultAggregation: #NONE
menge as QuantityInBaseUnit,
meins as MaterialBaseUnit,
ebeln as PurchaseOrder,
ebelp as PurchaseOrderItem,
bwart as GoodsMovementType,
cast(sjahr as nsdm_sjahr preserving type) as ReversedMaterialDocumentYear,
cast(smbln as nsdm_smbln preserving type) as ReversedMaterialDocument,
cast(smblp as nsdm_smblp preserving type) as ReversedMaterialDocumentItem,
matnr as Material,
@Consumption.hidden: true
record_type as MaterialDocumentRecordType,
@Consumption.hidden: true
header_counter as IsMaterialDocumentHeader,
werks as Plant,
cast(umwrk as nsdm_plant preserving type) as IssuingOrReceivingPlant,
vbeln_im as DeliveryDocument,
vbelp_im as DeliveryDocumentItem,
cancelled as GoodsMovementIsCancelled,
reversal_movement as IsReversalMovementType,
@Semantics.booleanIndicator: true
xauto as IsAutomaticallyCreated,
matbf as StockIdentifyingMaterial,
lbbsa_sid as InventoryStockType,
lgort_sid as StockIdfgStorageLocation,
cast(mat_pspnr as ps_s4_pspnr ) as SpecialStockIdfgWBSElement, //Cast required for conversion exit
@Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
stock_qty as MatlStkChangeQtyInBaseUnit,
charg_sid as Batch,
bwtar as ValuationType,
@Semantics.businessDate.at: true
budat as PostingDate, // #Add Date fields to each milestone
bstme as OrderQuantityUnit --Inc# 2380137735
}
where
record_type = 'MDOC'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MATDOC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA