_FUNCTIONALLOCATION

20 Fields

_FUNCTIONALLOCATION is an SAP database table in S/4HANA. It contains 20 fields.

Fields (20)

KeyField CDS FieldsUsed in Views
_LocationAccountAssignment _LocationAccountAssignment 3
AssetManufacturerName FuncnlLocationManufacturerName 1
AuthorizationGroup AuthorizationGroup 4
CatalogProfile FunctionalLocationCodeCatalog 1
ConstructionMaterial ConstructionMaterial,FuncnlLocConstructionMaterial 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
FuncLocationStructure FuncLocationStructure 3
FunctionalLocation FunctionalLocation 5
FunctionalLocationCategory FunctionalLocationCategory,MaintJobPckgOpsFuncLocCategory 5
FunctionalLocationLabelName FunctionalLocationLabelName 4
LastChangeDateTime LastChangeDateTime 1
MaintenancePlannerGroup MaintenancePlannerGroup 6
MaintenancePlanningPlant MaintenancePlanningPlant 6
MaintObjectInternalID FuncMaintObjectInternalID,MaintObjectInternalID 2
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr 4
ManufacturerPartNmbr FuncnlLocationMfrPrtNmbr 1
ManufacturerPartTypeName FuncnlLocationMfrPrtTypeName 1
SuperiorFunctionalLocation SuperiorFunctionalLocation 1
TechnicalObjectType FunctionalLocationObjectType 1

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 _FUNCTIONALLOCATION (
    _LOCATIONACCOUNTASSIGNMENT,
    ASSETMANUFACTURERNAME,
    AUTHORIZATIONGROUP,
    CATALOGPROFILE,
    CONSTRUCTIONMATERIAL,
    CREATEDBYUSER,
    CREATIONDATE,
    FUNCLOCATIONSTRUCTURE,
    FUNCTIONALLOCATION,
    FUNCTIONALLOCATIONCATEGORY,
    FUNCTIONALLOCATIONLABELNAME,
    LASTCHANGEDATETIME,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTOBJECTINTERNALID,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    MANUFACTURERPARTNMBR,
    MANUFACTURERPARTTYPENAME,
    SUPERIORFUNCTIONALLOCATION,
    TECHNICALOBJECTTYPE
);

Learn More