P_SK_CASTRPCTRLSTMNTTAXITEMLOG

CDS View
29 Fields 2 CDS Views

P_SK_CASTRPCTRLSTMNTTAXITEMLOG is a CDS View in S/4HANA. It contains 29 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SK_CAStRpCtrlStmntCrrtnCube view_entity from COMPOSITE SK VAT CS Analytical AddRun - Cube
I_SK_CAStRpCtrlStmntCube view_entity from COMPOSITE SK VAT CS Analytical - Cube

Fields (29)

KeyField CDS FieldsUsed in Views
KEY BillingDocumentItem BillingDocumentItem 2
KEY CABPItemNumber CABPItemNumber 2
KEY CAClearedDocument CAClearedDocument 2
KEY CADocumentNumber CADocument 2
KEY CAGLItemNumber CAGLItemNumber 2
KEY CompanyCode CompanyCode 2
KEY OriginType OriginType 2
KEY StatryRptCategory StatryRptCategory 2
KEY StatryRptgEntity StatryRptgEntity 2
KEY StatryRptRunID StatryRptRunID 2
KEY TaxGroup TaxGroup 1
BaseUnit BaseUnit 1
BillingQuantity BillingQuantityInBaseUnit 1
CAControlCode ConsumptionTaxCtrlCode 1
Currency CompanyCodeCurrency 1
DeductibleInputTaxAmount DeductTaxAmountInCCCrcy 1
InvoiceNumber InvoiceNumber 1
IsReversal IsReversal 2
IsReversed IsReversed 2
OriginalInvoiceNumber OriginalInvoiceNumber 1
SK_CtrlStmntUnitOfMeasure SK_CtrlStmntUnitOfMeasure 1
TaxAmount TaxAmountInCoCodeCrcy 1
TaxBaseAmount TaxBaseAmountInCoCodeCrcy 1
TaxCode TaxCode 2
TaxFulfillmentDate TaxFulfillmentDate 1
TaxRate TaxRate 1
TaxReportingDate TaxReportingDate 1
TransactionTypeDetermination TransactionTypeDetermination 2
VATRegistration VATRegistration 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SK_CASTRPCTRLSTMNTTAXITEMLOG (
    BILLINGDOCUMENTITEM,
    CABPITEMNUMBER,
    CACLEAREDDOCUMENT,
    CADOCUMENTNUMBER,
    CAGLITEMNUMBER,
    COMPANYCODE,
    ORIGINTYPE,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXGROUP,
    BASEUNIT,
    BILLINGQUANTITY,
    CACONTROLCODE,
    CURRENCY,
    DEDUCTIBLEINPUTTAXAMOUNT,
    INVOICENUMBER,
    ISREVERSAL,
    ISREVERSED,
    ORIGINALINVOICENUMBER,
    SK_CTRLSTMNTUNITOFMEASURE,
    TAXAMOUNT,
    TAXBASEAMOUNT,
    TAXCODE,
    TAXFULFILLMENTDATE,
    TAXRATE,
    TAXREPORTINGDATE,
    TRANSACTIONTYPEDETERMINATION,
    VATREGISTRATION,
    PRIMARY KEY (BILLINGDOCUMENTITEM, CABPITEMNUMBER, CACLEAREDDOCUMENT, CADOCUMENTNUMBER, CAGLITEMNUMBER, COMPANYCODE, ORIGINTYPE, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TAXGROUP)
);

Learn More