P_SK_CAStRpCtrlStmntTaxItemLog

DDL: P_SK_CASTRPCTRLSTMNTTAXITEMLOG Type: view_entity COMPOSITE
29 Fields 2 Data Sources

P_SK_CAStRpCtrlStmntTaxItemLog is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_SK_CAStRpCtrlStmntLogItem, P_SK_CATaxItemTransferred) and exposes 29 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, CADocumentNumber.

Data Sources (2)

SourceAliasJoin Type
I_SK_CAStRpCtrlStmntLogItem LogItem from
P_SK_CATaxItemTransferred TaxItem inner

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 #COMPOSITE view
VDM.private true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity I_SK_CAStRpCtrlStmntLogItem StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_SK_CAStRpCtrlStmntLogItem StatryRptCategory Report ID
KEY StatryRptRunID I_SK_CAStRpCtrlStmntLogItem StatryRptRunID Report Run ID
KEY CompanyCode I_SK_CAStRpCtrlStmntLogItem CompanyCode Receiver Company Code
KEY CADocumentNumber I_SK_CAStRpCtrlStmntLogItem CADocumentNumber Document Number
KEY CAGLItemNumber I_SK_CAStRpCtrlStmntLogItem CAGLItemNumber Item
KEY CABPItemNumber I_SK_CAStRpCtrlStmntLogItem CABPItemNumber Item
KEY BillingDocumentItem I_SK_CAStRpCtrlStmntLogItem BillingDocumentItem Item
KEY TaxGroup I_SK_CAStRpCtrlStmntLogItem TaxGroup Tax Group
KEY OriginType I_SK_CAStRpCtrlStmntLogItem OriginType
KEY CAClearedDocument I_SK_CAStRpCtrlStmntLogItem CAClearedDocument Document Number
VATRegistration I_SK_CAStRpCtrlStmntLogItem VATRegistration VAT Registration No.
InvoiceNumber I_SK_CAStRpCtrlStmntLogItem InvoiceNumber Invoice Number
OriginalInvoiceNumber I_SK_CAStRpCtrlStmntLogItem OriginalInvoiceNumber
TaxReportingDate I_SK_CAStRpCtrlStmntLogItem TaxReportingDate Tax Reporting Date
TaxFulfillmentDate I_SK_CAStRpCtrlStmntLogItem TaxFulfillmentDate Tax Settlement Date
TaxRate I_SK_CAStRpCtrlStmntLogItem TaxRate Tax Rate
TaxBaseAmount I_SK_CAStRpCtrlStmntLogItem TaxBaseAmount TaxBaseAmtInRptgCrcy
TaxAmount I_SK_CAStRpCtrlStmntLogItem TaxAmount Tax Amt in Rptg Crcy
DeductibleInputTaxAmount I_SK_CAStRpCtrlStmntLogItem DeductibleInputTaxAmount Deductible Input Tax In Rptg Crcy
Currency I_SK_CAStRpCtrlStmntLogItem Currency Valuation Crcy
CAControlCode I_SK_CAStRpCtrlStmntLogItem CAControlCode Control Code
BillingQuantity I_SK_CAStRpCtrlStmntLogItem BillingQuantity Invoiced Qty
BaseUnit I_SK_CAStRpCtrlStmntLogItem BaseUnit Unit of Measure
SK_CtrlStmntUnitOfMeasure UoM SK_CtrlStmntUnitOfMeasure
TaxCode P_SK_CATaxItemTransferred TaxCode Tax Code
TransactionTypeDetermination P_SK_CATaxItemTransferred TransactionTypeDetermination Transaction Key
IsReversal I_SK_CAStRpCtrlStmntLogItem IsReversal Reversal doc.
IsReversed I_SK_CAStRpCtrlStmntLogItem IsReversed 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_CAStRpCtrlStmntTaxItemLog.
-- 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_CAStRpCtrlStmntTaxItemLog AS
SELECT
  LogItem.StatryRptgEntity AS StatryRptgEntity,
  LogItem.StatryRptCategory AS StatryRptCategory,
  LogItem.StatryRptRunID AS StatryRptRunID,
  LogItem.CompanyCode AS CompanyCode,
  LogItem.CADocumentNumber AS CADocumentNumber,
  LogItem.CAGLItemNumber AS CAGLItemNumber,
  LogItem.CABPItemNumber AS CABPItemNumber,
  LogItem.BillingDocumentItem AS BillingDocumentItem,
  LogItem.TaxGroup AS TaxGroup,
  LogItem.OriginType AS OriginType,
  LogItem.CAClearedDocument AS CAClearedDocument,
  LogItem.VATRegistration AS VATRegistration,
  LogItem.InvoiceNumber AS InvoiceNumber,
  LogItem.OriginalInvoiceNumber AS OriginalInvoiceNumber,
  LogItem.TaxReportingDate AS TaxReportingDate,
  LogItem.TaxFulfillmentDate AS TaxFulfillmentDate,
  LogItem.TaxRate AS TaxRate,
  LogItem.TaxBaseAmount AS TaxBaseAmount,
  LogItem.TaxAmount AS TaxAmount,
  LogItem.DeductibleInputTaxAmount AS DeductibleInputTaxAmount,
  LogItem.Currency AS Currency,
  LogItem.CAControlCode AS CAControlCode,
  LogItem.BillingQuantity AS BillingQuantity,
  LogItem.BaseUnit AS BaseUnit,
  UoM.SK_CtrlStmntUnitOfMeasure AS SK_CtrlStmntUnitOfMeasure,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  LogItem.IsReversal AS IsReversal,
  LogItem.IsReversed AS IsReversed
FROM I_SK_CAStRpCtrlStmntLogItem AS LogItem
INNER JOIN P_SK_CATaxItemTransferred AS TaxItem ON /* join condition not captured in parsed metadata */
;

Learn More