_ADDLDATA

_ADDLDATA is an SAP database table in S/4HANA. It contains 52 fields.

Fields (52)

KeyField CDS FieldsUsed in Views
ACMPrcgIntendedPrcType ACMPrcgIntendedPrcType 1
IT_AddlMncplSuspAmtInRptgCrcy IT_AddlMncplSuspAmtInRptgCrcy 1
IT_AddlMncplTtlAmtInRptgCrcy IT_AddlMncplTtlAmtInRptgCrcy 1
IT_AddlRgnlSuspAmtInRptgCrcy IT_AddlRgnlSuspAmtInRptgCrcy 1
IT_AddlRgnlSuspAmtInRptgCrcy2 IT_AddlRgnlSuspAmtInRptgCrcy2 1
IT_AddlTxAmtInRptgCrcy IT_AddlTxAmtInRptgCrcy 1
IT_AddMncplTtlTxAmtInRptgCrcy IT_AddMncplTtlTxAmtInRptgCrcy 1
IT_MunicipalSuspAmtInRptgCrcy IT_MunicipalSuspAmtInRptgCrcy 1
IT_MunicipalTtlAmtInRptgCrcy IT_MunicipalTtlAmtInRptgCrcy 1
IT_MunicipalTxAmtInRptgCrcy IT_MunicipalTxAmtInRptgCrcy 1
IT_OthContrbnAmtInRptgCrcy IT_OthContrbnAmtInRptgCrcy 1
IT_OthContrbnDuAmtInRptgCrcy IT_OthContrbnDuAmtInRptgCrcy 1
IT_OthContrbnPaidAmtInRptgCrcy IT_OthContrbnPaidAmtInRptgCrcy 1
IT_PrevYrBaseAmtInRptgCrcy IT_PrevYrBaseAmtInRptgCrcy 1
IT_PrevYrTxAmtInRptgCrcy IT_PrevYrTxAmtInRptgCrcy 1
IT_RgnlTxAmtInRptgCrcy IT_RgnlTxAmtInRptgCrcy 1
IT_TaxCode IT_TaxCode 1
IT_WhldgTaxRegionCode IT_WhldgTaxRegionCode 1
IT_WhldgTxAmtInRptgCrcy IT_WhldgTxAmtInRptgCrcy 1
IT_WhldgTxBaseAmtInRptgCrcy IT_WhldgTxBaseAmtInRptgCrcy 1
ValuationPoint ValuationPoint 1
WhldgAftBankruptAmtInRptgCrcy WhldgAftBankruptAmtInRptgCrcy 1
WhldgBfrBankruptAmtInRptgCrcy WhldgBfrBankruptAmtInRptgCrcy 1
WhldgTaxAdditionalDataCode WhldgTaxAdditionalDataCode 1
WhldgTaxExceptionalEvents WhldgTaxExceptionalEvents 1
WhldgTaxFrgnSuplrRprstv WhldgTaxFrgnSuplrRprstv 1
WhldgTaxInsuranceStartDate WhldgTaxInsuranceStartDate 1
WhldgTaxUICCode WhldgTaxUICCode 1
WhldgTxAddlAmtInRptgCrcy WhldgTxAddlAmtInRptgCrcy 1
WhldgTxAgtSpclCat WhldgTxAgtSpclCat 1
WhldgTxDcblAmtInRptgCrcy WhldgTxDcblAmtInRptgCrcy 1
WhldgTxDdctdAmtInRptgCrcy WhldgTxDdctdAmtInRptgCrcy 1
WhldgTxDeemedAmtInRptgCrcy WhldgTxDeemedAmtInRptgCrcy 1
WhldgTxDelivIdnNumber WhldgTxDelivIdnNumber 1
WhldgTxExpnsRfnddAmtInRptgCrcy WhldgTxExpnsRfnddAmtInRptgCrcy 1
WhldgTxIsAdvancePaymentFlag WhldgTxIsAdvancePaymentFlag 1
WhldgTxIsSoclContrbnExmpFlag WhldgTxIsSoclContrbnExmpFlag 1
WhldgTxNrOfTerritorialInsur WhldgTxNrOfTerritorialInsur 1
WhldgTxProgressiveCertNmbr WhldgTxProgressiveCertNmbr 1
WhldgTxRetdAmtInRptgCrcy WhldgTxRetdAmtInRptgCrcy 1
WhldgTxRgnlAmtInRptgCrcy WhldgTxRgnlAmtInRptgCrcy 1
WhldgTxRmbsdAmtInRptgCrcy WhldgTxRmbsdAmtInRptgCrcy 1
WhldgTxSoclScrtyInstnCode WhldgTxSoclScrtyInstnCode 1
WhldgTxSuplrTxRprstv WhldgTxSuplrTxRprstv 1
WhldgTxSuspAmtInRptgCrcy WhldgTxSuspAmtInRptgCrcy 1
WhldgTxTmpResidenceFrgnCtryReg WhldgTxTmpResidenceFrgnCtryReg 1
WhldgTxTotIncRcvdAmtInRptgCrcy WhldgTxTotIncRcvdAmtInRptgCrcy 1
WithheldTxAmtInRptgCrcy WithheldTxAmtInRptgCrcy 1
WithholdingTaxInsuranceEndDate WithholdingTaxInsuranceEndDate 1
WithholdingTaxIsHeir WithholdingTaxIsHeir 1
WithholdingTaxMunicipalCode WithholdingTaxMunicipalCode 1
WithholdingTaxPreviousYear WithholdingTaxPreviousYear 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 _ADDLDATA (
    ACMPRCGINTENDEDPRCTYPE,
    IT_ADDLMNCPLSUSPAMTINRPTGCRCY,
    IT_ADDLMNCPLTTLAMTINRPTGCRCY,
    IT_ADDLRGNLSUSPAMTINRPTGCRCY,
    IT_ADDLRGNLSUSPAMTINRPTGCRCY2,
    IT_ADDLTXAMTINRPTGCRCY,
    IT_ADDMNCPLTTLTXAMTINRPTGCRCY,
    IT_MUNICIPALSUSPAMTINRPTGCRCY,
    IT_MUNICIPALTTLAMTINRPTGCRCY,
    IT_MUNICIPALTXAMTINRPTGCRCY,
    IT_OTHCONTRBNAMTINRPTGCRCY,
    IT_OTHCONTRBNDUAMTINRPTGCRCY,
    IT_OTHCONTRBNPAIDAMTINRPTGCRCY,
    IT_PREVYRBASEAMTINRPTGCRCY,
    IT_PREVYRTXAMTINRPTGCRCY,
    IT_RGNLTXAMTINRPTGCRCY,
    IT_TAXCODE,
    IT_WHLDGTAXREGIONCODE,
    IT_WHLDGTXAMTINRPTGCRCY,
    IT_WHLDGTXBASEAMTINRPTGCRCY,
    VALUATIONPOINT,
    WHLDGAFTBANKRUPTAMTINRPTGCRCY,
    WHLDGBFRBANKRUPTAMTINRPTGCRCY,
    WHLDGTAXADDITIONALDATACODE,
    WHLDGTAXEXCEPTIONALEVENTS,
    WHLDGTAXFRGNSUPLRRPRSTV,
    WHLDGTAXINSURANCESTARTDATE,
    WHLDGTAXUICCODE,
    WHLDGTXADDLAMTINRPTGCRCY,
    WHLDGTXAGTSPCLCAT,
    WHLDGTXDCBLAMTINRPTGCRCY,
    WHLDGTXDDCTDAMTINRPTGCRCY,
    WHLDGTXDEEMEDAMTINRPTGCRCY,
    WHLDGTXDELIVIDNNUMBER,
    WHLDGTXEXPNSRFNDDAMTINRPTGCRCY,
    WHLDGTXISADVANCEPAYMENTFLAG,
    WHLDGTXISSOCLCONTRBNEXMPFLAG,
    WHLDGTXNROFTERRITORIALINSUR,
    WHLDGTXPROGRESSIVECERTNMBR,
    WHLDGTXRETDAMTINRPTGCRCY,
    WHLDGTXRGNLAMTINRPTGCRCY,
    WHLDGTXRMBSDAMTINRPTGCRCY,
    WHLDGTXSOCLSCRTYINSTNCODE,
    WHLDGTXSUPLRTXRPRSTV,
    WHLDGTXSUSPAMTINRPTGCRCY,
    WHLDGTXTMPRESIDENCEFRGNCTRYREG,
    WHLDGTXTOTINCRCVDAMTINRPTGCRCY,
    WITHHELDTXAMTINRPTGCRCY,
    WITHHOLDINGTAXINSURANCEENDDATE,
    WITHHOLDINGTAXISHEIR,
    WITHHOLDINGTAXMUNICIPALCODE,
    WITHHOLDINGTAXPREVIOUSYEAR
);