P_InvtryLdgrMatlLedgerDocument
Material Ledger Document for Inventory Ledger
P_InvtryLdgrMatlLedgerDocument is a Composite CDS View that provides data about "Material Ledger Document for Inventory Ledger" in SAP S/4HANA. It reads from 1 data source (mldoc) and exposes 26 fields with key fields ReferenceDocument, CurrencyRole. Part of development package FCML4H_DISPLAY.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| mldoc | mldoc | from |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view |
Fields (26)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ReferenceDocument | docref | ||
| KEY | CurrencyRole | curtp | ||
| Ledger | rldnr | |||
| CostingRunReference | runref | |||
| CostEstimate | kalnr | |||
| FiscalYearPeriod | ||||
| MatlLdgrDocIsCostingRelevant | xabr | |||
| MaterialLedgerCategory | categ | |||
| ProcessCategory | ptyp | |||
| MaterialLedgerItemType | posart | |||
| ProcurementAlternative | bvalt | |||
| ProductionProcess | process | |||
| TotalVltdStockQuantity | quant | |||
| ValuationQuantityUnit | meins | |||
| InventoryAmtInCCCrcy | stval | |||
| PriceDiffAmtInDisplayCrcy | prd | |||
| ExchRateDiffAmtInDspCurrency | kdm | |||
| Currency | waers | |||
| PostingDate | budat | |||
| Plant | werks | |||
| SourceReferenceDocument | awref | |||
| ReferenceDocumentContext | aworg | |||
| ReferenceDocumentItem | awitem | |||
| RefBusinessTransactionType | glvor | |||
| GoodsMovementType | bwart | |||
| CostElement | kstar |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType:{
serviceQuality: #A,
sizeCategory: #XXL,
dataClass: #MIXED
}
@VDM: {
viewType: #COMPOSITE,
private: true
}
define view entity P_InvtryLdgrMatlLedgerDocument
as select from mldoc
{
key docref as ReferenceDocument,
key curtp as CurrencyRole,
rldnr as Ledger,
runref as CostingRunReference,
kalnr as CostEstimate,
cast(jahrper as fml_yearper_nconv preserving type ) as FiscalYearPeriod,
xabr as MatlLdgrDocIsCostingRelevant,
categ as MaterialLedgerCategory,
ptyp as ProcessCategory,
posart as MaterialLedgerItemType,
bvalt as ProcurementAlternative,
process as ProductionProcess,
@Semantics.quantity.unitOfMeasure: 'ValuationQuantityUnit'
quant as TotalVltdStockQuantity,
meins as ValuationQuantityUnit,
@Semantics.amount.currencyCode: 'Currency'
stval as InventoryAmtInCCCrcy,
@Semantics.amount.currencyCode: 'Currency'
prd as PriceDiffAmtInDisplayCrcy,
@Semantics.amount.currencyCode: 'Currency'
kdm as ExchRateDiffAmtInDspCurrency,
waers as Currency,
budat as PostingDate,
werks as Plant,
awref as SourceReferenceDocument,
aworg as ReferenceDocumentContext,
awitem as ReferenceDocumentItem,
glvor as RefBusinessTransactionType,
bwart as GoodsMovementType,
kstar as CostElement
}
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