MAIN

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

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

Learn More