Fields (52)
| Key | Field | CDS Fields | Used 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
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA