P_US_STRPWHLDGTAXITEM

CDS View
38 Fields 8 CDS Views

P_US_STRPWHLDGTAXITEM is a CDS View in S/4HANA. It contains 38 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_US_StRpFrgnVndrWhldgTxItm view from COMPOSITE US 1042s Reporting - Cube
P_US_1099KWhtxBusPartAggrTxItm view from COMPOSITE 1099K WHT Business Part Aggregation
P_US_StRp1099WhldgTxItm view from COMPOSITE
P_US_WhldgTxBusPartAggrgdTxItm view from COMPOSITE
P_US_WhldgTxCodeAggrgdFederal view from COMPOSITE
P_US_WhldgTxCodeAggrgdRoyalty view from COMPOSITE
P_US_WhldgTxCodeAggrgdTxItm view from COMPOSITE
P_US_WhldgTxRegionAggrgdTxItm view from COMPOSITE

Fields (38)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AccountingDocumentItem AccountingDocumentItem 1
KEY BPRgn BPRgn,SupplierRegion 1
KEY BusinessPartner AlternativePayeeAccountNumber,BusinessPartner 2
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 1
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
KEY WithholdingTaxType WithholdingTaxType 2
AccountingDocumentType AccountingDocumentType 1
BPStPrefixName BPStPrefixName 1
BPTaxNumber BPTaxNumber 1
BusinessPartnerCountry BusinessPartnerCountry 1
BusinessPartnerNumber BusinessPartnerNumber 2
BusinessPlace BusinessPlace 1
BusPartPOBox BusPartPOBox 1
BusPartPOBoxPostlCode BusPartPOBoxPostlCode 1
BusPartPOBoxRgn BusPartPOBoxRgn 1
Country Country 1
CustomerSupplierCityName CustomerSupplierCityName 1
CustomerSupplierHouseNumber CustomerSupplierHouseNumber 1
CustomerSupplierStreetName CustomerSupplierStreetName 1
Debtor Debtor 1
FinancialAccountType FinancialAccountType 1
IsReversal IsReversal 1
IsReversed IsReversed 1
OrganizationBPName1 BusinessPartnerName1 1
OrganizationBPName2 BusinessPartnerName2 1
PayeeCityName PayeeCityName 1
PayeePostalCode PayeePostalCode 1
PayeeRegion PayeeRegion 1
ReportingCurrency ReportingCurrency 1
SpecialGLCode SpecialGLCode 1
US_FrgnAcctTaxFilingIsRequired US_FrgnAcctTaxFilingIsRequired 1
US_SecondTINNoticeIsIssued US_SecondTINNoticeIsIssued 1
WhldgTaxDocumentType WhldgTaxDocumentType 1
WithholdingTaxCode WithholdingTaxCode 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_US_STRPWHLDGTAXITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    BPRGN,
    BUSINESSPARTNER,
    COMPANYCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    WITHHOLDINGTAXTYPE,
    ACCOUNTINGDOCUMENTTYPE,
    BPSTPREFIXNAME,
    BPTAXNUMBER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNUMBER,
    BUSINESSPLACE,
    BUSPARTPOBOX,
    BUSPARTPOBOXPOSTLCODE,
    BUSPARTPOBOXRGN,
    COUNTRY,
    CUSTOMERSUPPLIERCITYNAME,
    CUSTOMERSUPPLIERHOUSENUMBER,
    CUSTOMERSUPPLIERSTREETNAME,
    DEBTOR,
    FINANCIALACCOUNTTYPE,
    ISREVERSAL,
    ISREVERSED,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    PAYEECITYNAME,
    PAYEEPOSTALCODE,
    PAYEEREGION,
    REPORTINGCURRENCY,
    SPECIALGLCODE,
    US_FRGNACCTTAXFILINGISREQUIRED,
    US_SECONDTINNOTICEISISSUED,
    WHLDGTAXDOCUMENTTYPE,
    WITHHOLDINGTAXCODE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, BPRGN, BUSINESSPARTNER, COMPANYCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, WITHHOLDINGTAXTYPE)
);

Learn More