P_ID_STRPWHLDGTAXFRGNITEM

CDS View
37 Fields 1 CDS Views

ID Private view for BPNR report

P_ID_STRPWHLDGTAXFRGNITEM is a CDS View in S/4HANA. ID Private view for BPNR report. It contains 37 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ID_STRPWHLDGTAXFRGNITEMQ view_entity from COMPOSITE Whldg Tax Item Query for ID BPNR report

Fields (37)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
KEY WithholdingTaxType WithholdingTaxType 1
AccountingDocumentHeaderText AccountingDocumentHeaderText 1
AccountingDocumentType AccountingDocumentType 1
AccountingDocumentTypeName AccountingDocumentTypeName 1
address address 1
BirthDate BirthDate 1
BPCertNumber BPCertNumber 1
BPIdentificationNumber BPIdentificationNumber 1
BPIdentificationNumberForEdit BPIdentificationNumberForEdit 1
BPTaxNumber BPTaxNumber 1
BusinessPartner BusinessPartner 1
BusinessPartnerBirthplaceName BusinessPartnerBirthplaceName 1
BusinessPartnerCountry BusinessPartnerCountry 1
BusinessPartnerName BusinessPartnerName 1
BusinessPartnerNumber BusinessPartnerNumber 1
BusinessPlace BusinessPlace 1
DocumentReferenceID DocumentReferenceID 1
FiscalPeriod FiscalPeriod 1
InvoiceReference InvoiceReference 1
IsReversal IsReversal 1
IsReversed IsReversed 1
ItemIsReportingRelevant ItemIsReportingRelevant 1
PostingDate PostingDate 1
ReportingCurrency ReportingCurrency 1
WhldgTaxDocumentType WhldgTaxDocumentType 1
WhldgTaxReferenceText WhldgTaxReferenceText 1
WhldgTaxRelevantPercent WhldgTaxRelevantPercent 1
WithholdingTaxCertificate WithholdingTaxCertificate 1
WithholdingTaxCountry WithholdingTaxCountry 1
WithholdingTaxIncomeType WithholdingTaxIncomeType 1
WithholdingTaxPercent WithholdingTaxPercent 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.

-- ID Private view for BPNR report
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ID_STRPWHLDGTAXFRGNITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    WITHHOLDINGTAXTYPE,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ACCOUNTINGDOCUMENTTYPENAME,
    ADDRESS,
    BIRTHDATE,
    BPCERTNUMBER,
    BPIDENTIFICATIONNUMBER,
    BPIDENTIFICATIONNUMBERFOREDIT,
    BPTAXNUMBER,
    BUSINESSPARTNER,
    BUSINESSPARTNERBIRTHPLACENAME,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    BUSINESSPARTNERNUMBER,
    BUSINESSPLACE,
    DOCUMENTREFERENCEID,
    FISCALPERIOD,
    INVOICEREFERENCE,
    ISREVERSAL,
    ISREVERSED,
    ITEMISREPORTINGRELEVANT,
    POSTINGDATE,
    REPORTINGCURRENCY,
    WHLDGTAXDOCUMENTTYPE,
    WHLDGTAXREFERENCETEXT,
    WHLDGTAXRELEVANTPERCENT,
    WITHHOLDINGTAXCERTIFICATE,
    WITHHOLDINGTAXCOUNTRY,
    WITHHOLDINGTAXINCOMETYPE,
    WITHHOLDINGTAXPERCENT,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, WITHHOLDINGTAXTYPE)
);

Learn More