C_GB_APParkedInvoiceLogTP

DDL: C_GB_APPARKEDINVOICELOGTP Type: view_entity CONSUMPTION Package: GLO_FIN_IS_GB_AP_VAT_PARKED
19 Fields 1 Data Sources 1 Associations 1 OData Services

GB VAT AP Parked Invoice Log

C_GB_APParkedInvoiceLogTP is a Consumption CDS View that provides data about "GB VAT AP Parked Invoice Log" in SAP S/4HANA. It reads from 1 data source (R_GB_APParkedInvoiceLogTP) and exposes 19 fields with key fields CompanyCode, FiscalYear, FiscalPeriod, AccountingDocument, LedgerGLLineItem. It has 1 association to related views. It is exposed through 1 OData service (UI_GB_APPARKEDINVOICETP_O4). Part of development package GLO_FIN_IS_GB_AP_VAT_PARKED.

Data Sources (1)

SourceAliasJoin Type
R_GB_APParkedInvoiceLogTP R_GB_APParkedInvoiceLogTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_GB_APParkedInvoiceAppLog _AppLog $projection.CompanyCode = _AppLog.CompanyCode and $projection.FiscalYear = _AppLog.FiscalYear and $projection.FiscalPeriod = _AppLog.FiscalPeriod and $projection.AccountingDocument = _AppLog.AccountingDocument and $projection.LedgerGLLineItem = _AppLog.LedgerGLLineItem

Annotations (7)

NameValueLevelField
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view

OData Services (1)

ServiceBindingVersionContractRelease
UI_GB_APPARKEDINVOICETP_O4 UI_GB_APPARKEDINVOICETP_O4 V4 C1 NOT_RELEASED

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
TaxReportingDate TaxReportingDate Tax Reporting Date
TaxPayableDocumentYear TaxPayableDocumentYear
TaxReportingDocumentDate TaxReportingDocumentDate
TaxPayableDocument TaxPayableDocument
ReversalJournalEntryFiscalYear ReversalJournalEntryFiscalYear
ReversalJournalEntry ReversalJournalEntry
PostingReversalDate PostingReversalDate
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUserName LastChangedByUserName User Name
char1 Job Status
char20 Generation
int1 Criticality
_AppLog _AppLog

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_GB_APParkedInvoiceLogTP.
-- 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_GB_APParkedInvoiceLogTP AS
SELECT
  CompanyCode,
  FiscalYear,
  FiscalPeriod,
  AccountingDocument,
  LedgerGLLineItem,
  TaxReportingDate,
  TaxPayableDocumentYear,
  TaxReportingDocumentDate,
  TaxPayableDocument,
  ReversalJournalEntryFiscalYear,
  ReversalJournalEntry,
  PostingReversalDate,
  LastChangedByUser,
  LastChangeDateTime,
  LastChangedByUserName,
  virtual JobStatusValue : abap.char( 1 ) AS char1,
  virtual JobStatusValueText : abap.char( 20 ) AS char20,
  virtual PostingStatusCriticality : abap.int1 AS int1
FROM R_GB_APParkedInvoiceLogTP
LEFT OUTER JOIN C_GB_APParkedInvoiceAppLog AS _AppLog ON CompanyCode = _AppLog.CompanyCode AND FiscalYear = _AppLog.FiscalYear AND FiscalPeriod = _AppLog.FiscalPeriod AND AccountingDocument = _AppLog.AccountingDocument AND LedgerGLLineItem = _AppLog.LedgerGLLineItem  -- association [0..*]
;

Learn More