ACTIVEDOCUMENT

ACTIVEDOCUMENT is an SAP database table in S/4HANA. It contains 71 fields.

Fields (71)

KeyField CDS FieldsUsed in Views
KEY DfsAssgmtUUID DfsAssgmtUUID 1
DfsAssgmtChangeDateTime DfsAssgmtChangeDateTime 1
DfsAssgmtComment DfsAssgmtComment 1
DfsAssgmtCorrectionReason DfsAssgmtCorrectionReason 1
DfsAssgmtCorrectionValue DfsAssgmtCorrectionValue 1
DfsAssgmtCreatedByUser DfsAssgmtCreatedByUser 1
DfsAssgmtCreationDateTime DfsAssgmtCreationDateTime 1
DfsAssgmtDamageType DfsAssgmtDamageType 1
DfsAssgmtExternalProductGroup DfsAssgmtExternalProductGroup 1
DfsAssgmtFrcElmntTrngAssmtBy DfsAssgmtFrcElmntTrngAssmtBy 1
DfsAssgmtFrcElmntTrngAssmtDte DfsAssgmtFrcElmntTrngAssmtDte 1
DfsAssgmtInitialSupplyStatus DfsAssgmtInitialSupplyStatus 1
DfsAssgmtIsDefaultAssignment DfsAssgmtIsDefaultAssignment 1
DfsAssgmtIsMandForRdnssCalc DfsAssgmtIsMandForRdnssCalc 1
DfsAssgmtIsOwnProvision DfsAssgmtIsOwnProvision 1
DfsAssgmtIsUsedForMassMatlPlng DfsAssgmtIsUsedForMassMatlPlng 1
DfsAssgmtLastChgdByUser DfsAssgmtLastChgdByUser 1
DfsAssgmtLogicalSystem DfsAssgmtLogicalSystem 1
DfsAssgmtMaterialCategory DfsAssgmtMaterialCategory 1
DfsAssgmtMaterialIndicatorCode DfsAssgmtMaterialIndicatorCode 1
DfsAssgmtMaterialWeightingRate DfsAssgmtMaterialWeightingRate 1
DfsAssgmtMaxNmbrOfAssgdMatl DfsAssgmtMaxNmbrOfAssgdMatl 1
DfsAssgmtMinNmbrOfAssgdMatl DfsAssgmtMinNmbrOfAssgdMatl 1
DfsAssgmtNmbrOfAssgdMatl DfsAssgmtNmbrOfAssgdMatl 1
DfsAssgmtPlanDelimitDate DfsAssgmtPlanDelimitDate 1
DfsAssgmtPlanDelimitTime DfsAssgmtPlanDelimitTime 1
DfsAssgmtPlanOperationCode DfsAssgmtPlanOperationCode 1
DfsAssgmtPlanStatusObject DfsAssgmtPlanStatusObject 1
DfsAssgmtPriority DfsAssgmtPriority 1
DfsAssgmtSourceObjectType DfsAssgmtSourceObjectType 1
DfsAssgmtSourceObjectUUID DfsAssgmtSourceObjectUUID 1
DfsAssgmtSourceType DfsAssgmtSourceType 1
DfsAssgmtStatusCode DfsAssgmtStatusCode 1
DfsAssgmtStatusObject DfsAssgmtStatusObject 1
DfsAssgmtType DfsAssgmtType 1
DfsAssgmtUsageType DfsAssgmtUsageType 1
DfsAssgmtValdtyEndDate DfsAssgmtValdtyEndDate 1
DfsAssgmtValdtyEndTime DfsAssgmtValdtyEndTime 1
DfsAssgmtValdtyStrtDate DfsAssgmtValdtyStrtDate 1
DfsAssgmtValdtyStrtTime DfsAssgmtValdtyStrtTime 1
DfsAssgmtValdtyTimeZone DfsAssgmtValdtyTimeZone 1
DfsCapabilityObjectID DfsCapabilityObjectID 1
DfsCapabilityObjectTargetID DfsCapabilityObjectTargetID 1
DfsCapabilityObjectTargetUUID DfsCapabilityObjectTargetUUID 1
DfsCapabilityObjectUUID DfsCapabilityObjectUUID 1
DfsCapabilityStatementID DfsCapabilityStatementID 1
DfsCapabilityStatementUUID DfsCapabilityStatementUUID 1
DfsCapbltStmntSqncNmbr DfsCapbltStmntSqncNmbr 1
DfsCapbltStmntType DfsCapbltStmntType 1
DfsIsAccreditingMsnEsnlTsk DfsIsAccreditingMsnEsnlTsk 1
DfsJobID DfsJobID 1
DfsPositionSourceID DfsPositionSourceID 1
DfsPositionSourceUUID DfsPositionSourceUUID 1
Equipment Equipment 1
FlxblMatlPlngObjectID FlxblMatlPlngObjectID 1
FlxblMatlPlngObjectUUID FlxblMatlPlngObjectUUID 1
FlxblMatlPlngObjVariantID FlxblMatlPlngObjVariantID 1
FlxblMatlPlngObjVariantUUID FlxblMatlPlngObjVariantUUID 1
ForceElementOrgSrceID ForceElementOrgSrceID 1
ForceElementOrgSrceUUID ForceElementOrgSrceUUID 1
ForceElementOrgTargetID ForceElementOrgTargetID 1
ForceElementOrgTargetUUID ForceElementOrgTargetUUID 1
FrcElmntOrgForceProviderID FrcElmntOrgForceProviderID 1
FrcElmntOrgInitialMatlSuplrID FrcElmntOrgInitialMatlSuplrID 1
FrcElmntOrgInitialPersSuplrID FrcElmntOrgInitialPersSuplrID 1
FrcElmntOrgMaintCapblt FrcElmntOrgMaintCapblt 1
FrcElmntOrgOpExerciseID FrcElmntOrgOpExerciseID 1
FrcElmntOrgRotationKey FrcElmntOrgRotationKey 1
MissionEssentialTaskID MissionEssentialTaskID 1
MissionEssentialTaskUUID MissionEssentialTaskUUID 1
Product Product 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACTIVEDOCUMENT (
    DFSASSGMTUUID,
    DFSASSGMTCHANGEDATETIME,
    DFSASSGMTCOMMENT,
    DFSASSGMTCORRECTIONREASON,
    DFSASSGMTCORRECTIONVALUE,
    DFSASSGMTCREATEDBYUSER,
    DFSASSGMTCREATIONDATETIME,
    DFSASSGMTDAMAGETYPE,
    DFSASSGMTEXTERNALPRODUCTGROUP,
    DFSASSGMTFRCELMNTTRNGASSMTBY,
    DFSASSGMTFRCELMNTTRNGASSMTDTE,
    DFSASSGMTINITIALSUPPLYSTATUS,
    DFSASSGMTISDEFAULTASSIGNMENT,
    DFSASSGMTISMANDFORRDNSSCALC,
    DFSASSGMTISOWNPROVISION,
    DFSASSGMTISUSEDFORMASSMATLPLNG,
    DFSASSGMTLASTCHGDBYUSER,
    DFSASSGMTLOGICALSYSTEM,
    DFSASSGMTMATERIALCATEGORY,
    DFSASSGMTMATERIALINDICATORCODE,
    DFSASSGMTMATERIALWEIGHTINGRATE,
    DFSASSGMTMAXNMBROFASSGDMATL,
    DFSASSGMTMINNMBROFASSGDMATL,
    DFSASSGMTNMBROFASSGDMATL,
    DFSASSGMTPLANDELIMITDATE,
    DFSASSGMTPLANDELIMITTIME,
    DFSASSGMTPLANOPERATIONCODE,
    DFSASSGMTPLANSTATUSOBJECT,
    DFSASSGMTPRIORITY,
    DFSASSGMTSOURCEOBJECTTYPE,
    DFSASSGMTSOURCEOBJECTUUID,
    DFSASSGMTSOURCETYPE,
    DFSASSGMTSTATUSCODE,
    DFSASSGMTSTATUSOBJECT,
    DFSASSGMTTYPE,
    DFSASSGMTUSAGETYPE,
    DFSASSGMTVALDTYENDDATE,
    DFSASSGMTVALDTYENDTIME,
    DFSASSGMTVALDTYSTRTDATE,
    DFSASSGMTVALDTYSTRTTIME,
    DFSASSGMTVALDTYTIMEZONE,
    DFSCAPABILITYOBJECTID,
    DFSCAPABILITYOBJECTTARGETID,
    DFSCAPABILITYOBJECTTARGETUUID,
    DFSCAPABILITYOBJECTUUID,
    DFSCAPABILITYSTATEMENTID,
    DFSCAPABILITYSTATEMENTUUID,
    DFSCAPBLTSTMNTSQNCNMBR,
    DFSCAPBLTSTMNTTYPE,
    DFSISACCREDITINGMSNESNLTSK,
    DFSJOBID,
    DFSPOSITIONSOURCEID,
    DFSPOSITIONSOURCEUUID,
    EQUIPMENT,
    FLXBLMATLPLNGOBJECTID,
    FLXBLMATLPLNGOBJECTUUID,
    FLXBLMATLPLNGOBJVARIANTID,
    FLXBLMATLPLNGOBJVARIANTUUID,
    FORCEELEMENTORGSRCEID,
    FORCEELEMENTORGSRCEUUID,
    FORCEELEMENTORGTARGETID,
    FORCEELEMENTORGTARGETUUID,
    FRCELMNTORGFORCEPROVIDERID,
    FRCELMNTORGINITIALMATLSUPLRID,
    FRCELMNTORGINITIALPERSSUPLRID,
    FRCELMNTORGMAINTCAPBLT,
    FRCELMNTORGOPEXERCISEID,
    FRCELMNTORGROTATIONKEY,
    MISSIONESSENTIALTASKID,
    MISSIONESSENTIALTASKUUID,
    PRODUCT,
    PRIMARY KEY (DFSASSGMTUUID)
);