P_STRPWHLDGTAXITEMLOG

CDS View
69 Fields 10 CDS Views

WHT Reporting View for DRC Log Item

P_STRPWHLDGTAXITEMLOG is a CDS View in S/4HANA. WHT Reporting View for DRC Log Item. It contains 69 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
P_CL_STRPWHLDGTAXITEMLOG view_entity from COMPOSITE Private Log View - WTax Chile
P_ES_StRpWithholdingTaxItem view_entity from COMPOSITE
P_IT_StRpWhldgTaxItemLog view_entity from COMPOSITE Italy WHT Document Selection
P_JP_LastVndrPaytInfo view_entity from COMPOSITE
P_JP_STRPWHLDGTAXITEM view_entity from COMPOSITE
P_KR_WhldgInhabitanttaxitm view_entity from COMPOSITE
P_KR_WhlgNonTaxItem view_entity from COMPOSITE
P_PH_StRpWhldgTaxItemLog view_entity from COMPOSITE
P_RS_StrpWithholdingTaxItem view_entity from COMPOSITE Private view - WTax Serbia DOCSEL query
P_SI_StrpWhldgTaxItemLog view_entity from COMPOSITE Private Log View - WTax Slovenia

Fields (69)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 8
KEY AccountingDocumentItem AccountingDocumentItem 7
KEY CompanyCode CompanyCode 9
KEY FiscalYear FiscalYear 9
KEY WithholdingTaxCode WithholdingTaxCode 8
KEY WithholdingTaxType WithholdingTaxType 8
_Branch _Branch 2
_CompanyCode _CompanyCode 2
_Customer _Customer 2
_JournalEntry _JournalEntry 2
_Onetime _Onetime 2
_OperationalAcctgDocItem _OperationalAcctgDocItem 2
_ReportingCurrency _ReportingCurrency 2
_Supplier _Supplier 2
_WithholdingTaxCode _WithholdingTaxCode 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 3
AmountInLocalCurrency AmountInLocalCurrency 2
BusinessPartner BusinessPartner 8
BusinessPartnerCountry BusinessPartnerCountry 4
BusinessPartnerName BusinessPartnerName 1
BusinessPartnerNumber BusinessPartnerNumber 2
BusinessPlace BusinessPlace 4
ClearingDate ClearingDate 5
ClearingJournalEntry ClearingJournalEntry 6
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear 5
Country Country 4
Creditor Creditor 4
Debtor Debtor 2
DefaultWhldgTxRptgDateIsActive DefaultWhldgTxRptgDateIsActive 2
DocumentDate DocumentDate 4
DocumentReferenceID DocumentReferenceID 2
FinancialAccountType FinancialAccountType 3
IN_ClrgWithholdingTaxDate IN_ClrgWithholdingTaxDate 1
IN_ClrgWithholdingTaxDocument IN_ClrgWithholdingTaxDocument 1
IN_WhldgTaxRecordTypeTrans IN_WhldgTaxRecordTypeTrans 1
InvoiceReference InvoiceReference 5
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 5
IsGrossingUp IsGrossingUp 3
IsNaturalPerson IsNaturalPerson 2
IsReversal IsReversal 6
IsReversed IsReversed 6
IsSelfWhldgTax IsSelfWhldgTax 2
ItemIsReportingRelevant ItemIsReportingRelevant 2
Name Name 4
OfficialWhldgTaxCode OfficialWhldgTaxCode 4
PostingDate PostingDate 6
Region Region 1
ReportingCurrency ReportingCurrency 7
SpecialGLCode SpecialGLCode 1
SpecialGLTransactionType SpecialGLTransactionType 1
SupplierRecipientType SupplierRecipientType 2
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 2
TaxItemIsZeroRated TaxItemIsZeroRated 2
TaxNumber1 TaxNumber1 2
TaxNumber2 TaxNumber2 2
TaxNumber3 TaxNumber3 2
TaxNumber4 TaxNumber4 2
TaxNumber5 TaxNumber5 2
TaxSection TaxSection 2
VATRegistration VATRegistration 2
WhldgTaxAmtInCoCodeCrcy WhldgTaxAmtInCoCodeCrcy 7
WhldgTaxBaseAmtInCoCodeCrcy WhldgTaxBaseAmtInCoCodeCrcy 7
WhldgTaxCertDate WhldgTaxCertDate 2
WhldgTaxDocumentType WhldgTaxDocumentType 8
WhldgTaxReferenceText WhldgTaxReferenceText 1
WhldgTaxRptgDateIsActive WhldgTaxRptgDateIsActive 2
WithholdingTaxCertificate WithholdingTaxCertificate 2
WithholdingTaxIncomeType WithholdingTaxIncomeType 5
WithholdingTaxReportingDate WithholdingTaxReportingDate 4

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.

-- WHT Reporting View for DRC Log Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_STRPWHLDGTAXITEMLOG (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    WITHHOLDINGTAXCODE,
    WITHHOLDINGTAXTYPE,
    _BRANCH,
    _COMPANYCODE,
    _CUSTOMER,
    _JOURNALENTRY,
    _ONETIME,
    _OPERATIONALACCTGDOCITEM,
    _REPORTINGCURRENCY,
    _SUPPLIER,
    _WITHHOLDINGTAXCODE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINLOCALCURRENCY,
    BUSINESSPARTNER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    BUSINESSPARTNERNUMBER,
    BUSINESSPLACE,
    CLEARINGDATE,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COUNTRY,
    CREDITOR,
    DEBTOR,
    DEFAULTWHLDGTXRPTGDATEISACTIVE,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    FINANCIALACCOUNTTYPE,
    IN_CLRGWITHHOLDINGTAXDATE,
    IN_CLRGWITHHOLDINGTAXDOCUMENT,
    IN_WHLDGTAXRECORDTYPETRANS,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    ISGROSSINGUP,
    ISNATURALPERSON,
    ISREVERSAL,
    ISREVERSED,
    ISSELFWHLDGTAX,
    ITEMISREPORTINGRELEVANT,
    NAME,
    OFFICIALWHLDGTAXCODE,
    POSTINGDATE,
    REGION,
    REPORTINGCURRENCY,
    SPECIALGLCODE,
    SPECIALGLTRANSACTIONTYPE,
    SUPPLIERRECIPIENTTYPE,
    TAXAMOUNTINCOCODECRCY,
    TAXITEMISZERORATED,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TAXSECTION,
    VATREGISTRATION,
    WHLDGTAXAMTINCOCODECRCY,
    WHLDGTAXBASEAMTINCOCODECRCY,
    WHLDGTAXCERTDATE,
    WHLDGTAXDOCUMENTTYPE,
    WHLDGTAXREFERENCETEXT,
    WHLDGTAXRPTGDATEISACTIVE,
    WITHHOLDINGTAXCERTIFICATE,
    WITHHOLDINGTAXINCOMETYPE,
    WITHHOLDINGTAXREPORTINGDATE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR, WITHHOLDINGTAXCODE, WITHHOLDINGTAXTYPE)
);

Learn More