MAIN

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

210 fields

Fields (210)

KeyField CDS FieldsUsed in Views
KEY assigned_ca assigned_ca 2
KEY assigned_cfg assigned_cfg 2
KEY AvailabilityControlProfile AvailabilityControlProfile 12
KEY Batch Batch,StockIdentifyingBatch 4
KEY BudgetPeriod BudgetPeriod 1
KEY client client 2
KEY CompanyCode CompanyCode 25
KEY ControllingArea ControllingArea 11
KEY CostCenter CostCenter 1
KEY CostEstimate CostEstimate 4
KEY CtrlObjForBdgtValidityNmbr CtrlObjForBdgtValidityNmbr 10
KEY CtrlObjForBudgetAccount CtrlObjForBudgetAccount 12
KEY CtrlObjForBudgetPeriod CtrlObjForBudgetPeriod 11
KEY CtrlObjForCostCenter CtrlObjForCostCenter 11
KEY CtrlObjForFunctionalArea CtrlObjForFunctionalArea 11
KEY CtrlObjForFund CtrlObjForFund 11
KEY CtrlObjForGrant CtrlObjForGrant 11
KEY CtrlObjForSponsoredClass CtrlObjForSponsoredClass 11
KEY CtrlObjForSponsoredProgram CtrlObjForSponsoredProgram 11
KEY CtrlObjForWBSElement CtrlObjForWBSElement 11
KEY Customer Customer,SpecialStockIdfgCustomer 5
KEY FinancialManagementArea FinancialManagementArea 11
KEY FinancialTransaction FinancialTransaction 1
KEY FinancialTransactionDirection FinancialTransactionDirection 1
KEY FinConditionItem FinConditionItem 1
KEY FiscalYearVariant FiscalYearVariant 2
KEY FunctionalArea FunctionalArea 1
KEY Fund Fund 1
KEY GlobalCurrency GlobalCurrency 10
KEY GrantID GrantID 1
KEY InventorySpecialStockType InventorySpecialStockType 4
KEY InventoryStockType InventoryStockType 4
KEY Material Material 4
KEY MaterialBaseUnit MaterialBaseUnit 4
KEY PeriodType PeriodType 2
KEY Plant Plant 4
KEY PubSecBdgtAcctRevnExpnCode PubSecBdgtAcctRevnExpnCode 10
KEY PubSecBudgetAccount PubSecBudgetAccount 1
KEY SDDocument SDDocument,SpecialStockIdfgSalesOrder 4
KEY SDDocumentItem SDDocumentItem,SpecialStockIdfgSalesOrderItem 4
KEY service_name service_name 2
KEY service_parguid service_parguid 2
KEY SpecialStockIdfgStockOwner SpecialStockIdfgStockOwner 2
KEY SponsoredClass SponsoredClass 1
KEY SponsoredProgram SponsoredProgram 1
KEY StartDate StartDate 2
KEY StorageLocation StorageLocation 4
KEY Supplier SpecialStockIdfgSupplier,Supplier 5
KEY Tenant_Id Tenant_ID 1
KEY vh_name vh_name 2
KEY WBSElement WBSElement 1
KEY WBSElementInternalID SpecialStockIdfgWBSElement,WBSElementInternalID 4
KEY YearPeriod YearPeriod 2
_BdgtCnsmpnAnalysis _BdgtCnsmpnAnalysis 2
_CompanyCode _CompanyCode 3
_ControllingArea _ControllingArea 2
_FinancialManagementArea _FinancialManagementArea 2
_PubSecBdgtAcctRevnExpnCode _PubSecBdgtAcctRevnExpnCode 2
AccountingDocument AccountingDocument 1
AccountingDocumentType AccountingDocumentType 1
add_description AddDescription,AssetAdditionalDescription 3
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
assessment_date LastAssessmentNoticeDate 2
assessment_tax_number NoticeOfAssessmentTaxID 2
asset_acquired_used AssetIsAcquiredUsed 2
asset_class anlkl,AssetClass 4
asset_super_no FixedAssetGroup 2
asset_type_name AssetTypeName 2
AssignmentReference AssignmentReference 1
augbt augbt 1
augwa augwa 1
AuthorizationGroup AuthorizationGroup 1
base_unit BaseUnit 2
BdgtAvailableAmtInGlobalCrcy BdgtAvailableAmtInGlobalCrcy 6
BdgtConsumableAmtInGlobalCrcy BdgtConsumableAmtInGlobalCrcy 6
BdgtConsumedAmtInGlobalCrcy BdgtConsumedAmtInGlobalCrcy 6
bukrs bukrs 1
BusinessPartner BusinessPartner 1
CompanyCodeCurrency CompanyCodeCurrency 1
ConditionItemValidityStartDate ConditionItemValidityStartDate 1
conveyance_date ConveyanceDate 2
crdate crdate 2
creation_datetime CreationDateTime 2
creation_user CreatedByUser 2
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
CreditAmountInTransCrcy CreditAmountInTransCrcy 1
crtime crtime 2
CtrlObjNameForBudgetAccount CtrlObjNameForBudgetAccount 1
Currency Currency 2
CustomerAccountGroup CustomerAccountGroup 1
CustomerCompanyAuthznGroup CustomerCompanyAuthznGroup 1
CustomerFinsAuthorizationGrp CustomerFinsAuthorizationGrp 1
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
DebitAmountInTransCrcy DebitAmountInTransCrcy 1
description Description,FixedAssetDescription,MasterFixedAssetDescription,mcoa1 5
DocumentDate DocumentDate 1
dscpnr dscpnr 2
environmental_investment EnvrnmtlInvestmentReason 2
FinancialAccountType FinancialAccountType 1
FinancialInstrProductCategory FinancialInstrProductCategory 2
FiscalYear FiscalYear 1
gl_account_det AssetAccountDetermination,ktogr 3
gpart gpart 2
GrantAuthznGrp GrantAuthznGrp 1
GrantHierarchy GrantHierarchy 10
GrantIsNotRelevantGrant GrantIsNotRelevantGrant 1
GrantLifecycleStatus GrantLifecycleStatus 1
HierarchyIDForBudgetAccount HierarchyIDForBudgetAccount 11
HierarchyIDForBudgetPeriod HierarchyIDForBudgetPeriod 11
HierarchyIDForCostCenter HierarchyIDForCostCenter 11
HierarchyIDForFunctionalArea HierarchyIDForFunctionalArea 11
HierarchyIDForFund HierarchyIDForFund 11
HierarchyIDForGrant GrantHierarchy 1
HierarchyIDForSponsoredClass SponsoredClassHierarchy 1
HierarchyIDForSponsoredProgram SponsoredProgramHierarchy 1
HierarchyIDForWBSElement HierarchyIDForWBSElement 11
inhouse_prod_percent InHouseProdnPercent 2
inventory_date LastInventoryDate 2
inventory_indicator InventoryIsCounted 2
inventory_note InventoryNote 2
inventory_number Inventory 2
invest_reason InvestmentReason 2
investment_io_origin InvestmentOrder 2
investment_wbs_origin InvestmentProjectWBSElement 2
IsLineItemSettled IsLineItemSettled 1
IsReversal IsReversal 1
IsReversed IsReversed 1
land_municipality Municipality 2
land_plot_number LandPlot 2
land_register_entry LandRegisterEntryDate 2
land_register_entry_number LandRegisterEntrySequence 2
land_register_map_no LandRegisterMap 2
land_register_of LandRegisterDate 2
land_register_page LandRegisterPage 2
land_register_volume LandRegisterVolume 2
land_tax_office LocalTaxOffice 2
last_reorg_date LastReorganizationDate 2
lastchange_datetime LastChangeDateTime 2
lastchange_user LastChangedByUser 2
laufd laufd 1
laufi laufi 1
lease_agreement_date LeaseAgreementDate 2
lease_agreement_no LeaseAgreement 2
lease_company LeaseSupplier 2
lease_data_text LeasedAssetNote 2
lease_notice_date LeaseTermEndDate 2
lease_periods LeaseDurationInFiscalPeriods 2
lease_start_date LeaseTermStartDate 2
lease_type LeaseType 2
lease_years LeaseDurationInFiscalYears 2
legacy_asset_no LegacyMasterFixedAsset 2
legacy_asset_subno LegacyFixedAsset 2
legacy_comp_code LegacyFixedAssetCompanyCode 2
legacy_transfer_date LegacyDataTransferDate 2
legacy_transfer_seq_no LegacyDataTransferSequence 2
manufacturer AssetManufacturerName 2
MatlCnsmpnQtyInMatlBaseUnit MatlCnsmpnQtyInMatlBaseUnit 2
MatlWrhsStkQtyInMatlBaseUnit MatlWrhsStkQtyInMatlBaseUnit 3
MatlWrhsStkQtyOnEndDate MatlWrhsStkQtyOnEndDate 1
MatlWrhsStkQtyOnStartDate MatlWrhsStkQtyOnStartDate 1
mbetm mbetm 2
NumberOfControlObjects NumberOfControlObjects 8
object_nr ObjectInternalID 2
origin_country AssetCountryOfOrigin 2
original_acq_date OriginalFixedAssetValueDate 2
original_acq_value OriginalAcquisitionAmount 2
original_acq_value_curr OriginalAcquisitionCurrency 2
original_acq_year OriginalAcquisitionFiscalYear 2
original_asset OriginalMasterFixedAsset 2
original_subasset OriginalFixedAsset 2
ParentWBSElementExternalID ParentWBSElementExternalID 1
PlanningCategory PlanningCategory 1
PostingDate PostingDate 1
property_ind FixedAssetPropertyType 2
property_key PropertyClass 2
purchase_order_date FixedAssetOrderDate 2
real_estate_asset AssetIsRealEstate 2
recpnr recpnr 1
Request_Entry_Name Request_Entry_Name 1
Request_Entry_Type Request_Entry_Type 1
screen_layout AssetScreenLayout 2
serial_number AssetSerialNumber 3
SourceDocument SourceDocument 1
SourceDocumentFiscalYear SourceDocumentFiscalYear 1
spart spart 1
SponsoredClassAuthznGrp SponsoredClassAuthznGrp 1
SponsoredClassHierarchy SponsoredClassHierarchy 10
SponsoredProgramAuthznGrp SponsoredProgramAuthznGrp 1
SponsoredProgramHierarchy SponsoredProgramHierarchy 10
subap subap 2
supplier_no Supplier 2
SupplierAccountGroup SupplierAccountGroup 1
SupplierCompanyAuthznGroup SupplierCompanyAuthznGroup 1
SupplierFinsAuthorizationGrp SupplierFinsAuthorizationGrp 1
surface_area AreaSize 2
surface_area_unit AreaSizeUnit 2
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 2
TransactionCurrency TransactionCurrency 1
uname uname 2
User_Group User_Group 1
vkont vkont 2
vtref vtref 2
waers waers 2

Learn More