MAIN

201 Fields

MAIN is an SAP database table in S/4HANA. It contains 201 fields.

Fields (201)

KeyField CDS FieldsUsed in Views
KEY assigned_ca assigned_ca 2
KEY assigned_cfg assigned_cfg 2
KEY AvailabilityControlProfile AvailabilityControlProfile 9
KEY Batch Batch 1
KEY BudgetPeriod BudgetPeriod 1
KEY client client 2
KEY CompanyCode CompanyCode 21
KEY ControllingArea ControllingArea 9
KEY CostCenter CostCenter 1
KEY CostEstimate CostEstimate 1
KEY CtrlObjForBdgtValidityNmbr CtrlObjForBdgtValidityNmbr 8
KEY CtrlObjForBudgetAccount CtrlObjForBudgetAccount 9
KEY CtrlObjForBudgetPeriod CtrlObjForBudgetPeriod 9
KEY CtrlObjForCostCenter CtrlObjForCostCenter 9
KEY CtrlObjForFunctionalArea CtrlObjForFunctionalArea 9
KEY CtrlObjForFund CtrlObjForFund 9
KEY CtrlObjForGrant CtrlObjForGrant 9
KEY CtrlObjForSponsoredClass CtrlObjForSponsoredClass 9
KEY CtrlObjForSponsoredProgram CtrlObjForSponsoredProgram 9
KEY CtrlObjForWBSElement CtrlObjForWBSElement 9
KEY Customer Customer 2
KEY FinancialManagementArea FinancialManagementArea 9
KEY FinancialTransaction FinancialTransaction 1
KEY FinancialTransactionDirection FinancialTransactionDirection 1
KEY FinConditionItem FinConditionItem 1
KEY FiscalYearVariant FiscalYearVariant 1
KEY FunctionalArea FunctionalArea 1
KEY Fund Fund 1
KEY GlobalCurrency GlobalCurrency 8
KEY GrantID GrantID 1
KEY InventorySpecialStockType InventorySpecialStockType 1
KEY InventoryStockType InventoryStockType 1
KEY Material Material 4
KEY MaterialBaseUnit MaterialBaseUnit 1
KEY PeriodType PeriodType 1
KEY Plant Plant 1
KEY PubSecBdgtAcctRevnExpnCode PubSecBdgtAcctRevnExpnCode 8
KEY PubSecBudgetAccount PubSecBudgetAccount 1
KEY SDDocument SDDocument 1
KEY SDDocumentItem SDDocumentItem 1
KEY service_name service_name 2
KEY service_parguid service_parguid 2
KEY SponsoredClass SponsoredClass 1
KEY SponsoredProgram SponsoredProgram 1
KEY StartDate StartDate 1
KEY StorageLocation StorageLocation 1
KEY Supplier Supplier 2
KEY Tenant_Id Tenant_ID 1
KEY vh_name vh_name 2
KEY WBSElement WBSElement 1
KEY WBSElementInternalID WBSElementInternalID 1
KEY YearPeriod YearPeriod 1
_BdgtCnsmpnAnalysis _BdgtCnsmpnAnalysis 2
_CompanyCode _CompanyCode 2
_ControllingArea _ControllingArea 2
_FinancialManagementArea _FinancialManagementArea 2
_PubSecBdgtAcctRevnExpnCode _PubSecBdgtAcctRevnExpnCode 2
AccountingDocument AccountingDocument 1
AccountingDocumentType AccountingDocumentType 1
ACMToleranceTypeID ACMToleranceTypeID 1
add_description AssetAdditionalDescription 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
assessment_date LastAssessmentNoticeDate 1
assessment_tax_number NoticeOfAssessmentTaxid 1
asset_acquired_used AssetIsAcquiredUsed 1
asset_class anlkl,AssetClass 2
asset_super_no FixedAssetGroup 1
asset_type_name AssetTypeName 1
AssignmentReference AssignmentReference 1
augbt augbt 1
augwa augwa 1
AuthorizationGroup AuthorizationGroup 1
base_unit BaseUnit 1
BdgtAvailableAmtInGlobalCrcy BdgtAvailableAmtInGlobalCrcy 6
BdgtConsumableAmtInGlobalCrcy BdgtConsumableAmtInGlobalCrcy 6
BdgtConsumedAmtInGlobalCrcy BdgtConsumedAmtInGlobalCrcy 6
bukrs bukrs 1
BusinessPartner BusinessPartner 1
CompanyCodeCurrency CompanyCodeCurrency 1
ConditionItemValidityStartDate ConditionItemValidityStartDate 1
conveyance_date ConveyanceDate 1
crdate crdate 2
creation_datetime CreationDateTime 1
creation_user CreatedByUser 1
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
CreditAmountInTransCrcy CreditAmountInTransCrcy 1
crtime crtime 2
Currency Currency 2
CustomerFinsAuthorizationGrp CustomerFinsAuthorizationGrp 1
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
DebitAmountInTransCrcy DebitAmountInTransCrcy 1
description FixedAssetDescription,MasterFixedAssetDescription,mcoa1 3
DocumentDate DocumentDate 1
dscpnr dscpnr 2
environmental_investment EnvrnmtlInvestmentReason 1
FinancialAccountType FinancialAccountType 1
FinancialInstrProductCategory FinancialInstrProductCategory 2
FiscalYear FiscalYear 1
gl_account_det AssetAccountDetermination,ktogr 2
gpart gpart 2
GrantAuthznGrp GrantAuthznGrp 1
GrantHierarchy GrantHierarchy 8
GrantIsNotRelevantGrant GrantIsNotRelevantGrant 1
GrantLifecycleStatus GrantLifecycleStatus 1
HierarchyIDForBudgetAccount HierarchyIDForBudgetAccount 9
HierarchyIDForBudgetPeriod HierarchyIDForBudgetPeriod 9
HierarchyIDForCostCenter HierarchyIDForCostCenter 9
HierarchyIDForFunctionalArea HierarchyIDForFunctionalArea 9
HierarchyIDForFund HierarchyIDForFund 9
HierarchyIDForGrant GrantHierarchy 1
HierarchyIDForSponsoredClass SponsoredClassHierarchy 1
HierarchyIDForSponsoredProgram SponsoredProgramHierarchy 1
HierarchyIDForWBSElement HierarchyIDForWBSElement 9
inhouse_prod_percent InHouseProdnPercent 1
inventory_date LastInventoryDate 1
inventory_indicator InventoryIsCounted 1
inventory_note InventoryNote 1
inventory_number Inventory 1
invest_reason InvestmentReason 1
investment_io_origin InvestmentOrder 1
investment_wbs_origin InvestmentProjectWBSElement 1
IsLineItemSettled IsLineItemSettled 1
IsReversal IsReversal 1
IsReversed IsReversed 1
land_municipality Municipality 1
land_plot_number LandPlot 1
land_register_entry LandRegisterEntryDate 1
land_register_entry_number LandRegisterEntrySequence 1
land_register_map_no LandRegisterMap 1
land_register_of LandRegisterDate 1
land_register_page LandRegisterPage 1
land_register_volume LandRegisterVolume 1
land_tax_office LocalTaxOffice 1
last_reorg_date LastReorganizationDate 1
lastchange_datetime LastChangeDateTime 1
lastchange_user LastChangedByUser 1
laufd laufd 1
laufi laufi 1
lease_agreement_date LeaseAgreementDate 1
lease_agreement_no LeaseAgreement 1
lease_company LeaseSupplier 1
lease_data_text LeasedAssetNote 1
lease_notice_date LeaseTermEndDate 1
lease_periods LeaseDurationInFiscalPeriods 1
lease_start_date LeaseTermStartDate 1
lease_type LeaseType 1
lease_years LeaseDurationInFiscalYears 1
legacy_asset_no LegacyMasterFixedAsset 1
legacy_asset_subno LegacyFixedAsset 1
legacy_comp_code LegacyFixedAssetCompanyCode 1
legacy_transfer_date LegacyDataTransferDate 1
legacy_transfer_seq_no LegacyDataTransferSequence 1
manufacturer AssetManufacturerName 1
MatlCnsmpnQtyInMatlBaseUnit MatlCnsmpnQtyInMatlBaseUnit 1
MatlWrhsStkQtyInMatlBaseUnit MatlWrhsStkQtyInMatlBaseUnit 1
mbetm mbetm 2
NumberOfControlObjects NumberOfControlObjects 6
object_nr ObjectInternalID 1
origin_country AssetCountryOfOrigin 1
original_acq_date OriginalFixedAssetValueDate 1
original_acq_value OriginalAcquisitionAmount 1
original_acq_value_curr OriginalAcquisitionCurrency 1
original_acq_year OriginalAcquisitionFiscalYear 1
original_asset OriginalMasterFixedAsset 1
original_subasset OriginalFixedAsset 1
PostingDate PostingDate 1
property_ind FixedAssetPropertyType 1
property_key PropertyClass 1
purchase_order_date FixedAssetOrderDate 1
real_estate_asset AssetIsRealEstate 1
recpnr recpnr 1
Request_Entry_Name Request_Entry_Name 1
Request_Entry_Type Request_Entry_Type 1
screen_layout AssetScreenLayout 1
serial_number AssetSerialNumber 1
SourceDocument SourceDocument 1
SourceDocumentFiscalYear SourceDocumentFiscalYear 1
spart spart 1
SponsoredClassAuthznGrp SponsoredClassAuthznGrp 1
SponsoredClassHierarchy SponsoredClassHierarchy 8
SponsoredProgramAuthznGrp SponsoredProgramAuthznGrp 1
SponsoredProgramHierarchy SponsoredProgramHierarchy 8
subap subap 2
supplier_no Supplier 1
SupplierFinsAuthorizationGrp SupplierFinsAuthorizationGrp 1
surface_area AreaSize 1
surface_area_unit AreaSizeUnit 1
Tenant_Group Tenant_Group 1
Time_Granularity Time_Granularity 1
Time_Period Time_Period 1
Time_Zone Time_Zone 1
Timestamp_Server Timestamp_Server 1
Timestamp_UTC Timestamp_UTC 1
trade_id PartnerCompany 1
TransactionCurrency TransactionCurrency 1
uname uname 2
User_Group User_Group 1
vkont vkont 2
vtref vtref 2
waers waers 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 MAIN (
    ASSIGNED_CA,
    ASSIGNED_CFG,
    AVAILABILITYCONTROLPROFILE,
    BATCH,
    BUDGETPERIOD,
    CLIENT,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTESTIMATE,
    CTRLOBJFORBDGTVALIDITYNMBR,
    CTRLOBJFORBUDGETACCOUNT,
    CTRLOBJFORBUDGETPERIOD,
    CTRLOBJFORCOSTCENTER,
    CTRLOBJFORFUNCTIONALAREA,
    CTRLOBJFORFUND,
    CTRLOBJFORGRANT,
    CTRLOBJFORSPONSOREDCLASS,
    CTRLOBJFORSPONSOREDPROGRAM,
    CTRLOBJFORWBSELEMENT,
    CUSTOMER,
    FINANCIALMANAGEMENTAREA,
    FINANCIALTRANSACTION,
    FINANCIALTRANSACTIONDIRECTION,
    FINCONDITIONITEM,
    FISCALYEARVARIANT,
    FUNCTIONALAREA,
    FUND,
    GLOBALCURRENCY,
    GRANTID,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSTOCKTYPE,
    MATERIAL,
    MATERIALBASEUNIT,
    PERIODTYPE,
    PLANT,
    PUBSECBDGTACCTREVNEXPNCODE,
    PUBSECBUDGETACCOUNT,
    SDDOCUMENT,
    SDDOCUMENTITEM,
    SERVICE_NAME,
    SERVICE_PARGUID,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    STARTDATE,
    STORAGELOCATION,
    SUPPLIER,
    TENANT_ID,
    VH_NAME,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    YEARPERIOD,
    _BDGTCNSMPNANALYSIS,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _FINANCIALMANAGEMENTAREA,
    _PUBSECBDGTACCTREVNEXPNCODE,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    ACMTOLERANCETYPEID,
    ADD_DESCRIPTION,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSESSMENT_DATE,
    ASSESSMENT_TAX_NUMBER,
    ASSET_ACQUIRED_USED,
    ASSET_CLASS,
    ASSET_SUPER_NO,
    ASSET_TYPE_NAME,
    ASSIGNMENTREFERENCE,
    AUGBT,
    AUGWA,
    AUTHORIZATIONGROUP,
    BASE_UNIT,
    BDGTAVAILABLEAMTINGLOBALCRCY,
    BDGTCONSUMABLEAMTINGLOBALCRCY,
    BDGTCONSUMEDAMTINGLOBALCRCY,
    BUKRS,
    BUSINESSPARTNER,
    COMPANYCODECURRENCY,
    CONDITIONITEMVALIDITYSTARTDATE,
    CONVEYANCE_DATE,
    CRDATE,
    CREATION_DATETIME,
    CREATION_USER,
    CREDITAMOUNTINCOCODECRCY,
    CREDITAMOUNTINTRANSCRCY,
    CRTIME,
    CURRENCY,
    CUSTOMERFINSAUTHORIZATIONGRP,
    DEBITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINTRANSCRCY,
    DESCRIPTION,
    DOCUMENTDATE,
    DSCPNR,
    ENVIRONMENTAL_INVESTMENT,
    FINANCIALACCOUNTTYPE,
    FINANCIALINSTRPRODUCTCATEGORY,
    FISCALYEAR,
    GL_ACCOUNT_DET,
    GPART,
    GRANTAUTHZNGRP,
    GRANTHIERARCHY,
    GRANTISNOTRELEVANTGRANT,
    GRANTLIFECYCLESTATUS,
    HIERARCHYIDFORBUDGETACCOUNT,
    HIERARCHYIDFORBUDGETPERIOD,
    HIERARCHYIDFORCOSTCENTER,
    HIERARCHYIDFORFUNCTIONALAREA,
    HIERARCHYIDFORFUND,
    HIERARCHYIDFORGRANT,
    HIERARCHYIDFORSPONSOREDCLASS,
    HIERARCHYIDFORSPONSOREDPROGRAM,
    HIERARCHYIDFORWBSELEMENT,
    INHOUSE_PROD_PERCENT,
    INVENTORY_DATE,
    INVENTORY_INDICATOR,
    INVENTORY_NOTE,
    INVENTORY_NUMBER,
    INVEST_REASON,
    INVESTMENT_IO_ORIGIN,
    INVESTMENT_WBS_ORIGIN,
    ISLINEITEMSETTLED,
    ISREVERSAL,
    ISREVERSED,
    LAND_MUNICIPALITY,
    LAND_PLOT_NUMBER,
    LAND_REGISTER_ENTRY,
    LAND_REGISTER_ENTRY_NUMBER,
    LAND_REGISTER_MAP_NO,
    LAND_REGISTER_OF,
    LAND_REGISTER_PAGE,
    LAND_REGISTER_VOLUME,
    LAND_TAX_OFFICE,
    LAST_REORG_DATE,
    LASTCHANGE_DATETIME,
    LASTCHANGE_USER,
    LAUFD,
    LAUFI,
    LEASE_AGREEMENT_DATE,
    LEASE_AGREEMENT_NO,
    LEASE_COMPANY,
    LEASE_DATA_TEXT,
    LEASE_NOTICE_DATE,
    LEASE_PERIODS,
    LEASE_START_DATE,
    LEASE_TYPE,
    LEASE_YEARS,
    LEGACY_ASSET_NO,
    LEGACY_ASSET_SUBNO,
    LEGACY_COMP_CODE,
    LEGACY_TRANSFER_DATE,
    LEGACY_TRANSFER_SEQ_NO,
    MANUFACTURER,
    MATLCNSMPNQTYINMATLBASEUNIT,
    MATLWRHSSTKQTYINMATLBASEUNIT,
    MBETM,
    NUMBEROFCONTROLOBJECTS,
    OBJECT_NR,
    ORIGIN_COUNTRY,
    ORIGINAL_ACQ_DATE,
    ORIGINAL_ACQ_VALUE,
    ORIGINAL_ACQ_VALUE_CURR,
    ORIGINAL_ACQ_YEAR,
    ORIGINAL_ASSET,
    ORIGINAL_SUBASSET,
    POSTINGDATE,
    PROPERTY_IND,
    PROPERTY_KEY,
    PURCHASE_ORDER_DATE,
    REAL_ESTATE_ASSET,
    RECPNR,
    REQUEST_ENTRY_NAME,
    REQUEST_ENTRY_TYPE,
    SCREEN_LAYOUT,
    SERIAL_NUMBER,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTFISCALYEAR,
    SPART,
    SPONSOREDCLASSAUTHZNGRP,
    SPONSOREDCLASSHIERARCHY,
    SPONSOREDPROGRAMAUTHZNGRP,
    SPONSOREDPROGRAMHIERARCHY,
    SUBAP,
    SUPPLIER_NO,
    SUPPLIERFINSAUTHORIZATIONGRP,
    SURFACE_AREA,
    SURFACE_AREA_UNIT,
    TENANT_GROUP,
    TIME_GRANULARITY,
    TIME_PERIOD,
    TIME_ZONE,
    TIMESTAMP_SERVER,
    TIMESTAMP_UTC,
    TRADE_ID,
    TRANSACTIONCURRENCY,
    UNAME,
    USER_GROUP,
    VKONT,
    VTREF,
    WAERS,
    PRIMARY KEY (ASSIGNED_CA, ASSIGNED_CFG, AVAILABILITYCONTROLPROFILE, BATCH, BUDGETPERIOD, CLIENT, COMPANYCODE, CONTROLLINGAREA, COSTCENTER, COSTESTIMATE, CTRLOBJFORBDGTVALIDITYNMBR, CTRLOBJFORBUDGETACCOUNT, CTRLOBJFORBUDGETPERIOD, CTRLOBJFORCOSTCENTER, CTRLOBJFORFUNCTIONALAREA, CTRLOBJFORFUND, CTRLOBJFORGRANT, CTRLOBJFORSPONSOREDCLASS, CTRLOBJFORSPONSOREDPROGRAM, CTRLOBJFORWBSELEMENT, CUSTOMER, FINANCIALMANAGEMENTAREA, FINANCIALTRANSACTION, FINANCIALTRANSACTIONDIRECTION, FINCONDITIONITEM, FISCALYEARVARIANT, FUNCTIONALAREA, FUND, GLOBALCURRENCY, GRANTID, INVENTORYSPECIALSTOCKTYPE, INVENTORYSTOCKTYPE, MATERIAL, MATERIALBASEUNIT, PERIODTYPE, PLANT, PUBSECBDGTACCTREVNEXPNCODE, PUBSECBUDGETACCOUNT, SDDOCUMENT, SDDOCUMENTITEM, SERVICE_NAME, SERVICE_PARGUID, SPONSOREDCLASS, SPONSOREDPROGRAM, STARTDATE, STORAGELOCATION, SUPPLIER, TENANT_ID, VH_NAME, WBSELEMENT, WBSELEMENTINTERNALID, YEARPERIOD)
);

Learn More