PROPERTYTAXITEM

22 Fields

PROPERTYTAXITEM is an SAP database table in S/4HANA. It contains 22 fields.

Fields (22)

KeyField CDS FieldsUsed in Views
KEY PositionID PositionID 1
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
CompanyCode CompanyCode 1
DownPaymentAmount DownPaymentAmount 1
FixedAsset FixedAsset 1
MasterFixedAsset MasterFixedAsset 1
NetBookValAmtExmpAvgInLoclCrcy NetBookValAmtExmpAvgInLoclCrcy 1
NetBookValueAmtAvgInLoclCrcy NetBookValueAmtAvgInLoclCrcy 1
PaidAbroadTaxAmountInLoclCrcy PaidAbroadTaxAmountInLoclCrcy 1
RU_AssetPropertyType RU_AssetPropertyType 1
RU_PropertyTaxAmtReduction RU_PropertyTaxAmtReduction 1
RU_PropertyTaxExemption RU_PropertyTaxExemption 1
RU_PropertyTaxExemptionDesc RU_PropertyTaxExemptionDesc 1
RU_PropertyTaxOKTMO RU_PropertyTaxOKTMO 1
RU_PropertyTaxRateReducnDesc RU_PropertyTaxRateReducnDesc 1
RU_PropertyTaxRateReduction RU_PropertyTaxRateReduction 1
TaxAmount TaxAmount 1
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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 PROPERTYTAXITEM (
    POSITIONID,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    COMPANYCODE,
    DOWNPAYMENTAMOUNT,
    FIXEDASSET,
    MASTERFIXEDASSET,
    NETBOOKVALAMTEXMPAVGINLOCLCRCY,
    NETBOOKVALUEAMTAVGINLOCLCRCY,
    PAIDABROADTAXAMOUNTINLOCLCRCY,
    RU_ASSETPROPERTYTYPE,
    RU_PROPERTYTAXAMTREDUCTION,
    RU_PROPERTYTAXEXEMPTION,
    RU_PROPERTYTAXEXEMPTIONDESC,
    RU_PROPERTYTAXOKTMO,
    RU_PROPERTYTAXRATEREDUCNDESC,
    RU_PROPERTYTAXRATEREDUCTION,
    TAXAMOUNT,
    TAXBASEAMOUNTINCOUNTRYCRCY,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (POSITIONID, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More