C_JournalEntryOneTimeAccountTP
Journal Entry One Time Account
C_JournalEntryOneTimeAccountTP is a Consumption CDS View that provides data about "Journal Entry One Time Account" in SAP S/4HANA. It reads from 1 data source (R_JournalEntryOneTimeAccountTP) and exposes 148 fields with key fields OneTimeAccountSourceDocType, OneTimeAccountSourceDocument, OneTimeAccountSourceDocItem, CompanyCode, AccountingDocument.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_JournalEntryOneTimeAccountTP | R_JournalEntryOneTimeAccountTP | projection |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Journal Entry One Time Account | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view |
Fields (148)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 | ||
| CompanyCodeName | _CompanyCode | CompanyCodeName | Company Name | |
| AccountingDocumentForEdit | AccountingDocumentForEdit | Journal Entry | ||
| FiscalYearForEdit | FiscalYearForEdit | Fiscal Year | ||
| AccountingDocumentItemForEdit | AccountingDocumentItemForEdit | Posting View Item | ||
| OneTimeAccountBPSalutationText | OneTimeAccountBPSalutationText | Title | ||
| Language | Language | Report Text Language | ||
| LanguageNamelocalized | ||||
| 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 | Country/Region | ||
| CountryNamelocalized | ||||
| Region | Region | Venue Region | ||
| EmailAddress | EmailAddress | E-Mail Address | ||
| AddressID | AddressID | Ship-to address | ||
| BankInternalID | BankInternalID | Bank Key | ||
| BankName | _Bank | BankName | Bank Name | |
| BankCountry | BankCountry | Bank Ctry/Rgn. Key | ||
| CountryNameasBankCountryNamelocalized | ||||
| 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 Indicator | ||
| 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 | Sales Equalization 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 | ||
| CustomerName | _Customer | CustomerName | Name of Customer | |
| Supplier | Supplier | Supplier | ||
| SupplierName | _Supplier | SupplierName | Supplier Name | |
| 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 | ||
| GLAccountNamelocalized | ||||
| 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 | ||
| AlternativePayeeIsAllowed | AlternativePayeeIsAllowed | Payee in doc. | ||
| OneTimeAcctBankDetIsFromPayt | OneTimeAcctBankDetIsFromPayt | |||
| LastChangeDate | LastChangeDate | Time Stamp | ||
| OneTimeAccountBankInputVariant | OneTimeAccountBankInputVariant | |||
| OneTimeAccountAuthznGroup | OneTimeAccountAuthznGroup | |||
| OneTimeAccountDataAgingDate | OneTimeAccountDataAgingDate | |||
| OneTimeAcctDetnIsNotRequired | OneTimeAcctDetnIsNotRequired | |||
| AcctgDocHasQuickRspBillgSupp | AcctgDocHasQuickRspBillgSupp | |||
| QuickRepIBANIsUsdInOneTmeAcct | QuickRepIBANIsUsdInOneTmeAcct | |||
| SEPAMandtIsUsdInOneTimeAcct | SEPAMandtIsUsdInOneTimeAcct | |||
| QuickRepRefEditIsSupported | QuickRepRefEditIsSupported | |||
| IBANIsQuickResponse | IBANIsQuickResponse | |||
| ReferenceAccountForIBAN | ReferenceAccountForIBAN | Ref. Account | ||
| OneTimeAcctChgIsNotAllowed | OneTimeAcctChgIsNotAllowed | |||
| virtualUICT_Languageabap_boolean | ||||
| virtualUICT_StreetNameabap_boolean | ||||
| virtualUICT_POBoxabap_boolean | ||||
| virtualUICT_POBoxPostalCodeabap_boolean | ||||
| virtualUICT_CityNameabap_boolean | ||||
| virtualUICT_PostalCodeabap_boolean | ||||
| virtualUICT_Countryabap_boolean | ||||
| virtualUICT_Regionabap_boolean | ||||
| virtualUICT_EmailAddressabap_boolean | ||||
| virtualUICT_BankInternalIDabap_boolean | ||||
| virtualUICT_Bankabap_boolean | ||||
| virtualUICT_BankCountryabap_boolean | ||||
| virtualUICT_BankAccountabap_boolean | ||||
| virtualUICT_BankControlKeyabap_boolean | ||||
| virtualUICT_BankReferenceabap_boolean | ||||
| virtualUICT_IBANabap_boolean | ||||
| virtualUICT_SWIFTCodeabap_boolean | ||||
| virtualUICT_PaymentSystemabap_boolean | ||||
| virtualUICT_AliasTypeabap_boolean | ||||
| virtualUICT_VATRegistrationabap_boolean | ||||
| virtualUICT_DMEIndicatorabap_boolean | ||||
| virtualUICT_TaxID1abap_boolean | ||||
| virtualUICT_TaxID2abap_boolean | ||||
| virtualUICT_TaxID3abap_boolean | ||||
| virtualUICT_TaxID4abap_boolean | ||||
| virtualUICT_TaxID5abap_boolean | ||||
| virtualUICT_ResponsibleTypeabap_boolean | ||||
| virtualUICT_TaxNumberTypeabap_boolean | ||||
| virtualUICT_IsNaturalPersonabap_boolean | ||||
| virtualUICT_BusinessTypeabap_boolean | ||||
| virtualUICT_IndustryTypeabap_boolean | ||||
| virtualUICT_IsVATLiableabap_boolean | ||||
| virtualUICT_SEPAMandateabap_boolean | ||||
| virtualUICT_VariantBankAliasabap_boolean | ||||
| _CompanyCode | _CompanyCode | |||
| _AccountingDocument | _AccountingDocument | |||
| _FiscalYear | _FiscalYear | |||
| _Address | _Address | |||
| _IBAN | _IBAN |
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_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 C_JournalEntryOneTimeAccountTP AS
SELECT
OneTimeAccountSourceDocType,
OneTimeAccountSourceDocument,
OneTimeAccountSourceDocItem,
CompanyCode,
AccountingDocument,
FiscalYear,
AccountingDocumentItem,
OneTimeAccountImageType,
CompanyCodeForEdit,
_CompanyCode.CompanyCodeName AS CompanyCodeName,
AccountingDocumentForEdit,
FiscalYearForEdit,
AccountingDocumentItemForEdit,
OneTimeAccountBPSalutationText,
Language,
_LanguageText.LanguageName : localized AS LanguageNamelocalized,
BusinessPartnerName1,
BusinessPartnerName2,
BusinessPartnerName3,
BusinessPartnerName4,
StreetName,
POBox,
POBoxIsWithoutNumber,
POBoxPostalCode,
PostOfficeBankAccount,
CityName,
PostalCode,
Country,
_CountryText.CountryName : localized AS CountryNamelocalized,
Region,
EmailAddress,
AddressID,
BankInternalID,
_Bank.BankName AS BankName,
BankCountry,
_BankCountryText.CountryName as BankCountryName : localized AS CountryNameasBankCountryNamelocalized,
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,
_Customer.CustomerName AS CustomerName,
Supplier,
_Supplier.SupplierName AS SupplierName,
InvoiceReference,
InvoiceReferenceFiscalYear,
PostingKey,
SpecialGLCode,
IsSalesRelated,
DocumentDate,
GLAccount,
_GLAccountText.GLAccountName : localized AS GLAccountNamelocalized,
SpecialGLTransactionType,
ClearingAccountingDocument,
HasPaymentOrder,
DebitCreditCode,
FollowOnDocumentType,
BPBankAccountInternalID,
PaytSlipWthRefSubscriber,
PaytSlipWthRefReference,
AlternativePayeePayer,
IsOneTimeAccount,
AlternativePayeeIsAllowed,
OneTimeAcctBankDetIsFromPayt,
LastChangeDate,
OneTimeAccountBankInputVariant,
OneTimeAccountAuthznGroup,
OneTimeAccountDataAgingDate,
OneTimeAcctDetnIsNotRequired,
AcctgDocHasQuickRspBillgSupp,
QuickRepIBANIsUsdInOneTmeAcct,
SEPAMandtIsUsdInOneTimeAcct,
QuickRepRefEditIsSupported,
IBANIsQuickResponse,
ReferenceAccountForIBAN,
OneTimeAcctChgIsNotAllowed,
virtual UICT_Language : abap_boolean AS virtualUICT_Languageabap_boolean,
virtual UICT_StreetName : abap_boolean AS virtualUICT_StreetNameabap_boolean,
virtual UICT_POBox : abap_boolean AS virtualUICT_POBoxabap_boolean,
virtual UICT_POBoxPostalCode : abap_boolean AS virtualUICT_POBoxPostalCodeabap_boolean,
virtual UICT_CityName : abap_boolean AS virtualUICT_CityNameabap_boolean,
virtual UICT_PostalCode : abap_boolean AS virtualUICT_PostalCodeabap_boolean,
virtual UICT_Country : abap_boolean AS virtualUICT_Countryabap_boolean,
virtual UICT_Region : abap_boolean AS virtualUICT_Regionabap_boolean,
virtual UICT_EmailAddress : abap_boolean AS virtualUICT_EmailAddressabap_boolean,
virtual UICT_BankInternalID : abap_boolean AS virtualUICT_BankInternalIDabap_boolean,
virtual UICT_Bank : abap_boolean AS virtualUICT_Bankabap_boolean,
virtual UICT_BankCountry : abap_boolean AS virtualUICT_BankCountryabap_boolean,
virtual UICT_BankAccount : abap_boolean AS virtualUICT_BankAccountabap_boolean,
virtual UICT_BankControlKey : abap_boolean AS virtualUICT_BankControlKeyabap_boolean,
virtual UICT_BankReference : abap_boolean AS virtualUICT_BankReferenceabap_boolean,
virtual UICT_IBAN : abap_boolean AS virtualUICT_IBANabap_boolean,
virtual UICT_SWIFTCode : abap_boolean AS virtualUICT_SWIFTCodeabap_boolean,
virtual UICT_PaymentSystem : abap_boolean AS virtualUICT_PaymentSystemabap_boolean,
virtual UICT_AliasType : abap_boolean AS virtualUICT_AliasTypeabap_boolean,
virtual UICT_VATRegistration : abap_boolean AS virtualUICT_VATRegistrationabap_boolean,
virtual UICT_DMEIndicator : abap_boolean AS virtualUICT_DMEIndicatorabap_boolean,
virtual UICT_TaxID1 : abap_boolean AS virtualUICT_TaxID1abap_boolean,
virtual UICT_TaxID2 : abap_boolean AS virtualUICT_TaxID2abap_boolean,
virtual UICT_TaxID3 : abap_boolean AS virtualUICT_TaxID3abap_boolean,
virtual UICT_TaxID4 : abap_boolean AS virtualUICT_TaxID4abap_boolean,
virtual UICT_TaxID5 : abap_boolean AS virtualUICT_TaxID5abap_boolean,
virtual UICT_ResponsibleType : abap_boolean AS virtualUICT_ResponsibleTypeabap_boolean,
virtual UICT_TaxNumberType : abap_boolean AS virtualUICT_TaxNumberTypeabap_boolean,
virtual UICT_IsNaturalPerson : abap_boolean AS virtualUICT_IsNaturalPersonabap_boolean,
virtual UICT_BusinessType : abap_boolean AS virtualUICT_BusinessTypeabap_boolean,
virtual UICT_IndustryType : abap_boolean AS virtualUICT_IndustryTypeabap_boolean,
virtual UICT_IsVATLiable : abap_boolean AS virtualUICT_IsVATLiableabap_boolean,
virtual UICT_SEPAMandate : abap_boolean AS virtualUICT_SEPAMandateabap_boolean,
virtual UICT_VariantBankAlias : abap_boolean AS virtualUICT_VariantBankAliasabap_boolean
FROM R_JournalEntryOneTimeAccountTP
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA