A_FunctionalLocation
Functional Location
A_FunctionalLocation is a Composite CDS View that provides data about "Functional Location" in SAP S/4HANA. It reads from 1 data source (R_FunctionalLocationTP) and exposes 84 fields with key field FunctionalLocation. It is exposed through 1 OData service (API_FUNCTIONALLOCATION). Part of development package IEQM.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_FunctionalLocationTP | R_FunctionalLocationTP | projection |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Functional Location | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| VDM.viewType | #COMPOSITE | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MASTER | view |
OData Services (1)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| API_FUNCTIONALLOCATION | API_FUNCTIONALLOCATION | V2 | C2 | C1 |
Fields (84)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | FunctionalLocation | FunctionalLocation | ||
| FunctionalLocationOID | FunctionalLocationOID | |||
| FunctionalLocationLabelName | FunctionalLocationLabelName | |||
| FunctionalLocationName | FunctionalLocationName | |||
| FuncLocationStructure | FuncLocationStructure | |||
| FunctionalLocationCategory | FunctionalLocationCategory | |||
| SuperiorFunctionalLocation | SuperiorFunctionalLocation | |||
| SuperiorFuncnlLocLabelName | SuperiorFuncnlLocLabelName | |||
| FuncnlLocPosInSuperiorTechObj | FuncnlLocPosInSuperiorTechObj | |||
| TechnicalObjectType | TechnicalObjectType | |||
| AuthorizationGroup | AuthorizationGroup | |||
| GrossWeight | GrossWeight | |||
| GrossWeightUnit | GrossWeightUnit | |||
| OperationStartDate | OperationStartDate | |||
| InventoryNumber | InventoryNumber | |||
| AcquisitionValue | AcquisitionValue | |||
| Currency | Currency | |||
| AcquisitionDate | AcquisitionDate | |||
| AssetManufacturerName | AssetManufacturerName | |||
| ManufacturerPartNmbr | ManufacturerPartNmbr | |||
| ManufacturerCountry | ManufacturerCountry | |||
| ManufacturerPartTypeName | ManufacturerPartTypeName | |||
| ConstructionMonth | ConstructionMonth | |||
| ConstructionYear | ConstructionYear | |||
| ManufacturerSerialNumber | ManufacturerSerialNumber | |||
| MaintenancePlant | MaintenancePlant | |||
| AssetLocation | AssetLocation | |||
| AssetRoom | AssetRoom | |||
| PlantSection | PlantSection | |||
| WorkCenter | WorkCenter | |||
| WorkCenterInternalID | WorkCenterInternalID | |||
| WorkCenterPlant | WorkCenterPlant | |||
| ABCIndicator | ABCIndicator | |||
| MaintObjectFreeDefinedAttrib | MaintObjectFreeDefinedAttrib | |||
| AddressID | AddressID | |||
| FormOfAddress | FormOfAddress | |||
| BusinessPartnerName1 | BusinessPartnerName1 | |||
| BusinessPartnerName2 | BusinessPartnerName2 | |||
| CityName | CityName | |||
| HouseNumber | HouseNumber | |||
| HouseNumberSupplementText | HouseNumberSupplementText | |||
| Building | Building | |||
| Floor | Floor | |||
| RoomNumber | RoomNumber | |||
| PostalCode | PostalCode | |||
| StreetName | StreetName | |||
| Region | Region | |||
| Country | Country | |||
| PhoneNumber | PhoneNumber | |||
| FaxNumber | FaxNumber | |||
| CompanyCode | CompanyCode | |||
| BusinessArea | BusinessArea | |||
| MasterFixedAsset | MasterFixedAsset | |||
| FixedAsset | FixedAsset | |||
| CostCenter | CostCenter | |||
| ControllingArea | ControllingArea | |||
| WBSElementExternalID | WBSElementExternalID | |||
| SettlementOrder | SettlementOrder | |||
| ConstructionMaterial | ConstructionMaterial | |||
| MaintenancePlannerGroup | MaintenancePlannerGroup | |||
| MaintenancePlanningPlant | MaintenancePlanningPlant | |||
| MainWorkCenterPlant | MainWorkCenterPlant | |||
| MainWorkCenter | MainWorkCenter | |||
| MainWorkCenterInternalID | MainWorkCenterInternalID | |||
| CatalogProfile | CatalogProfile | |||
| EquipmentInstallationIsAllowed | EquipmentInstallationIsAllowed | |||
| OnePieceOfEquipmentIsAllowed | OnePieceOfEquipmentIsAllowed | |||
| SalesOrganization | SalesOrganization | |||
| DistributionChannel | DistributionChannel | |||
| SalesOffice | SalesOffice | |||
| OrganizationDivision | OrganizationDivision | |||
| SalesGroup | SalesGroup | |||
| FunctionalLocationHasEquipment | FunctionalLocationHasEquipment | |||
| FuncnlLocHasSubOrdinateFuncLoc | FuncnlLocHasSubOrdinateFuncLoc | |||
| LastChangeDateTime | LastChangeDateTime | |||
| FuncnlLocIsMarkedForDeletion | FuncnlLocIsMarkedForDeletion | |||
| FuncnlLocIsDeleted | FuncnlLocIsDeleted | |||
| FunctionalLocationIsActive | FunctionalLocationIsActive | |||
| FunctionalLocationIsCreated | FunctionalLocationIsCreated | |||
| FuncnlLocIsDeactivated | FuncnlLocIsDeactivated | |||
| FunctionalLocationEndOfUseDate | FunctionalLocationEndOfUseDate | |||
| CreatedByUser | CreatedByUser | |||
| CreationDate | CreationDate | |||
| LastChangedByUser | LastChangedByUser |
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Functional Location'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@VDM.viewType: #COMPOSITE
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MASTER}
define root view entity A_FunctionalLocation
provider contract transactional_query // CDS FLOC View - Provider Contract Transactional Query Defined
as projection on R_FunctionalLocationTP as _FunctionalLocationTP
{
key FunctionalLocation,
//MDI_ODM
FunctionalLocationOID,
FunctionalLocationLabelName,
FunctionalLocationName,
FuncLocationStructure,
FunctionalLocationCategory,
SuperiorFunctionalLocation,
SuperiorFuncnlLocLabelName,
FuncnlLocPosInSuperiorTechObj, //New field 2208CE
TechnicalObjectType,
AuthorizationGroup,
@Semantics.quantity.unitOfMeasure: 'GrossWeightUnit'
GrossWeight,
@Semantics.unitOfMeasure: true
GrossWeightUnit,
OperationStartDate,
InventoryNumber,
@Semantics.amount.currencyCode: 'Currency'
AcquisitionValue,
@Semantics.currencyCode: true
Currency,
AcquisitionDate,
AssetManufacturerName,
ManufacturerPartNmbr,
ManufacturerCountry,
ManufacturerPartTypeName,
ConstructionMonth,
ConstructionYear,
ManufacturerSerialNumber,
MaintenancePlant,
AssetLocation,
AssetRoom,
PlantSection,
WorkCenter,
WorkCenterInternalID,
WorkCenterPlant,
ABCIndicator,
MaintObjectFreeDefinedAttrib,
@Consumption: { hidden: true }
AddressID,
FormOfAddress, // new field 2108
BusinessPartnerName1,
BusinessPartnerName2, //new field 2108
CityName,
HouseNumber,
HouseNumberSupplementText, //new field 2108
Building, // new field 2108
Floor, // new field 2108
RoomNumber, //new field 2108
PostalCode,
StreetName,
Region,
Country,
PhoneNumber,
FaxNumber,
CompanyCode,
BusinessArea,
MasterFixedAsset,
FixedAsset,
CostCenter,
ControllingArea,
WBSElementExternalID,
SettlementOrder,
ConstructionMaterial,
MaintenancePlannerGroup,
MaintenancePlanningPlant,
MainWorkCenterPlant,
MainWorkCenter,
MainWorkCenterInternalID,
CatalogProfile,
EquipmentInstallationIsAllowed,
OnePieceOfEquipmentIsAllowed,
SalesOrganization,
DistributionChannel,
SalesOffice,
OrganizationDivision,
SalesGroup,
FunctionalLocationHasEquipment,
FuncnlLocHasSubOrdinateFuncLoc,
LastChangeDateTime,
FuncnlLocIsMarkedForDeletion,
FuncnlLocIsDeleted,
FunctionalLocationIsActive,
FunctionalLocationIsCreated, //Added : 2308
FuncnlLocIsDeactivated,
FunctionalLocationEndOfUseDate, //new field CE 2308
//ADMIN DATA
CreatedByUser, //new admin field 2111
CreationDate, //new admin field 2111
LastChangedByUser, //new admin field 2111
_Partner : redirected to composition child A_FunctionalLocationPartner,
_LongText : redirected to composition child A_FunctionalLocationLongText,
_Classification : redirected to composition child A_FuncnlLocClfnClass,
_Warranty : redirected to composition child A_FuncnlLocWarrantyAssgmt
};
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA