I_SK_CAStRpCtrlStmntLogItem

DDL: I_SK_CASTRPCTRLSTMNTLOGITEM Type: view_entity BASIC
26 Fields 1 Data Sources

SK VAT Control Statement Log Item

I_SK_CAStRpCtrlStmntLogItem is a Basic CDS View that provides data about "SK VAT Control Statement Log Item" in SAP S/4HANA. It reads from 1 data source (fkksk_vatcs_itm) and exposes 26 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 #MANDATORY view
EndUserText.label SK VAT Control Statement Log Item view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (26)

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 CAGLItemNumber
KEY CABPItemNumber
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 I_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 I_SK_CAStRpCtrlStmntLogItem AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  CADocumentNumber,
  case when taxorigin = '1' then cadocumentitem else cast('' as opupk_kk) end AS CAGLItemNumber,
  case when taxorigin <> '1' then cadocumentitem else cast('' as opupk_kk) end AS CABPItemNumber,
  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