_VERSION

42 Fields

_VERSION is an SAP database table in S/4HANA. It contains 42 fields.

Fields (42)

KeyField CDS FieldsUsed in Views
KEY ConsolidationVersion ConsolidationVersion 2
_Lang _Lang 1
ChartOfAccounts ChartOfAccount,ChartOfAccounts 2
clearing_area version_clearing_area 1
ConsolidationDataEntryVersion ConsolidationDataEntryVersion 1
ConsolidationInvestmentVersion ConsolidationInvestmentVersion 1
ConsolidationLedgerVersion ConsolidationLedgerVersion 1
ConsolidationReportingRuleVers ConsolidationReportingRuleVers 1
ConsolidationStructureVersion ConsolidationStructureVersion 1
ConsolidationTaxRateVersion ConsolidationTaxRateVersion 1
CreatedByUser CreatedByUser 2
DistributionChannel DistributionChannel 2
Division Division 2
FSItemMappingVersion FSItemMappingVersion 1
ISU_BR_InspectionDate ISU_BR_InspectionDate 1
ISU_BR_LossProcessStatus ISU_BR_LossProcessStatus 1
ISU_BR_LossStatusDescription ISU_BR_LossStatusDescription 1
Language Language 1
LastChangedByUser LastChangedByUser 2
MfgWorkInstructionContent MfgWorkInstructionContent 1
MfgWorkInstructionVersStatus MfgWorkInstructionVersStatus 1
obj_date version_obj_date 1
obj_no version_obj_no 1
object_category version_object_category 1
PurchasingOrganization PurchasingOrganization 2
SalesOrganization SalesOrganization 2
WarrantyClaimChangeDateTime WarrantyClaimChangeDateTime 2
WarrantyClaimVersionCategory WarrantyClaimVersionCategory 2
WarrantyClaimVersionIsActive WarrantyClaimVersionIsActive 2
WarrantyClaimVersionText WarrantyClaimVersionText 2
WarrantyVersionPricingStatus WarrantyVersionPricingStatus 2
WrntyBillingDocumentDate WrntyBillingDocumentDate 2
WrntyClaimChangedDate WrntyClaimChangedDate 2
WrntyClaimCreationDate WrntyClaimCreationDate 2
WrntyCurrencyCode WrntyCurrencyCode 2
WrntyDecisionCode WrntyDecisionCode 2
WrntyDocumentCondition WrntyDocumentCondition 2
WrntyExchangeRateForPrice WrntyExchangeRateForPrice 2
WrntyNumberPrecedingVersion WrntyNumberPrecedingVersion 2
WrntyPriceExchangeRateDate WrntyPriceExchangeRateDate 2
WrntyVersionUUID WrntyVersionUUID 2
WrntyVersIsReldForShipgToPart WrntyVersIsReldForShipgToPart 2

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 _VERSION (
    CONSOLIDATIONVERSION,
    _LANG,
    CHARTOFACCOUNTS,
    CLEARING_AREA,
    CONSOLIDATIONDATAENTRYVERSION,
    CONSOLIDATIONINVESTMENTVERSION,
    CONSOLIDATIONLEDGERVERSION,
    CONSOLIDATIONREPORTINGRULEVERS,
    CONSOLIDATIONSTRUCTUREVERSION,
    CONSOLIDATIONTAXRATEVERSION,
    CREATEDBYUSER,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    FSITEMMAPPINGVERSION,
    ISU_BR_INSPECTIONDATE,
    ISU_BR_LOSSPROCESSSTATUS,
    ISU_BR_LOSSSTATUSDESCRIPTION,
    LANGUAGE,
    LASTCHANGEDBYUSER,
    MFGWORKINSTRUCTIONCONTENT,
    MFGWORKINSTRUCTIONVERSSTATUS,
    OBJ_DATE,
    OBJ_NO,
    OBJECT_CATEGORY,
    PURCHASINGORGANIZATION,
    SALESORGANIZATION,
    WARRANTYCLAIMCHANGEDATETIME,
    WARRANTYCLAIMVERSIONCATEGORY,
    WARRANTYCLAIMVERSIONISACTIVE,
    WARRANTYCLAIMVERSIONTEXT,
    WARRANTYVERSIONPRICINGSTATUS,
    WRNTYBILLINGDOCUMENTDATE,
    WRNTYCLAIMCHANGEDDATE,
    WRNTYCLAIMCREATIONDATE,
    WRNTYCURRENCYCODE,
    WRNTYDECISIONCODE,
    WRNTYDOCUMENTCONDITION,
    WRNTYEXCHANGERATEFORPRICE,
    WRNTYNUMBERPRECEDINGVERSION,
    WRNTYPRICEEXCHANGERATEDATE,
    WRNTYVERSIONUUID,
    WRNTYVERSISRELDFORSHIPGTOPART,
    PRIMARY KEY (CONSOLIDATIONVERSION)
);

Learn More