R_JournalEntryOneTimeAccountTP

DDL: R_JOURNALENTRYONETIMEACCOUNTTP Type: view_entity TRANSACTIONAL
119 Fields 1 Data Sources

Journal Entry One Time Account

R_JournalEntryOneTimeAccountTP is a Transactional CDS View that provides data about "Journal Entry One Time Account" in SAP S/4HANA. It reads from 1 data source (P_JournalEntryOneTimeAcctReuse) and exposes 119 fields with key fields OneTimeAccountSourceDocType, OneTimeAccountSourceDocument, OneTimeAccountSourceDocItem, CompanyCode, AccountingDocument.

Data Sources (1)

SourceAliasJoin Type
P_JournalEntryOneTimeAcctReuse P_JournalEntryOneTimeAcctReuse from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Journal Entry One Time Account view
AbapCatalog.dataMaintenance #RESTRICTED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name JournalEntry view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (119)

KeyFieldSource TableSource FieldDescription
KEY OneTimeAccountSourceDocType OneTimeAccountSourceDocType
KEY OneTimeAccountSourceDocument OneTimeAccountSourceDocument
KEY OneTimeAccountSourceDocItem OneTimeAccountSourceDocItem
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY OneTimeAccountImageType OneTimeAccountImageType
CompanyCodeForEdit CompanyCodeForEdit Company Code
AccountingDocumentForEdit AccountingDocumentForEdit Journal Entry
FiscalYearForEdit FiscalYearForEdit Fiscal Year
AccountingDocumentItemForEdit AccountingDocumentItemForEdit Posting View Item
OneTimeAccountBPSalutationText OneTimeAccountBPSalutationText Title
Language Language Report Text Language
BusinessPartnerName1 BusinessPartnerName1 Name
BusinessPartnerName2 BusinessPartnerName2 Name 2
BusinessPartnerName3 BusinessPartnerName3 Name 3
BusinessPartnerName4 BusinessPartnerName4 Name 4
StreetName StreetName Text
POBox POBox PO Box
POBoxIsWithoutNumber POBoxIsWithoutNumber PO Box w/o No.
POBoxPostalCode POBoxPostalCode PO Box Postal Code
PostOfficeBankAccount PostOfficeBankAccount Curr.Acct or Ref.No.
CityName CityName Name
PostalCode PostalCode Postal Code
Country Country Venue: Ctry/Reg
Region Region Venue Region
EmailAddress EmailAddress E-Mail Address
AddressID AddressID Ship-to address
BankInternalID BankInternalID Bank Key
BankCountry BankCountry Bank Ctry/Rgn. Key
BankAccount BankAccount Bank acct
BankControlKey BankControlKey Control Key
BankReference BankReference Payment Reference
SWIFTCode SWIFTCode SWIFT/BIC
Bank Bank Bank Number
IBAN IBAN IBAN House Bank
QuickResponseIBAN QuickResponseIBAN QR-IBAN
IBANValidityStartDate IBANValidityStartDate IBAN Valid From
PaymentRecipient PaymentRecipient
PaymentSystem PaymentSystem Payment System
AliasType AliasType Alias Type
BPBankAccountAliasName BPBankAccountAliasName Bank Account Alias
VATRegistration VATRegistration VAT Registration No.
DataExchangeInstructionKey DataExchangeInstructionKey Instruction Key
DataMediumExchangeIndicator DataMediumExchangeIndicator DME Rec. Code
TaxID1 TaxID1 Tax Number 1
TaxID2 TaxID2 Tax Number 2
TaxID3 TaxID3 Tax Number 3
TaxID4 TaxID4 Tax Number 4
TaxID5 TaxID5 Tax Number 5
AccountTaxType AccountTaxType Tax Type
TaxNumberType TaxNumberType Tax number type
IsNaturalPerson IsNaturalPerson Natural person
OneTmeAcctIsEqualizationTxSubj OneTmeAcctIsEqualizationTxSubj Equalizatn tax
BusinessType BusinessType Type of Business
IndustryType IndustryType Type of Industry
IsVATLiable IsVATLiable Liable for VAT
RepresentativeName RepresentativeName Rep's Name
OneTimeAcctCntrySpecificRef1 OneTimeAcctCntrySpecificRef1 Country/Region Specific Reference 1
OneTimeAcctCntrySpcfcRef1Text OneTimeAcctCntrySpcfcRef1Text
OneTimeAccountTransactionType OneTimeAccountTransactionType
FiscalPeriod FiscalPeriod Tax period
TransactionCurrency TransactionCurrency Transaction Currency
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
AddressAndBankIsSetManually AddressAndBankIsSetManually Address and Bank is Set Manually
FinancialAccountType FinancialAccountType Fin. Account Type
Customer Customer Sold-to Party
Supplier Supplier Supplier
InvoiceReference InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
PostingKey PostingKey Posting Key
SpecialGLCode SpecialGLCode Special G/L Ind
IsSalesRelated IsSalesRelated Is Sales Related
DocumentDate DocumentDate Journal Entry Date
GLAccount GLAccount General Ledger
SpecialGLTransactionType SpecialGLTransactionType Transact.Type
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
HasPaymentOrder HasPaymentOrder Payment Sent
DebitCreditCode DebitCreditCode Single-Character Flag
FollowOnDocumentType FollowOnDocumentType Follow-On Document Type
BPBankAccountInternalID BPBankAccountInternalID BP Bank Account
PaytSlipWthRefSubscriber PaytSlipWthRefSubscriber PBC/POR Number
PaytSlipWthRefReference PaytSlipWthRefReference QR Reference
AlternativePayeePayer AlternativePayeePayer Alternative Payee/Payer
IsOneTimeAccount IsOneTimeAccount One-time acct
OneTimeAcctBankDetIsFromPayt OneTimeAcctBankDetIsFromPayt
LastChangeDate LastChangeDate Time Stamp
OneTimeAccountAuthznGroup OneTimeAccountAuthznGroup
OneTimeAccountDataAgingDate OneTimeAccountDataAgingDate
OneTimeAccountBankInputVariant
OneTimeAcctDetnIsNotRequired OneTimeAcctDetnIsNotRequired
AcctgDocHasQuickRspBillgSupp AcctgDocHasQuickRspBillgSupp
IBANIsQuickResponse IBANIsQuickResponse
OneTimeAcctChgIsNotAllowed OneTimeAcctChgIsNotAllowed
ReferenceAccountForIBAN ReferenceAccountForIBAN Ref. Account
QuickRepIBANIsUsdInOneTmeAcct QuickRepIBANIsUsdInOneTmeAcct
SEPAMandtIsUsdInOneTimeAcct SEPAMandtIsUsdInOneTimeAcct
OneTimeAccountIsCreatedFromAPI OneTimeAccountIsCreatedFromAPI
QuickRepRefEditIsSupported QuickRepRefEditIsSupported
OneTimeAccountFieldStatusValue OneTimeAccountFieldStatusValue
_CompanyCode _CompanyCode
_Customer _Customer
_Supplier _Supplier
_AccountingDocument _AccountingDocument
_OperationalAcctgDocItem _OperationalAcctgDocItem
_FiscalYear _FiscalYear
_Address _Address
_IBAN _IBAN
_Bank _Bank
_FinancialAccountType _FinancialAccountType
_CountryText _CountryText
_BankCountryText _BankCountryText
_LanguageText _LanguageText
_GLAccountText _GLAccountText
_DMEIndicatorText _DMEIndicatorText
_AccountTaxTypeText _AccountTaxTypeText
_TaxNumberTypeText _TaxNumberTypeText

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_JournalEntryOneTimeAccountTP.
-- 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_JournalEntryOneTimeAccountTP AS
SELECT
  OneTimeAccountSourceDocType,
  OneTimeAccountSourceDocument,
  OneTimeAccountSourceDocItem,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  OneTimeAccountImageType,
  CompanyCodeForEdit,
  AccountingDocumentForEdit,
  FiscalYearForEdit,
  AccountingDocumentItemForEdit,
  OneTimeAccountBPSalutationText,
  Language,
  BusinessPartnerName1,
  BusinessPartnerName2,
  BusinessPartnerName3,
  BusinessPartnerName4,
  StreetName,
  POBox,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  PostOfficeBankAccount,
  CityName,
  PostalCode,
  Country,
  Region,
  EmailAddress,
  AddressID,
  BankInternalID,
  BankCountry,
  BankAccount,
  BankControlKey,
  BankReference,
  SWIFTCode,
  Bank,
  IBAN,
  QuickResponseIBAN,
  IBANValidityStartDate,
  PaymentRecipient,
  PaymentSystem,
  AliasType,
  BPBankAccountAliasName,
  VATRegistration,
  DataExchangeInstructionKey,
  DataMediumExchangeIndicator,
  TaxID1,
  TaxID2,
  TaxID3,
  TaxID4,
  TaxID5,
  AccountTaxType,
  TaxNumberType,
  IsNaturalPerson,
  OneTmeAcctIsEqualizationTxSubj,
  BusinessType,
  IndustryType,
  IsVATLiable,
  RepresentativeName,
  OneTimeAcctCntrySpecificRef1,
  OneTimeAcctCntrySpcfcRef1Text,
  OneTimeAccountTransactionType,
  FiscalPeriod,
  TransactionCurrency,
  IsReversal,
  IsReversed,
  AddressAndBankIsSetManually,
  FinancialAccountType,
  Customer,
  Supplier,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  PostingKey,
  SpecialGLCode,
  IsSalesRelated,
  DocumentDate,
  GLAccount,
  SpecialGLTransactionType,
  ClearingAccountingDocument,
  HasPaymentOrder,
  DebitCreditCode,
  FollowOnDocumentType,
  BPBankAccountInternalID,
  PaytSlipWthRefSubscriber,
  PaytSlipWthRefReference,
  AlternativePayeePayer,
  IsOneTimeAccount,
  OneTimeAcctBankDetIsFromPayt,
  LastChangeDate,
  OneTimeAccountAuthznGroup,
  OneTimeAccountDataAgingDate,
  cast ('' as fota_bank_input_variant) AS OneTimeAccountBankInputVariant,
  OneTimeAcctDetnIsNotRequired,
  AcctgDocHasQuickRspBillgSupp,
  IBANIsQuickResponse,
  OneTimeAcctChgIsNotAllowed,
  ReferenceAccountForIBAN,
  QuickRepIBANIsUsdInOneTmeAcct,
  SEPAMandtIsUsdInOneTimeAcct,
  OneTimeAccountIsCreatedFromAPI,
  QuickRepRefEditIsSupported,
  OneTimeAccountFieldStatusValue
FROM P_JournalEntryOneTimeAcctReuse
;

Learn More