WITHHOLDINGTAXITEM

WITHHOLDINGTAXITEM is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY MX_DIOTOperationType MX_DIOTOperationType 2
KEY MX_SupplierType MX_SupplierType 2
KEY PaymentDocument PaymentDocument 1
KEY SenderFiscalYear SenderFiscalYear 1
KEY StatryRptCategory StatryRptCategory 2
KEY StatryRptgEntity StatryRptgEntity 2
KEY StatryRptRunID StatryRptRunID 2
KEY Supplier Supplier 1
ReportingCurrency ReportingCurrency 1
WhldgTaxAmtInReportingCrcy WhldgTaxAmtInReportingCrcy 2
WhldgTaxBaseAmtInAddlCrcy2 WhldgTaxBaseAmtInAddlCrcy1 1
WhldgTaxBaseAmtInAddlCrcy3 WhldgTaxBaseAmtInAddlCrcy2 1
WhldgTaxBaseAmtInCoCodeCrcy WhldgTaxBaseAmtInCoCodeCrcy 1
WhldgTaxBaseAmtInTransacCrcy WhldgTaxBaseAmtInTransacCrcy 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 WITHHOLDINGTAXITEM (
    COMPANYCODE,
    MX_DIOTOPERATIONTYPE,
    MX_SUPPLIERTYPE,
    PAYMENTDOCUMENT,
    SENDERFISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUPPLIER,
    REPORTINGCURRENCY,
    WHLDGTAXAMTINREPORTINGCRCY,
    WHLDGTAXBASEAMTINADDLCRCY2,
    WHLDGTAXBASEAMTINADDLCRCY3,
    WHLDGTAXBASEAMTINCOCODECRCY,
    WHLDGTAXBASEAMTINTRANSACCRCY,
    PRIMARY KEY (COMPANYCODE, MX_DIOTOPERATIONTYPE, MX_SUPPLIERTYPE, PAYMENTDOCUMENT, SENDERFISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, SUPPLIER)
);