_LOCATIONACCOUNTASSIGNMENT

_LOCATIONACCOUNTASSIGNMENT is an SAP database table in S/4HANA. It contains 45 fields.

Fields (45)

KeyField CDS FieldsUsed in Views
_ABCIndicator _ABCIndicator 7
_Address _Address 1
_Address2 _Address2 1
_BusinessArea _BusinessArea,_LocAcctAssgmtBusinessArea 3
_CompanyCode _CompanyCode 5
_ControllingArea _ControllingArea 5
_CostCenter _CostCenter 4
_FixedAsset _FixedAsset 2
_FunctionalLocation _FunctionalLocation 6
_Location _Location 5
_MaintenancePlant _MaintenancePlant 5
_MasterFixedAsset _MasterFixedAsset 3
_PlantSection _PlantSection 5
_SalesOrganization _SalesOrganization 1
_SettlementOrder _SettlementOrder 6
_StandingOrderNumber _StandingOrderNumber 3
_WBSElementBasicData _WBSElementBasicData 2
_WorkCenter _WorkCenter 1
_WorkCenterType _WorkCenterType 1
ABCIndicator ABCIndicator 17
AddressID AddressID 1
AssetLocation AssetLocation 22
AssetRoom AssetRoom 21
BusinessArea BusinessArea,LocAcctAssgmtBusinessArea 11
CompanyCode CompanyCode,LocAcctAssgmtCompanyCode 14
ControllingArea ControllingArea,LocAcctAssgmtControllingArea 27
CostCenter CostCenter,LocAcctAssgmtCostCenter 28
DistributionChannel DistributionChannel 6
Division Division 2
FixedAsset FixedAsset 5
FunctionalLocation FunctionalLocation,haus,SuperiorFunctionalLocation 26
MaintenanceObjectLocation MaintenanceObjectLocation 2
MaintenancePlant MaintenancePlant,MaintenanceWorkCenterPlant 35
MaintObjectFreeDefinedAttrib MaintObjectFreeDefinedAttrib,SortField,TechnicalObjectSortCode 20
MasterFixedAsset MasterFixedAsset 6
OrganizationDivision Division,OrganizationDivision 6
PlantSection PlantSection 27
SalesGroup SalesGroup 5
SalesOffice SalesOffice 5
SalesOrganization SalesOrganization 6
SettlementOrder SettlementOrder 8
StandingOrderNumber StandingOrderNumber 5
WBSElementInternalID WBSElementInternalID 2
WorkCenterInternalID WorkCenterInternalID 6
WorkCenterTypeCode LocAcctAssgmtWorkCtrTypeCode,WorkCenterTypeCode 4

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 _LOCATIONACCOUNTASSIGNMENT (
    _ABCINDICATOR,
    _ADDRESS,
    _ADDRESS2,
    _BUSINESSAREA,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _FIXEDASSET,
    _FUNCTIONALLOCATION,
    _LOCATION,
    _MAINTENANCEPLANT,
    _MASTERFIXEDASSET,
    _PLANTSECTION,
    _SALESORGANIZATION,
    _SETTLEMENTORDER,
    _STANDINGORDERNUMBER,
    _WBSELEMENTBASICDATA,
    _WORKCENTER,
    _WORKCENTERTYPE,
    ABCINDICATOR,
    ADDRESSID,
    ASSETLOCATION,
    ASSETROOM,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    FIXEDASSET,
    FUNCTIONALLOCATION,
    MAINTENANCEOBJECTLOCATION,
    MAINTENANCEPLANT,
    MAINTOBJECTFREEDEFINEDATTRIB,
    MASTERFIXEDASSET,
    ORGANIZATIONDIVISION,
    PLANTSECTION,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SETTLEMENTORDER,
    STANDINGORDERNUMBER,
    WBSELEMENTINTERNALID,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE
);