C_MatlLdgrDocToAcctgDocument

DDL: C_MATLLDGRDOCTOACCTGDOCUMENT Type: view_entity CONSUMPTION

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)

SourceAliasJoin Type
P_RelatedAccountingDocument P_RelatedAccountingDocument from

Annotations (7)

NameValueLevelField
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)

ServiceBindingVersionContractRelease
FML_DSPMATLPRCHGDOCS FML_DSPMATLPRCHGDOCS V4 C1 NOT_RELEASED

Fields (45)

KeyFieldSource TableSource FieldDescription
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
}