P_ASSETASSIGNMENT

CDS View
41 Fields 1 CDS Views

Asset Assignment

P_ASSETASSIGNMENT is a CDS View in S/4HANA. Asset Assignment. It contains 41 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AssetAssignmentTP view from TRANSACTIONAL Asset Assignment

Fields (41)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY FixedAsset FixedAsset 1
KEY MasterFixedAsset MasterFixedAsset 1
KEY ValidityEndDate ValidityEndDate,ValidityEndDateForEdit 1
AssetAuthorizationContext AssetAuthorizationContext 1
AssetLocation AssetLocation 1
BudgetPeriod BudgetPeriod 1
BusinessArea BusinessArea 1
BusinessPlace BusinessPlace 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
CostCenterName CostCenterName 1
CostCtrActivityType CostCtrActivityType 1
CostCtrActivityTypeName CostCtrActivityTypeName 1
FinancialManagementArea FinancialManagementArea 1
FunctionalArea FunctionalArea 1
Fund Fund 1
FundsCenter FundsCenter 1
FundsCenterName FundsCenterName 1
GrantID GrantID 1
InternalOrder InternalOrder 1
LogicalSystem LogicalSystem 1
LongText LongText 1
PersonnelNumber PersonnelNumber 1
Plant Plant 1
ProfitCenter ProfitCenter 1
ProfitCenterName ProfitCenterName 1
RealEstateObject RealEstateObject 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentContext ReferenceDocumentContext 1
ReferenceDocumentType ReferenceDocumentType 1
ResponsibleCostCenter ResponsibleCostCenter 1
ResponsibleCostCenterName ResponsibleCostCenterName 1
Room Room 1
Segment Segment 1
TaxJurisdiction TaxJurisdiction 1
ValidityStartDate ValidityStartDate 1
VehicleLicensePlateNumber VehicleLicensePlateNumber 1
WBSElementDescription WBSElementDescription 1
WBSElementExternalID WBSElementExternalID 1
WBSElementInternalID WBSElementInternalID 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.

-- Asset Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ASSETASSIGNMENT (
    COMPANYCODE,
    FIXEDASSET,
    MASTERFIXEDASSET,
    VALIDITYENDDATE,
    ASSETAUTHORIZATIONCONTEXT,
    ASSETLOCATION,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSPLACE,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTCENTERNAME,
    COSTCTRACTIVITYTYPE,
    COSTCTRACTIVITYTYPENAME,
    FINANCIALMANAGEMENTAREA,
    FUNCTIONALAREA,
    FUND,
    FUNDSCENTER,
    FUNDSCENTERNAME,
    GRANTID,
    INTERNALORDER,
    LOGICALSYSTEM,
    LONGTEXT,
    PERSONNELNUMBER,
    PLANT,
    PROFITCENTER,
    PROFITCENTERNAME,
    REALESTATEOBJECT,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTTYPE,
    RESPONSIBLECOSTCENTER,
    RESPONSIBLECOSTCENTERNAME,
    ROOM,
    SEGMENT,
    TAXJURISDICTION,
    VALIDITYSTARTDATE,
    VEHICLELICENSEPLATENUMBER,
    WBSELEMENTDESCRIPTION,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (COMPANYCODE, FIXEDASSET, MASTERFIXEDASSET, VALIDITYENDDATE)
);

Learn More