R_JournalEntryProposalTP

DDL: R_JOURNALENTRYPROPOSALTP Type: view_entity TRANSACTIONAL Package: ODATA_MNG_JRNL_ENTRY_PROPOSALS
45 Fields 1 Data Sources 1 Associations

Journal Entry Proposal - TP

R_JournalEntryProposalTP is a Transactional CDS View that provides data about "Journal Entry Proposal - TP" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryProposal) and exposes 45 fields with key field JournalEntryProposalUUID. It has 1 association to related views. Part of development package ODATA_MNG_JRNL_ENTRY_PROPOSALS.

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryProposal I_JournalEntryProposal from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_JrnlEntrPrpslRecmddContent _ProposalText $projection.JournalEntryProposalUUID = _ProposalText.JournalEntryProposalUUID

Annotations (10)

NameValueLevelField
EndUserText.label Journal Entry Proposal - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations false view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name JournalEntryProposal view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY JournalEntryProposalUUID JournalEntryProposalUUID UUID
CompanyCode CompanyCode Receiver Company Code
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocument AccountingDocument Journal Entry
JournalEntryProposalDisplayID JournalEntryProposalDisplayID WorklistID
JrnlEntrAIAgtProposalStatus JrnlEntrAIAgtProposalStatus Workflow Status
JournalEntryProposalCategory JournalEntryProposalCategory Violation Category
TransactionCode TransactionCode Transaction Code
JournalEntryProposalBatchID JournalEntryProposalBatchID
AccountingDocumentType AccountingDocumentType Journal Entry Type
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
FiscalPeriod FiscalPeriod Tax period
FiscalYearPeriod
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
TransactionCurrency TransactionCurrency Transaction Currency
LedgerGroup LedgerGroup Ledger Group
AbsoluteExchangeRate AbsoluteExchangeRate Absolute Exchange Rate
ExchangeRateDate ExchangeRateDate Translatn Date
DocumentReferenceID DocumentReferenceID Reference
TaxFulfillmentDate TaxFulfillmentDate Tax Settlement Date
TaxIsCalculatedAutomatically TaxIsCalculatedAutomatically Tax Is Automatically Calculated
ReversalReason ReversalReason Reversal Reason
PlannedReversalDate PlannedReversalDate Reversal Date
IsReversed IsReversed Reversed?
OriginalLanguage OriginalLanguage Original Language
JrnlEntrPrpslOriglReasoningTxt JrnlEntrPrpslOriglReasoningTxt
JrnlEntrPrpslOriginalStepText JrnlEntrPrpslOriginalStepText Step Number
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
JournalEntryCreatedByUser JournalEntryCreatedByUser
JournalEntryCreationDateTime JournalEntryCreationDateTime
JrnlEntryProposalTemporaryID JrnlEntryProposalTemporaryID Temp. Document ID
char20asLogoImageURL
char1asJrnlEntrPrpslCatIsHidden
_AccountingDocumentType _AccountingDocumentType
_CompanyCode _CompanyCode
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_JournalEntryCreatedByUser _JournalEntryCreatedByUser
_JrnlEntrAIAgtProposalStatus _JrnlEntrAIAgtProposalStatus
_ReversalReason _ReversalReason
_ProposalText _ProposalText

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 R_JournalEntryProposalTP.
-- 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 R_JournalEntryProposalTP AS
SELECT
  JournalEntryProposalUUID,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  JournalEntryProposalDisplayID,
  JrnlEntrAIAgtProposalStatus,
  JournalEntryProposalCategory,
  TransactionCode,
  JournalEntryProposalBatchID,
  AccountingDocumentType,
  DocumentDate,
  PostingDate,
  FiscalPeriod,
  cast(concat(FiscalYear, FiscalPeriod) as fins_fyearperiod) AS FiscalYearPeriod,
  AccountingDocumentHeaderText,
  TransactionCurrency,
  LedgerGroup,
  AbsoluteExchangeRate,
  ExchangeRateDate,
  DocumentReferenceID,
  TaxFulfillmentDate,
  TaxIsCalculatedAutomatically,
  ReversalReason,
  PlannedReversalDate,
  IsReversed,
  OriginalLanguage,
  JrnlEntrPrpslOriglReasoningTxt,
  JrnlEntrPrpslOriginalStepText,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  JournalEntryCreatedByUser,
  JournalEntryCreationDateTime,
  JrnlEntryProposalTemporaryID,
  cast( case when JrnlEntrAIAgtProposalStatus = 'OPEN' then 'sap-icon: else 'sap-icon: end as abap.char(20) ) as LogoImageURL AS char20asLogoImageURL,
  cast( case TransactionCode when 'FBDC_P052A'then '' when 'FBDC_P052' then '' else 'X' end as abap.char(1)) as JrnlEntrPrpslCatIsHidden AS char1asJrnlEntrPrpslCatIsHidden
FROM I_JournalEntryProposal
LEFT OUTER JOIN I_JrnlEntrPrpslRecmddContent AS _ProposalText ON JournalEntryProposalUUID = _ProposalText.JournalEntryProposalUUID  -- association [0..*]
;

Learn More