C_MatlLdgrDocToAcctgDocument
ML Document Related Accounting Documents
C_MatlLdgrDocToAcctgDocument is a Consumption CDS View that provides data about "ML Document Related Accounting Documents" in SAP S/4HANA. It reads from 1 data source (P_RelatedAccountingDocument) and exposes 45 fields with key fields ReferenceDocumentType, OriginalReferenceDocument, AccountingDocument, CompanyCode, FiscalYear. It is exposed through 1 OData service (FML_DSPMATLPRCHGDOCS).
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_RelatedAccountingDocument | P_RelatedAccountingDocument | from |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | ML Document Related Accounting Documents | view | |
| Metadata.allowExtensions | true | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| VDM.viewType | #CONSUMPTION | view |
OData Services (1)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| FML_DSPMATLPRCHGDOCS | FML_DSPMATLPRCHGDOCS | V4 | C1 | NOT_RELEASED |
Fields (45)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ReferenceDocumentType | ReferenceDocumentType | ||
| KEY | OriginalReferenceDocument | OriginalReferenceDocument | ||
| KEY | AccountingDocument | |||
| KEY | CompanyCode | CompanyCode | ||
| KEY | FiscalYear | FiscalYear | ||
| AccountingDocumentType | AccountingDocumentType | |||
| DocumentDate | DocumentDate | |||
| PostingDate | PostingDate | |||
| FiscalPeriod | FiscalPeriod | |||
| AccountingDocumentCreationDate | AccountingDocumentCreationDate | |||
| CreationTime | CreationTime | |||
| LastChangeDate | LastChangeDate | |||
| ExchangeRateDate | ExchangeRateDate | |||
| AccountingDocCreatedByUser | AccountingDocCreatedByUser | |||
| TransactionCode | TransactionCode | |||
| IntercompanyTransaction | IntercompanyTransaction | |||
| DocumentReferenceID | DocumentReferenceID | |||
| RecurringAccountingDocument | RecurringAccountingDocument | |||
| ReverseDocument | ReverseDocument | |||
| ReverseDocumentFiscalYear | ReverseDocumentFiscalYear | |||
| AccountingDocumentHeaderText | AccountingDocumentHeaderText | |||
| AccountingDocumentCategory | AccountingDocumentCategory | |||
| BusinessTransactionType | BusinessTransactionType | |||
| BatchInputSession | BatchInputSession | |||
| FinancialManagementArea | FinancialManagementArea | |||
| ReferenceDocumentLogicalSystem | ReferenceDocumentLogicalSystem | |||
| Branch | Branch | |||
| IsDiscountDocument | IsDiscountDocument | |||
| Reference1InDocumentHeader | Reference1InDocumentHeader | |||
| Reference2InDocumentHeader | Reference2InDocumentHeader | |||
| InvoiceReceiptDate | InvoiceReceiptDate | |||
| Ledger | Ledger | |||
| LedgerGroup | LedgerGroup | |||
| IsReversal | IsReversal | |||
| IsReversed | IsReversed | |||
| TaxReportingDate | TaxReportingDate | |||
| ReversalReason | ReversalReason | |||
| ParkingDate | ParkingDate | |||
| ParkingTime | ParkingTime | |||
| CompanyCodeCurrency | CompanyCodeCurrency | |||
| AdditionalCurrency1 | AdditionalCurrency1 | |||
| AdditionalCurrency2 | AdditionalCurrency2 | |||
| TaxIsCalculatedAutomatically | TaxIsCalculatedAutomatically | |||
| NmbrOfPages | NmbrOfPages | |||
| ReferenceDocumentTypeName |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'ML Document Related Accounting Documents'
@Metadata.allowExtensions: true
@ObjectModel.usageType:{
serviceQuality: #A,
sizeCategory: #XXL,
dataClass: #MIXED
}
@VDM: {
viewType: #CONSUMPTION
}
define view entity C_MatlLdgrDocToAcctgDocument
as select from P_RelatedAccountingDocument
{
key ReferenceDocumentType,
key OriginalReferenceDocument,
key cast(AccountingDocument as fml_mpchd_document_number preserving type ) as AccountingDocument,
key CompanyCode,
key FiscalYear,
AccountingDocumentType,
DocumentDate,
PostingDate,
FiscalPeriod,
AccountingDocumentCreationDate,
CreationTime,
LastChangeDate,
ExchangeRateDate,
AccountingDocCreatedByUser,
TransactionCode,
IntercompanyTransaction,
DocumentReferenceID,
RecurringAccountingDocument,
ReverseDocument,
ReverseDocumentFiscalYear,
AccountingDocumentHeaderText,
// ExchangeRate,
AccountingDocumentCategory,
BusinessTransactionType,
BatchInputSession,
FinancialManagementArea,
ReferenceDocumentLogicalSystem,
Branch,
IsDiscountDocument,
Reference1InDocumentHeader,
Reference2InDocumentHeader,
InvoiceReceiptDate,
Ledger,
LedgerGroup,
// AlternativeReferenceDocument,
IsReversal,
IsReversed,
TaxReportingDate,
ReversalReason,
ParkingDate,
ParkingTime,
CompanyCodeCurrency,
AdditionalCurrency1,
AdditionalCurrency2,
TaxIsCalculatedAutomatically,
NmbrOfPages,
_PrivatReferenceDocumentType._Text[1: Language = $session.system_language].ReferenceDocumentTypeName as ReferenceDocumentTypeName
}
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