I_FUNCTIONALLOCATION

CDS View
49 Fields 41 CDS Views

Functional Location

I_FUNCTIONALLOCATION is a CDS View in S/4HANA. Functional Location. It contains 49 fields. 41 CDS views read from this table.

CDS Views using this table (41)

ViewTypeJoinVDMDescription
C_DFS_MaintFunctionalLocVH view from CONSUMPTION Value help for Functional Location
C_FuncLocationPartnerDEX view_entity inner CONSUMPTION Functional Location Partner
C_FunctionalLocation view from CONSUMPTION Functional Location
C_FunctionalLocationDEX view_entity from CONSUMPTION Functional Location Data
C_GHOFunctionalLocation view from CONSUMPTION Functional Location
C_RSHMaintAssetBoardParAsset view union_all CONSUMPTION
C_TechnicalObjectForEditVH view union_all CONSUMPTION Technical Object Value Help For Edit
CRMS4_IU_I_DEVLOC view_entity from Device Location
I_DFS_MaintFuncnlLocAncr view from COMPOSITE Recursive View for Funcn Loc Ancestor
I_DFS_MaintFuncnlLocDscndnt view from COMPOSITE Recursive View for Functional Location
I_EWA_ContainerLocationVH view_entity from COMPOSITE Conatiner Location Values
I_EWA_SalesContractCube view_entity inner COMPOSITE Sales Contract - Cube
I_FlocConstMaterialBom view from BASIC BoM of Functional Location Const. Type
I_FlocConstTypeBoM view from BASIC Construction Material BOM - FLOC
I_FuncnlLocationHierarchyNode view from BASIC Functional Location Hiearchy Interface
I_FuncnlLocStrucList view_entity from COMPOSITE Functional Location Structure List
I_FunctionalLocationData view from COMPOSITE Functional Location Data
I_Functionallocationhierarchy view from BASIC Hierarchy Information between FLOCs
I_FunctionalLocationLabel view from COMPOSITE Functional Location Label
I_FunctionalLocationLabelData view_entity from COMPOSITE Functional Location Label
I_FunctionalLocationLongText view from COMPOSITE Long Text for Functional Location
I_FunctionalLocationStdVH view from COMPOSITE Functional Location
I_IndlSystPerspectiveObject view_entity union_all COMPOSITE Industrial System Perspective Object
I_TechnicalObjectUnion view_entity union_all COMPOSITE Technical Object Union
I_UtilitiesDeviceLocation view_entity from COMPOSITE Technical Object Location Address
I_UtilsTechnicalObjLocation view from BASIC Technical Object Location
I_UtilsTechObjLocationAddr view from COMPOSITE Technical Object Location Address
P_EquiFuncnlLocUnionBreakdown view union_all COMPOSITE
P_EquipmentFuncnlLocUnion view union_all COMPOSITE
P_EquiTimeSegFuncLocationUnion view union_all COMPOSITE
P_FunctionalLocationSearch view from BASIC
P_FunctionalLocationStatus view from COMPOSITE
P_PmBillOfMaterialUnion view inner COMPOSITE
P_RSHMaintAssetBoard view left_outer CONSUMPTION Maintenance Asset Board
P_RSHMaintAssetBoard view union_all CONSUMPTION Maintenance Asset Board
P_RSHTechnicalObject view_entity union_all CONSUMPTION Technical object details
P_WrntyClaimFunctionalLocation view from COMPOSITE Warranty Claim Functional Location
R_FuncnlLocWrntyAssgmtTP view_entity from TRANSACTIONAL Functional Location Warranty
R_FunctionalLocationLongTextTP view_entity from TRANSACTIONAL Functional Location – Text
R_FunctionalLocationPartnerTP view_entity from TRANSACTIONAL Functional Location Partner
R_FunctionalLocationTP view_entity from TRANSACTIONAL Functional Location

Fields (49)

KeyField CDS FieldsUsed in Views
KEY FunctionalLocation FunctionalLocation,HierarchyNode 20
KEY MaintenancePlanningPlant MaintenancePlanningPlant,Plant 13
_FunctionalLocationText _FunctionalLocationText 3
_LocationAccountAssignment _LocationAccountAssignment 1
_MaintenancePlannerGroup _MaintenancePlannerGroup 1
_MaintenancePlanningPlant _MaintenancePlanningPlant 1
_SuperiorFunctionalLocation _SuperiorFunctionalLocation 1
AcquisitionDate AcquisitionDate 4
AcquisitionValue AcquisitionValue 4
AssetManufacturerName AssetManufacturerName 4
AuthorizationGroup AuthorizationGroup 12
CatalogProfile CatalogProfile 4
ConstructionMaterial ConstructionMaterial 7
ConstructionMonth ConstructionMonth 4
ConstructionYear ConstructionYear 4
CreatedByUser CreatedByUser 4
CreationDate CreationDate 6
Currency Currency 4
EquipmentInstallationIsAllowed EquipmentInstallationIsAllowed 1
FuncLocationStructure FuncLocationStructure 1
FuncnlLocPosInSuperiorTechObj FuncnlLocPosInSuperiorTechObj 2
FunctionalLocationCategory FunctionalLocationCategory,TechnicalObjectCategory 2
FunctionalLocationEndOfUseDate FunctionalLocationEndOfUseDate 3
FunctionalLocationOID FunctionalLocationOID 1
GrossWeight GrossWeight 4
GrossWeightUnit GrossWeightUnit 4
InventoryNumber InventoryNumber,TechObjectSortCodeSearchable 4
LastChangeDate LastChangeDate 5
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser 4
MaintenancePlannerGroup MaintenancePlannerGroup 11
MaintObjectInternalID MaintAssetBoardParentRowObjID,MaintObjectInternalID 7
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr 12
ManufacturerCountry ManufacturerCountry 4
ManufacturerPartNmbr ManufacturerPartNmbr 3
ManufacturerPartTypeName ManufacturerPartTypeName 4
ManufacturerSerialNumber ManufacturerSerialNumber 4
OnePieceOfEquipmentIsAllowed OnePieceOfEquipmentIsAllowed 1
OperationStartDate OperationStartDate 5
ReferenceFunctionalLocation ReferenceFunctionalLocation 1
ReferenceStructureElementID ReferenceStructureElementID 1
ReferenceStructureElementUUID ReferenceStructureElementUUID 1
ReferenceStructureIdentifier ReferenceStructureIdentifier 1
ReferenceStructureUUID ReferenceStructureUUID 1
SizeOrDimensionText SizeOrDimensionText 3
SuperiorFunctionalLocation SuperiorFunctionalLocation 6
TechnicalObjectType TechnicalObjectType 6
WorkCenterInternalID MainWorkCenterInternalID,WorkCenterInternalID 6
WorkCenterTypeCode WorkCenterTypeCode 3

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.

-- Functional Location
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FUNCTIONALLOCATION (
    FUNCTIONALLOCATION,
    MAINTENANCEPLANNINGPLANT,
    _FUNCTIONALLOCATIONTEXT,
    _LOCATIONACCOUNTASSIGNMENT,
    _MAINTENANCEPLANNERGROUP,
    _MAINTENANCEPLANNINGPLANT,
    _SUPERIORFUNCTIONALLOCATION,
    ACQUISITIONDATE,
    ACQUISITIONVALUE,
    ASSETMANUFACTURERNAME,
    AUTHORIZATIONGROUP,
    CATALOGPROFILE,
    CONSTRUCTIONMATERIAL,
    CONSTRUCTIONMONTH,
    CONSTRUCTIONYEAR,
    CREATEDBYUSER,
    CREATIONDATE,
    CURRENCY,
    EQUIPMENTINSTALLATIONISALLOWED,
    FUNCLOCATIONSTRUCTURE,
    FUNCNLLOCPOSINSUPERIORTECHOBJ,
    FUNCTIONALLOCATIONCATEGORY,
    FUNCTIONALLOCATIONENDOFUSEDATE,
    FUNCTIONALLOCATIONOID,
    GROSSWEIGHT,
    GROSSWEIGHTUNIT,
    INVENTORYNUMBER,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MAINTENANCEPLANNERGROUP,
    MAINTOBJECTINTERNALID,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    MANUFACTURERCOUNTRY,
    MANUFACTURERPARTNMBR,
    MANUFACTURERPARTTYPENAME,
    MANUFACTURERSERIALNUMBER,
    ONEPIECEOFEQUIPMENTISALLOWED,
    OPERATIONSTARTDATE,
    REFERENCEFUNCTIONALLOCATION,
    REFERENCESTRUCTUREELEMENTID,
    REFERENCESTRUCTUREELEMENTUUID,
    REFERENCESTRUCTUREIDENTIFIER,
    REFERENCESTRUCTUREUUID,
    SIZEORDIMENSIONTEXT,
    SUPERIORFUNCTIONALLOCATION,
    TECHNICALOBJECTTYPE,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (FUNCTIONALLOCATION, MAINTENANCEPLANNINGPLANT)
);

Learn More