P_SK_CAStRpCtrlStmntLogItem

DDL: P_SK_CASTRPCTRLSTMNTLOGITEM Type: view_entity BASIC
25 Fields 1 Data Sources

P_SK_CAStRpCtrlStmntLogItem is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (fkksk_vatcs_itm) and exposes 25 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, CADocumentNumber.

Data Sources (1)

SourceAliasJoin Type
fkksk_vatcs_itm fkksk_vatcs_itm from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity statryrptgentity Reporting Entity
KEY StatryRptCategory statryrptcategory Report ID
KEY StatryRptRunID statryrptrunid Report Run ID
KEY CompanyCode companycode Receiver Company Code
KEY CADocumentNumber cadocumentnumber Document Number
KEY CADocumentItem cadocumentitem Item
KEY BillingDocumentItem billingitem Item
KEY TaxGroup taxgroup Tax Group
KEY OriginType
KEY CAClearedDocument caorgdocumentnumber Document Number
VATRegistration vatregistration VAT Registration No.
InvoiceNumber Invoice Number
OriginalInvoiceNumber Original Invoice
TaxReportingDate taxreportingdate Tax Reporting Date
TaxFulfillmentDate taxfulfillmentdate Tax Settlement Date
TaxRate taxrate Tax Rate
TaxBaseAmount taxbaseamount TaxBaseAmtInRptgCrcy
TaxAmount taxamount Tax Amt in Rptg Crcy
DeductibleInputTaxAmount deducttaxamount Deductible Input Tax In Rptg Crcy
Currency currency Valuation Crcy
CAControlCode controlcode Control Code
BillingQuantity billingquantity Invoiced Qty
BaseUnit baseunit Unit of Measure
IsReversal xreversing Reversal doc.
IsReversed xreversed Reversed

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 P_SK_CAStRpCtrlStmntLogItem.
-- 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 P_SK_CAStRpCtrlStmntLogItem AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  CADocumentNumber,
  CADocumentItem,
  billingitem AS BillingDocumentItem,
  TaxGroup,
  cast(taxorigin as char3) AS OriginType,
  caorgdocumentnumber AS CAClearedDocument,
  VATRegistration,
  cast(invoicenumber as idhu_issued_invoice_id ) AS InvoiceNumber,
  cast(referenceinvoicenumber as idhu_root_invoice_id) AS OriginalInvoiceNumber,
  TaxReportingDate,
  TaxFulfillmentDate,
  TaxRate,
  TaxBaseAmount,
  TaxAmount,
  deducttaxamount AS DeductibleInputTaxAmount,
  Currency,
  controlcode AS CAControlCode,
  BillingQuantity,
  BaseUnit,
  xreversing AS IsReversal,
  xreversed AS IsReversed
FROM fkksk_vatcs_itm
;

Learn More