C_FinInvoiceHeaderFDP

DDL: C_FININVOICEHEADERFDP Type: view_entity CONSUMPTION Package: FINS_OUTPUT_MGMT_FO_FICUS_INV

Corr Type SAP21 Invc Hdr

C_FinInvoiceHeaderFDP is a Consumption CDS View that provides data about "Corr Type SAP21 Invc Hdr" in SAP S/4HANA. It reads from 1 data source (I_JournalEntry) and exposes 53 fields with key fields CompanyCode, FiscalYear, AccountingDocument. It has 10 associations to related views. Part of development package FINS_OUTPUT_MGMT_FO_FICUS_INV.

Data Sources (1)

SourceAliasJoin Type
I_JournalEntry I_JournalEntry from

Associations (10)

CardinalityTargetAliasCondition
[1..*] C_FinInvoiceItemFDP _Item $projection.AccountingDocument = _Item.AccountingDocument and $projection.CompanyCode = _Item.CompanyCode and $projection.FiscalYear = _Item.FiscalYear
[1..1] C_FinInvoiceItemFDP _ARItem $projection.AccountingDocument = _ARItem.AccountingDocument and $projection.CompanyCode = _ARItem.CompanyCode and $projection.FiscalYear = _ARItem.FiscalYear and _ARItem.FinancialAccountType = 'D'
[1..*] C_FinInvoiceItemFDP _GLItem $projection.AccountingDocument = _GLItem.AccountingDocument and $projection.CompanyCode = _GLItem.CompanyCode and $projection.FiscalYear = _GLItem.FiscalYear and _GLItem.FinancialAccountType = 'S'
[1..*] C_FinInvcRelatedAcctgDocFDP _RelatedAcctgDoc $projection.AccountingDocument = _RelatedAcctgDoc.InvoiceReference and $projection.CompanyCode = _RelatedAcctgDoc.CompanyCode and $projection.FiscalYear = _RelatedAcctgDoc.InvoiceReferenceFiscalYear
[1..*] C_FinInvoiceODNFDP _ODN $projection.AccountingDocument = _ODN.AccountingDocument and $projection.CompanyCode = _ODN.CompanyCode and $projection.FiscalYear = _ODN.FiscalYear
[1..1] C_FinInvoiceCompanyCodeFDP _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..*] C_FinInvoiceTaxItemFDP _TaxItem $projection.AccountingDocument = _TaxItem.AccountingDocument and $projection.CompanyCode = _TaxItem.CompanyCode and $projection.FiscalYear = _TaxItem.FiscalYear
[1..*] C_FinInvoiceHeaderNoteFDP _HeaderNote $projection.AccountingDocument = _HeaderNote.AccountingDocument and $projection.CompanyCode = _HeaderNote.CompanyCode and $projection.FiscalYear = _HeaderNote.FiscalYear
[0..*] I_AccountingDocumentTypeText _AccountingDocumentTypeText $projection.AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType
[0..*] I_ReferenceDocumentTypeText _ReferenceDocumentTypeText $projection.ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Corr Type SAP21 Invc Hdr view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY FiscalYear FiscalYear
KEY AccountingDocument AccountingDocument
AccountingDocumentType AccountingDocumentType
AccountingDocumentTypeName
DocumentDate DocumentDate
PostingDate PostingDate
FiscalPeriod FiscalPeriod
AccountingDocumentHeaderText AccountingDocumentHeaderText
TransactionCurrency TransactionCurrency
CompanyCodeCurrency CompanyCodeCurrency
AbsoluteExchangeRate AbsoluteExchangeRate
ExchangeRateDate ExchangeRateDate
ExchangeRateType ExchangeRateType
ReferenceDocumentType ReferenceDocumentType
ReferenceDocumentTypeName
OriginalReferenceDocument OriginalReferenceDocument
Reference1InDocumentHeader Reference1InDocumentHeader
Reference2InDocumentHeader Reference2InDocumentHeader
TaxIsCalculatedAutomatically TaxIsCalculatedAutomatically
TaxBaseAmountIsNetAmount TaxBaseAmountIsNetAmount
TaxReportingDate TaxReportingDate
TaxFulfillmentDate TaxFulfillmentDate
TaxExchangeRate
IsDiscountDocument IsDiscountDocument
Ledger Ledger
LedgerGroup LedgerGroup
DocumentReferenceID DocumentReferenceID
ReverseDocument ReverseDocument
ReverseDocumentFiscalYear ReverseDocumentFiscalYear
IsReversal IsReversal
IsReversed IsReversed
ReversalReason ReversalReason
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt
ReversalReferenceDocument ReversalReferenceDocument
TransactionCode TransactionCode
InvoiceHasMultiplePaymentTerms
NetAmountInCoCodeCurrency
NetAmountInTransacCurrency
InvoiceAlreadyPaidAmtInCCCrcy
TotalAmountInCoCodeCrcy
TotalAmountInTransactionCrcy
OpenAmountInCompanyCodeCrcy
ControllingArea _CompanyCode ControllingArea
ControllingAreaName _CompanyCode ControllingAreaName
_Item _Item
_ARItem _ARItem
_GLItem _GLItem
_RelatedAcctgDoc _RelatedAcctgDoc
_ODN _ODN
_CompanyCode _CompanyCode
_TaxItem _TaxItem
_HeaderNote _HeaderNote
@AbapCatalog.viewEnhancementCategory: [#NONE]

@VDM.viewType: #CONSUMPTION

@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.supportedCapabilities: [ #OUTPUT_FORM_DATA_PROVIDER ]

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED

@EndUserText.label: 'Corr Type SAP21 Invc Hdr'
define view entity C_FinInvoiceHeaderFDP
  as select from I_JournalEntry

  association [1..*] to C_FinInvoiceItemFDP          as _Item                       on  $projection.AccountingDocument = _Item.AccountingDocument
                                                                                    and $projection.CompanyCode        = _Item.CompanyCode
                                                                                    and $projection.FiscalYear         = _Item.FiscalYear
  
  association [1..1] to C_FinInvoiceItemFDP          as _ARItem                     on  $projection.AccountingDocument = _ARItem.AccountingDocument
                                                                                    and $projection.CompanyCode        = _ARItem.CompanyCode
                                                                                    and $projection.FiscalYear         = _ARItem.FiscalYear
                                                                                    and _ARItem.FinancialAccountType   = 'D'

  association [1..*] to C_FinInvoiceItemFDP          as _GLItem                     on  $projection.AccountingDocument = _GLItem.AccountingDocument
                                                                                    and $projection.CompanyCode        = _GLItem.CompanyCode
                                                                                    and $projection.FiscalYear         = _GLItem.FiscalYear
                                                                                    and _GLItem.FinancialAccountType   = 'S'
  
  association [1..*] to C_FinInvcRelatedAcctgDocFDP  as _RelatedAcctgDoc            on  $projection.AccountingDocument = _RelatedAcctgDoc.InvoiceReference
                                                                                    and $projection.CompanyCode        = _RelatedAcctgDoc.CompanyCode
                                                                                    and $projection.FiscalYear         = _RelatedAcctgDoc.InvoiceReferenceFiscalYear
  
  association [1..*] to C_FinInvoiceODNFDP           as _ODN                        on  $projection.AccountingDocument = _ODN.AccountingDocument
                                                                                    and $projection.CompanyCode        = _ODN.CompanyCode
                                                                                    and $projection.FiscalYear         = _ODN.FiscalYear
                                                                                    
  association [1..1] to C_FinInvoiceCompanyCodeFDP   as _CompanyCode                on  $projection.CompanyCode        = _CompanyCode.CompanyCode  
  
  association [1..*] to C_FinInvoiceTaxItemFDP       as _TaxItem                    on  $projection.AccountingDocument = _TaxItem.AccountingDocument
                                                                                    and $projection.CompanyCode        = _TaxItem.CompanyCode
                                                                                    and $projection.FiscalYear         = _TaxItem.FiscalYear          
  
  association [1..*] to C_FinInvoiceHeaderNoteFDP    as _HeaderNote                 on  $projection.AccountingDocument = _HeaderNote.AccountingDocument
                                                                                    and $projection.CompanyCode        = _HeaderNote.CompanyCode
                                                                                    and $projection.FiscalYear         = _HeaderNote.FiscalYear                                                                                                                                                     
                                                                                    
  association [0..*] to I_AccountingDocumentTypeText as _AccountingDocumentTypeText on  $projection.AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType

  association [0..*] to I_ReferenceDocumentTypeText  as _ReferenceDocumentTypeText  on  $projection.ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType

//  association [1..1] to I_CurrencyTypesCorrespnc as _CurrencyTypesCorrespnc         on  $projection.CompanyCode       = _CurrencyTypesCorrespnc.CompanyCode

//                                                                                    and $projection.SourceLedger      = _CurrencyTypesCorrespnc.Ledger

                                                                                
//  association [0..*] to C_CorrespondenceHeaderNote   as _CorrespondenceHeaderNote   on  $projection.CompanyCode = _CorrespondenceHeaderNote.CompanyCode and

//                                                                                        $projection.FiscalYear = _CorrespondenceHeaderNote.FiscalYear and

//                                                                                        $projection.AccountingDocument = _CorrespondenceHeaderNote.AccountingDocument

{
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
      AccountingDocumentType,
      _AccountingDocumentTypeText[1:Language = $session.system_language].AccountingDocumentTypeName,
      DocumentDate,
      PostingDate,
      FiscalPeriod,
      AccountingDocumentHeaderText,
      TransactionCurrency,
      CompanyCodeCurrency,
      AbsoluteExchangeRate,
      ExchangeRateDate,
      ExchangeRateType,
      
      ReferenceDocumentType,
      _ReferenceDocumentTypeText[1:Language = $session.system_language].ReferenceDocumentTypeName,
      OriginalReferenceDocument,
      Reference1InDocumentHeader,
      Reference2InDocumentHeader,
      
      TaxIsCalculatedAutomatically,
      TaxBaseAmountIsNetAmount,
      TaxReportingDate,
      TaxFulfillmentDate,
      cast( TaxExchangeRate as wlf_txkrs_no_cnext ) as TaxExchangeRate,
      
      IsDiscountDocument,      
      
      Ledger,
      LedgerGroup,
      DocumentReferenceID,
      ReverseDocument,
      ReverseDocumentFiscalYear,
      IsReversal,
      IsReversed,
      ReversalReason,
      ReversalReferenceDocumentCntxt,
      ReversalReferenceDocument,
      TransactionCode,
      
      cast( ' ' as cimic_multiple_payment_terms ) as InvoiceHasMultiplePaymentTerms,
      
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      cast( '0' as wrbtr ) as NetAmountInCoCodeCurrency,
      
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      cast( '0' as wrbtr ) as NetAmountInTransacCurrency,
      
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      cast( '0' as wrbtr ) as InvoiceAlreadyPaidAmtInCCCrcy,
            
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      cast( '0' as wrbtr)  as TotalAmountInCoCodeCrcy,
      
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      cast( '0' as wrbtr)  as TotalAmountInTransactionCrcy,
                  
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      cast( '0' as wrbtr)  as OpenAmountInCompanyCodeCrcy,
            
//      AccountingDocumentCreationDate,

//      CreationTime,

//      LastManualChangeDate,

//      LastAutomaticChangeDate,

//      LastChangeDate,

//      

//      AccountingDocCreatedByUser,

//      IntercompanyTransaction,

//      

//      RecurringAccountingDocument,                     

//      AccountingDocumentCategory,

//      BusinessTransactionType,

//      BatchInputSession,           

//      FinancialManagementArea,      

//      AdditionalCurrency1,

//      AdditionalCurrency2,

//      ReversalIsPlanned,

//      PlannedReversalDate,      

//      SourceCompanyCode,

//      LogicalSystem,

//      ReferenceDocumentLogicalSystem,            

//      ParkingDate,

//      ParkingTime,

//      Branch,

//      NmbrOfPages,      

//      InvoiceReceiptDate,      

//      cast(AlternativeReferenceDocument as fis_xblnr_alt_alpha) as AlternativeReferenceDocument,      

//      AccountingDocumentClass,      

//      SenderLogicalSystem,

//      SenderCompanyCode,

//      SenderAccountingDocument,

//      SenderFiscalYear,      

//      LatePaymentReason,

//      SalesDocumentCondition,      

//      Ledger as SourceLedger,

      
      _CompanyCode.ControllingArea,
      _CompanyCode.ControllingAreaName,

      //Associations

      _Item,
      _ARItem,
      _GLItem,
      _RelatedAcctgDoc,
      _ODN,
      _CompanyCode,
      _TaxItem,
      _HeaderNote
//      _CurrencyTypesCorrespnc,

      
//      @ObjectModel.filter.enabled: false

//      _CorrespondenceHeaderNote

}