_PROPERTYTAXFIXEDASSET

25 Fields

_PROPERTYTAXFIXEDASSET is an SAP database table in S/4HANA. It contains 25 fields.

Fields (25)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY DateTo DateTo 1
KEY FixedAsset FixedAsset 1
KEY MasterFixedAsset MasterFixedAsset 1
AddressNumber AddressNumber 1
AreaLocal AreaLocal 1
AreaTotal AreaTotal 1
CadastralValue CadastralValue 1
DateFrom DateFrom 1
InventoryNumber InventoryNumber 1
IsSZPKApplied IsSZPKApplied 1
IsTaxableByCadastralValue IsTaxableByCadastralValue 1
OKOF OKOF 1
OKTMO OKTMO 1
OwnershipRegistrationDate OwnershipRegistrationDate 1
OwnershipTerminationDate OwnershipTerminationDate 1
PropertyNumber PropertyNumber 1
PropertyNumberType PropertyNumberType 1
PropertyShare PropertyShare 1
PropertyType PropertyType 1
SpecialTaxCategory SpecialTaxCategory 1
TaxAmtReducnId TaxAmtReducnId 1
TaxExemptionId TaxExemptionId 1
TaxOffice TaxOffice 1
TaxRateReducnId TaxRateReducnId 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 _PROPERTYTAXFIXEDASSET (
    COMPANYCODE,
    DATETO,
    FIXEDASSET,
    MASTERFIXEDASSET,
    ADDRESSNUMBER,
    AREALOCAL,
    AREATOTAL,
    CADASTRALVALUE,
    DATEFROM,
    INVENTORYNUMBER,
    ISSZPKAPPLIED,
    ISTAXABLEBYCADASTRALVALUE,
    OKOF,
    OKTMO,
    OWNERSHIPREGISTRATIONDATE,
    OWNERSHIPTERMINATIONDATE,
    PROPERTYNUMBER,
    PROPERTYNUMBERTYPE,
    PROPERTYSHARE,
    PROPERTYTYPE,
    SPECIALTAXCATEGORY,
    TAXAMTREDUCNID,
    TAXEXEMPTIONID,
    TAXOFFICE,
    TAXRATEREDUCNID,
    PRIMARY KEY (COMPANYCODE, DATETO, FIXEDASSET, MASTERFIXEDASSET)
);

Learn More