C_FinInvcRelatedAcctgDocFDP

DDL: C_FININVCRELATEDACCTGDOCFDP Type: view_entity CONSUMPTION Package: FINS_OUTPUT_MGMT_FO_FICUS_INV

Related Document Number for FI Invoice

C_FinInvcRelatedAcctgDocFDP is a Consumption CDS View that provides data about "Related Document Number for FI Invoice" in SAP S/4HANA. It reads from 1 data source (I_JournalEntry) and exposes 17 fields with key fields CompanyCode, AccountingDocument, FiscalYear. It has 1 association to related views. Part of development package FINS_OUTPUT_MGMT_FO_FICUS_INV.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntry I_JournalEntry from

Associations (1)

CardinalityTargetAliasCondition
[1..*] C_FinInvcRelatedAcctgDocItmFDP _Item $projection.AccountingDocument = _Item.AccountingDocument and $projection.CompanyCode = _Item.CompanyCode and $projection.FiscalYear = _Item.FiscalYear

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Related Document Number for FI Invoice view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
InvoiceReference
InvoiceReferenceFiscalYear
AccountingDocumentType AccountingDocumentType
AccountingDocumentTypeName
DocumentDate DocumentDate
TransactionCurrency TransactionCurrency
CompanyCodeCurrency CompanyCodeCurrency
TotalAmountInCoCodeCrcy
TotalAmountInTransactionCrcy
TotalTaxAmountInCoCodeCrcy
TotalTaxAmount
NetAmountInCoCodeCurrency
NetAmountInTransacCurrency
_Item _Item 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Related Document Number for FI Invoice'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #CONSUMPTION
@ObjectModel.supportedCapabilities: [ #OUTPUT_FORM_DATA_PROVIDER ]
define view entity C_FinInvcRelatedAcctgDocFDP
  as select from I_JournalEntry
  association [1..*] to C_FinInvcRelatedAcctgDocItmFDP as _Item on  $projection.AccountingDocument = _Item.AccountingDocument
                                                                and $projection.CompanyCode        = _Item.CompanyCode
                                                                and $projection.FiscalYear         = _Item.FiscalYear
{
  key CompanyCode,
  key AccountingDocument,
  key FiscalYear,

      cast('' as rebzg )     as InvoiceReference,
      cast('0000' as rebzj ) as InvoiceReferenceFiscalYear,
      AccountingDocumentType,
      _AccountingDocumentTypeText[1:Language = $session.system_language].AccountingDocumentTypeName,
      DocumentDate,
      TransactionCurrency,
      CompanyCodeCurrency,

      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      cast( 0 as dmbtr )     as TotalAmountInCoCodeCrcy,

      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      cast( 0 as betrw_kk )  as TotalAmountInTransactionCrcy,

      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      cast( 0 as mwsts )     as TotalTaxAmountInCoCodeCrcy,

      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      cast( 0 as wmwst )     as TotalTaxAmount,

      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      cast( 0 as dmbtr )     as NetAmountInCoCodeCurrency,

      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      cast( 0 as wrbtr )     as NetAmountInTransacCurrency,

      //Assoication

      _Item
}

Learn More