_POSITION

41 Fields

_POSITION is an SAP database table in S/4HANA. It contains 41 fields.

Fields (41)

KeyField CDS FieldsUsed in Views
KEY DfsAssgmtUUID DfsAssgmtNode,DfsAssgmtUUID 2
KEY DfsObjectPlngStatus DfsObjectPlngStatus 2
KEY DfsObjectValdtyEndDate DfsObjectValdtyEndDate 2
KEY DfsObjectValdtyStartDate DfsObjectValdtyStartDate 2
KEY DfsPositionID DfsPositionRelatedObjectID 2
KEY DfsPositionValdtyEndDate DfsPositionValdtyEndDate 2
KEY DfsPositionValdtyStartDate DfsPositionValdtyStartDate 2
KEY EmployeePersonnelNumber EmployeePersonnelNumber 2
KEY ForceElementOrgSrceID ForceElementOrgSrceID 2
_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 2
DfsAssgmtIsUsedForMassMatlPlng DfsAssgmtIsUsedForMassMatlPlng 2
DfsAssgmtMaterialCategory DfsAssgmtMaterialCategory 2
DfsAssgmtMaterialCategoryDesc DfsAssgmtMaterialCategoryDesc 2
DfsAssgmtMaterialIndicatorCode DfsAssgmtMaterialIndicatorCode 2
DfsAssgmtMaterialIndicatorDesc DfsAssgmtMaterialIndicatorDesc 2
DfsAssgmtMaterialWeightingRate DfsAssgmtMaterialWeightingRate 2
DfsAssgmtMaxNmbrOfAssgdMatl DfsAssgmtMaxNmbrOfAssgdMatl 2
DfsAssgmtMinNmbrOfAssgdMatl DfsAssgmtMinNmbrOfAssgdMatl 2
DfsAssgmtSourceType DfsAssgmtSourceType 2
DfsAssgmtStatusCode DfsAssgmtStatusCode 2
DfsAssgmtType DfsAssgmtType 2
DfsAssgmtUsageType DfsAssgmtUsageType 2
DfsAssgmtValdtyEndDate DfsAssgmtValdtyEndDate 2
DfsAssgmtValdtyStrtDate DfsAssgmtValdtyStrtDate 2
DfsObjectRelatedObjectType DfsPositionRelatedObjectType 2
DfsObjectSubType DfsObjectSubType 2
DfsObjectType DfsObjectType 2
DfsPositionSourceID DfsPositionSourceID 2
DfsPositionSourceUUID DfsPositionSourceUUID 2
EmployeeName EmployeeName 2
FlxblMatlPlngObjectID FlxblMatlPlngObjectID 2
FlxblMatlPlngObjVariantID FlxblMatlPlngObjVariantID 2
FlxblMatlPlngObjVariantUUID FlxblMatlPlngObjVariantUUID 2

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 _POSITION (
    DFSASSGMTUUID,
    DFSOBJECTPLNGSTATUS,
    DFSOBJECTVALDTYENDDATE,
    DFSOBJECTVALDTYSTARTDATE,
    DFSPOSITIONID,
    DFSPOSITIONVALDTYENDDATE,
    DFSPOSITIONVALDTYSTARTDATE,
    EMPLOYEEPERSONNELNUMBER,
    FORCEELEMENTORGSRCEID,
    _ASSIGNMENTTYPE,
    _MATERIALCATEGORY,
    _MATERIALINDICATOR,
    _POSITIONOBJECT,
    _STATUSATTRIBUTES,
    _USAGETYPE,
    _VALDTYENDDATE,
    _VALDTYSTRTDATE,
    DFSASSGMTCORRECTIONVALUE,
    DFSASSGMTISUSEDFORMASSMATLPLNG,
    DFSASSGMTMATERIALCATEGORY,
    DFSASSGMTMATERIALCATEGORYDESC,
    DFSASSGMTMATERIALINDICATORCODE,
    DFSASSGMTMATERIALINDICATORDESC,
    DFSASSGMTMATERIALWEIGHTINGRATE,
    DFSASSGMTMAXNMBROFASSGDMATL,
    DFSASSGMTMINNMBROFASSGDMATL,
    DFSASSGMTSOURCETYPE,
    DFSASSGMTSTATUSCODE,
    DFSASSGMTTYPE,
    DFSASSGMTUSAGETYPE,
    DFSASSGMTVALDTYENDDATE,
    DFSASSGMTVALDTYSTRTDATE,
    DFSOBJECTRELATEDOBJECTTYPE,
    DFSOBJECTSUBTYPE,
    DFSOBJECTTYPE,
    DFSPOSITIONSOURCEID,
    DFSPOSITIONSOURCEUUID,
    EMPLOYEENAME,
    FLXBLMATLPLNGOBJECTID,
    FLXBLMATLPLNGOBJVARIANTID,
    FLXBLMATLPLNGOBJVARIANTUUID,
    PRIMARY KEY (DFSASSGMTUUID, DFSOBJECTPLNGSTATUS, DFSOBJECTVALDTYENDDATE, DFSOBJECTVALDTYSTARTDATE, DFSPOSITIONID, DFSPOSITIONVALDTYENDDATE, DFSPOSITIONVALDTYSTARTDATE, EMPLOYEEPERSONNELNUMBER, FORCEELEMENTORGSRCEID)
);

Learn More