C_FinInvcRelatedAcctgDocItmFDP
FI Invoice Related Acctg Doc Item
C_FinInvcRelatedAcctgDocItmFDP is a Consumption CDS View that provides data about "FI Invoice Related Acctg Doc Item" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 94 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. It has 2 associations to related views. Part of development package FINS_OUTPUT_MGMT_FO_FICUS_INV.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_OperationalAcctgDocItem | I_OperationalAcctgDocItem | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [*] | I_PostingKeyWthSpclGLCodeTxt | _PostingKeyWthSpclGLCodeTxt | $projection.PostingKey =_PostingKeyWthSpclGLCodeTxt.PostingKey and $projection.SpecialGLCode = _PostingKeyWthSpclGLCodeTxt.SpecialGLCode |
| [*] | I_GLAccountText | _GLAccountText | $projection.ChartOfAccounts = _GLAccountText.ChartOfAccounts and $projection.GLAccount = _GLAccountText.GLAccount |
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 | FI Invoice Related Acctg Doc Item | view |
Fields (94)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | CompanyCode | ||
| KEY | FiscalYear | FiscalYear | ||
| KEY | AccountingDocument | AccountingDocument | ||
| KEY | AccountingDocumentItem | AccountingDocumentItem | ||
| AccountingDocumentItemType | AccountingDocumentItemType | |||
| PostingKey | PostingKey | |||
| PostingKeyName | ||||
| GLAccount | GLAccount | |||
| GLAccountName | ||||
| GLAccountLongName | ||||
| Customer | Customer | |||
| CustomerName | _Customer | CustomerName | ||
| CustomerFullName | _Customer | CustomerFullName | ||
| Supplier | Supplier | |||
| SupplierName | _Supplier | SupplierName | ||
| SupplierFullName | _Supplier | SupplierFullName | ||
| ClearingDate | ClearingDate | |||
| ClearingDocFiscalYear | ClearingDocFiscalYear | |||
| ClearingJournalEntry | ClearingJournalEntry | |||
| FinancialAccountType | FinancialAccountType | |||
| SpecialGLCode | SpecialGLCode | |||
| SpecialGLTransactionType | SpecialGLTransactionType | |||
| BaseUnit | BaseUnit | |||
| Quantity | Quantity | |||
| DebitCreditCode | DebitCreditCode | |||
| FiscalPeriod | FiscalPeriod | |||
| TransactionTypeDetermination | TransactionTypeDetermination | |||
| DocumentItemText | DocumentItemText | |||
| Product | Product | |||
| Plant | Plant | |||
| ValuationArea | ValuationArea | |||
| InventoryValuationType | InventoryValuationType | |||
| DueCalculationBaseDate | DueCalculationBaseDate | |||
| PaymentTerms | PaymentTerms | |||
| CashDiscount1Days | CashDiscount1Days | |||
| CashDiscount2Days | CashDiscount2Days | |||
| NetPaymentDays | NetPaymentDays | |||
| CashDiscount1Percent | CashDiscount1Percent | |||
| CashDiscount2Percent | CashDiscount2Percent | |||
| VATRegistration | VATRegistration | |||
| InvoiceReference | InvoiceReference | |||
| InvoiceReferenceFiscalYear | InvoiceReferenceFiscalYear | |||
| FollowOnDocumentType | FollowOnDocumentType | |||
| InvoiceItemReference | InvoiceItemReference | |||
| GoodsMovementEntryUnit | GoodsMovementEntryUnit | |||
| QuantityInEntryUnit | QuantityInEntryUnit | |||
| DelivOfGoodsDestCountry | DelivOfGoodsDestCountry | |||
| DelivOfGoodsOriginCountry | DelivOfGoodsOriginCountry | |||
| TaxCountry | TaxCountry | |||
| TaxCode | TaxCode | |||
| TaxType | TaxType | |||
| TaxItemGroup | TaxItemGroup | |||
| TaxRateValidityStartDate | TaxRateValidityStartDate | |||
| TaxDeterminationDate | TaxDeterminationDate | |||
| WithholdingTaxCode | WithholdingTaxCode | |||
| TransactionCurrency | TransactionCurrency | |||
| AmountInTransactionCurrency | AmountInTransactionCurrency | |||
| CompanyCodeCurrency | CompanyCodeCurrency | |||
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | |||
| BalanceTransactionCurrency | BalanceTransactionCurrency | |||
| AmountInBalanceTransacCrcy | AmountInBalanceTransacCrcy | |||
| OriglTaxBaseAmountInCoCodeCrcy | OriglTaxBaseAmountInCoCodeCrcy | |||
| OriginalTaxBaseAmount | OriginalTaxBaseAmount | |||
| TaxAmountInCoCodeCrcy | TaxAmountInCoCodeCrcy | |||
| TaxAmount | TaxAmount | |||
| TaxBaseAmountInCoCodeCrcy | TaxBaseAmountInCoCodeCrcy | |||
| TaxBaseAmountInTransCrcy | TaxBaseAmountInTransCrcy | |||
| WithholdingTaxBaseAmount | WithholdingTaxBaseAmount | |||
| ChartOfAccounts | ChartOfAccounts | |||
| ServiceDocumentType | ServiceDocumentType | |||
| MasterFixedAsset | MasterFixedAsset | |||
| AccountingDocumentType | AccountingDocumentType | |||
| IsSalesRelated | IsSalesRelated | |||
| IsOpenItemManaged | IsOpenItemManaged | |||
| ServiceDocument | ServiceDocument | |||
| FixedAsset | FixedAsset | |||
| PostingDate | PostingDate | |||
| OrderID | OrderID | |||
| SalesDocument | SalesDocument | |||
| FunctionalArea | FunctionalArea | |||
| CostCenter | CostCenter | |||
| ControllingArea | ControllingArea | |||
| Segment | Segment | |||
| ProfitCenter | ProfitCenter | |||
| _Customer | _Customer | |||
| _Supplier | _Supplier | |||
| _GLAccountInCompanyCode | _GLAccountInCompanyCode | |||
| _ServiceDocument | _ServiceDocument | |||
| _SalesDoc | _SalesDoc | |||
| _FixedAsset | _FixedAsset | |||
| _Order | _Order | |||
| _CurrentCostCenter | _CurrentCostCenter | |||
| _CurrentProfitCenter | _CurrentProfitCenter | |||
| _AccountingDocumentType | _AccountingDocumentType |
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.supportedCapabilities: [ #OUTPUT_FORM_DATA_PROVIDER ]
@EndUserText.label: 'FI Invoice Related Acctg Doc Item'
define view entity C_FinInvcRelatedAcctgDocItmFDP as select from I_OperationalAcctgDocItem
association [*] to I_PostingKeyWthSpclGLCodeTxt as _PostingKeyWthSpclGLCodeTxt on $projection.PostingKey =_PostingKeyWthSpclGLCodeTxt.PostingKey
and $projection.SpecialGLCode = _PostingKeyWthSpclGLCodeTxt.SpecialGLCode
association [*] to I_GLAccountText as _GLAccountText on $projection.ChartOfAccounts = _GLAccountText.ChartOfAccounts
and $projection.GLAccount = _GLAccountText.GLAccount
{
key CompanyCode,
key FiscalYear,
key AccountingDocument,
key AccountingDocumentItem,
AccountingDocumentItemType,
PostingKey,
_PostingKeyWthSpclGLCodeTxt[1:Language = $session.system_language].PostingKeyName,
GLAccount,
_GLAccountText[1:Language = $session.system_language].GLAccountName,
_GLAccountText[1:Language = $session.system_language].GLAccountLongName,
Customer,
_Customer.CustomerName,
_Customer.CustomerFullName,
Supplier,
_Supplier.SupplierName,
_Supplier.SupplierFullName,
ClearingDate,
// ClearingAccountingDocument,
ClearingDocFiscalYear,
ClearingJournalEntry,
FinancialAccountType,
// UMSKZ
SpecialGLCode,
// UMSKS
SpecialGLTransactionType,
BaseUnit,
Quantity,
DebitCreditCode,
FiscalPeriod,
TransactionTypeDetermination,
DocumentItemText,
Product,
Plant,
ValuationArea,
InventoryValuationType,
DueCalculationBaseDate,
PaymentTerms,
CashDiscount1Days,
CashDiscount2Days,
NetPaymentDays,
CashDiscount1Percent,
CashDiscount2Percent,
VATRegistration,
InvoiceReference,
InvoiceReferenceFiscalYear,
FollowOnDocumentType,
InvoiceItemReference,
GoodsMovementEntryUnit,
@Semantics: { quantity : {unitOfMeasure: 'GoodsMovementEntryUnit'} }
QuantityInEntryUnit,
DelivOfGoodsDestCountry,
DelivOfGoodsOriginCountry,
TaxCountry,
TaxCode,
TaxType,
TaxItemGroup,
TaxRateValidityStartDate,
TaxDeterminationDate,
WithholdingTaxCode,
TransactionCurrency,
AmountInTransactionCurrency,
CompanyCodeCurrency,
AmountInCompanyCodeCurrency,
BalanceTransactionCurrency,
AmountInBalanceTransacCrcy,
OriglTaxBaseAmountInCoCodeCrcy,
OriginalTaxBaseAmount,
TaxAmountInCoCodeCrcy,
TaxAmount,
TaxBaseAmountInCoCodeCrcy,
TaxBaseAmountInTransCrcy,
WithholdingTaxBaseAmount,
ChartOfAccounts,
ServiceDocumentType,
MasterFixedAsset,
AccountingDocumentType,
IsSalesRelated,
IsOpenItemManaged,
/* Access Control */
ServiceDocument,
FixedAsset,
PostingDate,
OrderID,
SalesDocument,
FunctionalArea,
CostCenter,
ControllingArea,
Segment,
ProfitCenter,
/* Associations */
_Customer,
_Supplier,
/*For Access Control*/
_GLAccountInCompanyCode,
_ServiceDocument,
_SalesDoc,
_FixedAsset,
_Order,
_CurrentCostCenter,
_CurrentProfitCenter,
_AccountingDocumentType
}
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