C_CFinPndgTransDocument_F5482

DDL: C_CFINPNDGTRANSDOCUMENT_F5482 Type: view_entity CONSUMPTION Package: FINS_CFIN_TMP_POST_UI

CFIN Pending Transaction Document

C_CFinPndgTransDocument_F5482 is a Consumption CDS View that provides data about "CFIN Pending Transaction Document" in SAP S/4HANA. It reads from 1 data source (I_CFinPndgTransactionDocument) and exposes 27 fields with key fields CFinRpldTransactionUUID, SenderLogicalSystem, SenderCompanyCode, SenderAccountingDocument, SenderFiscalYear. It is exposed through 2 OData services (UI_CFINPNDGTRANSACTION_F5482, UI_CFINPNDGTRANSMSG_F7149). Part of development package FINS_CFIN_TMP_POST_UI.

Data Sources (1)

SourceAliasJoin Type
I_CFinPndgTransactionDocument I_CFinPndgTransactionDocument projection

Annotations (7)

NameValueLevelField
EndUserText.label CFIN Pending Transaction Document view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
UI_CFINPNDGTRANSACTION_F5482 UI_CFINPNDGTRANSACT_F5482 V2 C1 NOT_RELEASED
UI_CFINPNDGTRANSMSG_F7149 UI_CFINPNDGTRANSMSG_F7149 V2 C1 NOT_RELEASED

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY CFinRpldTransactionUUID CFinRpldTransactionUUID
KEY SenderLogicalSystem SenderLogicalSystem Sender Logical System
KEY SenderCompanyCode SenderCompanyCode Sender Company Code
KEY SenderAccountingDocument SenderAccountingDocument Sender Journal Entry
KEY SenderFiscalYear SenderFiscalYear Sender FiscalYr
SourceReferenceDocumentType _Transaction SourceReferenceDocumentType Ref. procedure
SourceReferenceDocument _Transaction SourceReferenceDocument Reference Doc.
SourceReferenceDocumentCntxt _Transaction SourceReferenceDocumentCntxt
SourceRefDocLogicalSystem _Transaction SourceRefDocLogicalSystem
CFinRpldTransCreationDateTime _Transaction CFinRpldTransCreationDateTime
TransactionCode _Transaction TransactionCode Transaction Code
CFinRpldTransNamespace _Transaction CFinRpldTransNamespace
CFinRpldTransInterfaceName _Transaction CFinRpldTransInterfaceName
CFinRpldTransInterfaceVersion _Transaction CFinRpldTransInterfaceVersion
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
TotalAmountInLocalCurrency TotalAmountInLocalCurrency RNPT Item Amount
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TotalAmountInGroupCrcy TotalAmountInGroupCrcy
GroupCurrency GroupCurrency Ledger curr.
CFinPndgDocHasTemporaryPosting CFinPndgDocHasTemporaryPosting
CFinTemporaryPosting CFinTemporaryPosting

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 C_CFinPndgTransDocument_F5482.
-- 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 C_CFinPndgTransDocument_F5482 AS
SELECT
  CFinRpldTransactionUUID,
  SenderLogicalSystem,
  SenderCompanyCode,
  SenderAccountingDocument,
  SenderFiscalYear,
  _Transaction.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  _Transaction.SourceReferenceDocument AS SourceReferenceDocument,
  _Transaction.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  _Transaction.SourceRefDocLogicalSystem AS SourceRefDocLogicalSystem,
  _Transaction.CFinRpldTransCreationDateTime AS CFinRpldTransCreationDateTime,
  _Transaction.TransactionCode AS TransactionCode,
  _Transaction.CFinRpldTransNamespace AS CFinRpldTransNamespace,
  _Transaction.CFinRpldTransInterfaceName AS CFinRpldTransInterfaceName,
  _Transaction.CFinRpldTransInterfaceVersion AS CFinRpldTransInterfaceVersion,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  FiscalYear,
  AccountingDocumentType,
  _AccountingDocumentTypeText[1:Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  DocumentDate,
  PostingDate,
  TotalAmountInLocalCurrency,
  CompanyCodeCurrency,
  TotalAmountInGroupCrcy,
  GroupCurrency,
  CFinPndgDocHasTemporaryPosting,
  CFinTemporaryPosting
FROM I_CFinPndgTransactionDocument
;