C_FinInvcRelatedAcctgDocItmFDP

DDL: C_FININVCRELATEDACCTGDOCITMFDP Type: view_entity CONSUMPTION Package: FINS_OUTPUT_MGMT_FO_FICUS_INV

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)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Associations (2)

CardinalityTargetAliasCondition
[*] 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)

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 FI Invoice Related Acctg Doc Item view

Fields (94)

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