I_GLOBASSETASSIGNMENT

CDS View

Country/Region Specific Fixed Asset Assignment

I_GLOBASSETASSIGNMENT is a CDS View in S/4HANA. Country/Region Specific Fixed Asset Assignment. It contains 14 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_CN_CADEFixedAssetValueCube view left_outer COMPOSITE Fixed Asset Balance Cube for CADE
I_GlobAssetAssignmentTP view from TRANSACTIONAL CSMD Asset Assignments Data(TDD)
I_RU_LandPlotCadastrNumberVH view_entity from COMPOSITE Land Plot by Russian Cadastral Number
I_RU_TransportTaxItemCube view inner COMPOSITE Russia Transport Tax: Cube
I_RU_VehicleLicPlateNumberVH view_entity from COMPOSITE Vehicle by Russian License Plate number
P_RU_GlobAssetAssignment view from COMPOSITE Russia: Country Specific Fixed Asset Assignment
R_GlobFixedAssetAssignmentTP view_entity from TRANSACTIONAL Globalization Fixed Asset Assignment

Fields (14)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY FixedAsset FixedAsset 2
KEY MasterFixedAsset MasterFixedAsset 2
KEY RU_VehicleLicensePlateNumber RU_VehicleLicensePlateNumber 2
KEY ValidityStartDate ValidityStartDate 2
RU_TransportTaxExemption RU_TransportTaxExemption 1
RU_TransportTaxOKTMO RU_TransportTaxOKTMO 1
RU_TransportTaxReduction RU_TransportTaxReduction 1
RU_TranspTxAmtReduction RU_TranspTxAmtReduction 1
RU_VehicleCancellationDate RU_VehicleCancellationDate 1
RU_VehicleRegistrationDate RU_VehicleRegistrationDate 1
RU_VehicleReturnDate RU_VehicleReturnDate 1
RU_VehicleStolenDate RU_VehicleStolenDate 1
RU_VehTranspTxPriceCategory RU_VehTranspTxPriceCategory 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.

-- Country/Region Specific Fixed Asset Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLOBASSETASSIGNMENT (
    COMPANYCODE,
    FIXEDASSET,
    MASTERFIXEDASSET,
    RU_VEHICLELICENSEPLATENUMBER,
    VALIDITYSTARTDATE,
    RU_TRANSPORTTAXEXEMPTION,
    RU_TRANSPORTTAXOKTMO,
    RU_TRANSPORTTAXREDUCTION,
    RU_TRANSPTXAMTREDUCTION,
    RU_VEHICLECANCELLATIONDATE,
    RU_VEHICLEREGISTRATIONDATE,
    RU_VEHICLERETURNDATE,
    RU_VEHICLESTOLENDATE,
    RU_VEHTRANSPTXPRICECATEGORY,
    PRIMARY KEY (COMPANYCODE, FIXEDASSET, MASTERFIXEDASSET, RU_VEHICLELICENSEPLATENUMBER, VALIDITYSTARTDATE)
);