C_JournalCaseObjPgProposal

DDL: C_JOURNALCASEOBJPGPROPOSAL Type: view_entity CONSUMPTION
65 Fields 1 Data Sources 1 OData Services

C_JournalCaseObjPgProposal is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (R_JournalCaseProposalOverview) and exposes 65 fields with key field JournalCaseProposalItemUUID. It is exposed through 1 OData service (JOURNALCASE).

Data Sources (1)

SourceAliasJoin Type
R_JournalCaseProposalOverview R_JournalCaseProposalOverview from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations false view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view

OData Services (1)

ServiceBindingVersionContractRelease
JOURNALCASE JOURNALCASE V4 C1 NOT_RELEASED

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY JournalCaseProposalItemUUID JournalCaseProposalItemUUID UUID
JournalCaseUUID JournalCaseUUID UUID
JournalCaseProposalUUID JournalCaseProposalUUID UUID
JournalCaseProposal JournalCaseProposal
AccountingDocument SenderAccountingDocument Sender Journal Entry
JrnlCasePrpslJournalEntryItem JrnlCasePrpslJournalEntryItem Jrnl Prpsl Line Item
CompanyCode CompanyCode Receiver Company Code
AccountingDocumentType AccountingDocumentType Journal Entry Type
PostingKey PostingKey Posting Key
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Tax period
GLAccount GLAccount General Ledger
DebitAmountInTransCrcy DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInTransCrcy CreditAmountInTransCrcy Credit Amt in DC
ExchangeRateDate ExchangeRateDate Translatn Date
AssignmentReference AssignmentReference Assignment Reference
CostCenter CostCenter Cost Center
DocumentItemText DocumentItemText Text
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
TaxCode TaxCode Tax Code
AmountInLocalCurrency AmountInLocalCurrency Local Crcy Amt
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 LC2 Amount
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
ProfitCenter ProfitCenter Profit Center
OrderID OrderID Order ID
WBSElement WBSElement WBS Internal ID
ValueDate ValueDate Value Date
HouseBankAccount HouseBankAccount House Bank Account
HouseBank HouseBank House Bank
PartnerCompany PartnerCompany Trading Partner
SpecialGLCode SpecialGLCode Special G/L Ind
AbsoluteAmountInTransacCrcy AbsoluteAmountInTransacCrcy Amount
TaxIsCalculatedAutomatically TaxIsCalculatedAutomatically Tax Is Automatically Calculated
PaymentBlockingReason PaymentBlockingReason Pmnt block
PersonnelNumber PersonnelNumber Personnel No.
AssetTransactionType AssetTransactionType Trans.Type
PurchasingDocument PurchasingDocument Purchasing Document
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
PartnerFunctionalArea PartnerFunctionalArea Rec. Fntcl Area
PartnerProfitCenter PartnerProfitCenter Profit Center
Product Product Product Sold
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
JointVentureObjectType JointVentureObjectType JV Object Type
BillToParty BillToParty Inv. Recipient
ProviderContract ProviderContract Contract
ProviderContractItem ProviderContractItem Contract Item
CustomerNum CustomerNum Customer
TransactionCurrency TransactionCurrency Transaction Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
LedgerGroup LedgerGroup Ledger Group
DocumentReferenceID DocumentReferenceID Reference
AbsoluteExchangeRate AbsoluteExchangeRate Absolute Exchange Rate
PartnerBusinessArea PartnerBusinessArea Trdg Part.BA
ControllingArea ControllingArea Controlling Area
AccountingDocumentTypeName AccountingDocumentTypeName
CompanyCodeName CompanyCodeName Company Name
CostCenterName CostCenterName Name
GLAccountName GLAccountName Short Text
PartnerCompanyCodeName PartnerCompanyCodeName
PostingKeyName PostingKeyName
_JournalProposal _JournalProposal

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_JournalCaseObjPgProposal.
-- 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_JournalCaseObjPgProposal AS
SELECT
  JournalCaseProposalItemUUID,
  JournalCaseUUID,
  JournalCaseProposalUUID,
  JournalCaseProposal,
  SenderAccountingDocument AS AccountingDocument,
  JrnlCasePrpslJournalEntryItem,
  CompanyCode,
  AccountingDocumentType,
  PostingKey,
  FiscalYear,
  FiscalPeriod,
  GLAccount,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  ExchangeRateDate,
  AssignmentReference,
  CostCenter,
  DocumentItemText,
  AccountingDocumentHeaderText,
  TaxCode,
  AmountInLocalCurrency,
  AmountInAdditionalCurrency2,
  TaxJurisdiction,
  ProfitCenter,
  OrderID,
  WBSElement,
  ValueDate,
  HouseBankAccount,
  HouseBank,
  PartnerCompany,
  SpecialGLCode,
  AbsoluteAmountInTransacCrcy,
  TaxIsCalculatedAutomatically,
  PaymentBlockingReason,
  PersonnelNumber,
  AssetTransactionType,
  PurchasingDocument,
  SalesOrder,
  SalesOrderItem,
  PartnerFunctionalArea,
  PartnerProfitCenter,
  Product,
  DistributionChannel,
  JointVentureObjectType,
  BillToParty,
  ProviderContract,
  ProviderContractItem,
  CustomerNum,
  TransactionCurrency,
  GlobalCurrency,
  CompanyCodeCurrency,
  DocumentDate,
  PostingDate,
  LedgerGroup,
  DocumentReferenceID,
  AbsoluteExchangeRate,
  PartnerBusinessArea,
  ControllingArea,
  AccountingDocumentTypeName,
  CompanyCodeName,
  CostCenterName,
  GLAccountName,
  PartnerCompanyCodeName,
  PostingKeyName
FROM R_JournalCaseProposalOverview
;

Learn More