_UNIVERSALASSIGNMENT

33 Fields

_UNIVERSALASSIGNMENT is an SAP database table in S/4HANA. It contains 33 fields.

Fields (33)

KeyField CDS FieldsUsed in Views
KEY DfsAssgmtUUID DfsAssgmtNode,DfsAssgmtUUID 5
KEY FlxblMatlPlngObjectID FlxblMatlPlngObjectID,FlxMtPlObjVarAccogPrtRefObjID 8
KEY Product Product 1
_AssignmentType _AssignmentType 2
_MaterialCategory _MaterialCategory 2
_MaterialIndicator _MaterialIndicator 2
_PositionObject _PositionObject 2
_StatusAttributes _StatusAttributes 2
_UsageType _UsageType 2
_ValdtyEndDate _ValdtyEndDate 2
_ValdtyStrtDate _ValdtyStrtDate 2
DfsAssgmtCorrectionValue DfsAssgmtCorrectionValue 5
DfsAssgmtIsUsedForMassMatlPlng DfsAssgmtIsUsedForMassMatlPlng 6
DfsAssgmtMaterialCategory DfsAssgmtMaterialCategory 5
DfsAssgmtMaterialCategoryDesc DfsAssgmtMaterialCategoryDesc 2
DfsAssgmtMaterialIndicatorCode DfsAssgmtMaterialIndicatorCode 7
DfsAssgmtMaterialIndicatorDesc DfsAssgmtMaterialIndicatorDesc 2
DfsAssgmtMaterialWeightingRate DfsAssgmtMaterialWeightingRate 5
DfsAssgmtSourceObjectType DfsAssgmtSourceObjectType 4
DfsAssgmtSourceType DfsAssgmtSourceType 7
DfsAssgmtStatusCode DfsAssgmtStatusCode 6
DfsAssgmtType DfsAssgmtType 7
DfsAssgmtUsageType DfsAssgmtUsageType 5
DfsAssgmtValdtyEndDate DfsAssgmtValdtyEndDate 5
DfsAssgmtValdtyStrtDate DfsAssgmtValdtyStrtDate 5
DfsCapabilityObjectID DfsCapabilityObjectID 1
DfsPositionSourceID DfsPositionSourceID 5
DfsPositionSourceUUID DfsPositionSourceUUID 5
Equipment Equipment 1
FlxblMatlPlngObjectUUID FlxblMatlPlngObjectUUID 5
FlxblMatlPlngObjVariantID FlxblMatlPlngObjVariantID,FlxMtPlObjVarAccogPrtRefVarID 6
FlxblMatlPlngObjVariantUUID FlxblMatlPlngObjVariantUUID 5
ForceElementOrgSrceID ForceElementOrgRefSrceID,ForceElementOrgSrceID 6

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 _UNIVERSALASSIGNMENT (
    DFSASSGMTUUID,
    FLXBLMATLPLNGOBJECTID,
    PRODUCT,
    _ASSIGNMENTTYPE,
    _MATERIALCATEGORY,
    _MATERIALINDICATOR,
    _POSITIONOBJECT,
    _STATUSATTRIBUTES,
    _USAGETYPE,
    _VALDTYENDDATE,
    _VALDTYSTRTDATE,
    DFSASSGMTCORRECTIONVALUE,
    DFSASSGMTISUSEDFORMASSMATLPLNG,
    DFSASSGMTMATERIALCATEGORY,
    DFSASSGMTMATERIALCATEGORYDESC,
    DFSASSGMTMATERIALINDICATORCODE,
    DFSASSGMTMATERIALINDICATORDESC,
    DFSASSGMTMATERIALWEIGHTINGRATE,
    DFSASSGMTSOURCEOBJECTTYPE,
    DFSASSGMTSOURCETYPE,
    DFSASSGMTSTATUSCODE,
    DFSASSGMTTYPE,
    DFSASSGMTUSAGETYPE,
    DFSASSGMTVALDTYENDDATE,
    DFSASSGMTVALDTYSTRTDATE,
    DFSCAPABILITYOBJECTID,
    DFSPOSITIONSOURCEID,
    DFSPOSITIONSOURCEUUID,
    EQUIPMENT,
    FLXBLMATLPLNGOBJECTUUID,
    FLXBLMATLPLNGOBJVARIANTID,
    FLXBLMATLPLNGOBJVARIANTUUID,
    FORCEELEMENTORGSRCEID,
    PRIMARY KEY (DFSASSGMTUUID, FLXBLMATLPLNGOBJECTID, PRODUCT)
);

Learn More