C_FinInvoiceHeaderFDP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_JournalEntry | I_JournalEntry | from |
Associations (10)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
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