I_CFinPndgTransDocumentItem

DDL: I_CFINPNDGTRANSDOCUMENTITEM Type: view_entity COMPOSITE
43 Fields 1 Data Sources 1 Associations

CFIN Pndg Transaction Document Item

I_CFinPndgTransDocumentItem is a Composite CDS View that provides data about "CFIN Pndg Transaction Document Item" in SAP S/4HANA. It reads from 1 data source (I_CFinRpldTransDocumentItem) and exposes 43 fields with key fields CFinRpldTransactionUUID, AccountingDocumentItemRef, SenderLogicalSystem, SenderCompanyCode, SenderAccountingDocument. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CFinRpldTransDocumentItem I_CFinRpldTransDocumentItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CFinPendingTransaction _Transaction $projection.CFinRpldTransactionUUID = _Transaction.CFinRpldTransactionUUID

Annotations (6)

NameValueLevelField
EndUserText.label CFIN Pndg Transaction Document Item view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY CFinRpldTransactionUUID CFinRpldTransactionUUID
KEY AccountingDocumentItemRef AccountingDocumentItemRef Position
KEY SenderLogicalSystem SenderLogicalSystem Sender Logical System
KEY SenderCompanyCode SenderCompanyCode Sender Company Code
KEY SenderAccountingDocument SenderAccountingDocument Sender Journal Entry
KEY SenderFiscalYear SenderFiscalYear Sender FiscalYr
CompanyCode CompanyCode Receiver Company Code
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocumentItem AccountingDocumentItem Posting View Item
PostingKey PostingKey Posting Key
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
GroupCurrency GroupCurrency Ledger curr.
AmountInGroupCurrency AmountInGroupCurrency Amnt in GrpCrcy
DebitCreditCode DebitCreditCode Single-Character Flag
TaxCode TaxCode Tax Code
SpecialGLCode SpecialGLCode Special G/L Ind
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
FinancialAccountType FinancialAccountType Fin. Account Type
ChartOfAccounts ChartOfAccounts Node Class
GLAccount GLAccount General Ledger
Supplier Supplier Supplier
Customer Customer Sold-to Party
TradingPartner TradingPartner Trading Partner
Material Material Vehicle Model
FinancialTransactionType FinancialTransactionType Transact. Type
_Transaction _Transaction
_Document _Document
_SenderLogicalSystem _SenderLogicalSystem
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_CompanyCodeCurrency _CompanyCodeCurrency
_TransactionCurrency _TransactionCurrency
_Supplier _Supplier
_Customer _Customer
_ChartOfAccountsText _ChartOfAccountsText
_ProfitCenterTxt _ProfitCenterTxt
_CostCenterTxt _CostCenterTxt
_GLAccountTxt _GLAccountTxt

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CFinPndgTransDocumentItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_CFinPndgTransDocumentItem AS
SELECT
  CFinRpldTransactionUUID,
  AccountingDocumentItemRef,
  SenderLogicalSystem,
  SenderCompanyCode,
  SenderAccountingDocument,
  SenderFiscalYear,
  CompanyCode,
  FiscalYear,
  AccountingDocumentItem,
  PostingKey,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GroupCurrency,
  AmountInGroupCurrency,
  DebitCreditCode,
  TaxCode,
  SpecialGLCode,
  ControllingArea,
  CostCenter,
  ProfitCenter,
  FinancialAccountType,
  ChartOfAccounts,
  GLAccount,
  Supplier,
  Customer,
  TradingPartner,
  Material,
  FinancialTransactionType
FROM I_CFinRpldTransDocumentItem
LEFT OUTER JOIN I_CFinPendingTransaction AS _Transaction ON CFinRpldTransactionUUID = _Transaction.CFinRpldTransactionUUID  -- association [0..1]
;

Learn More