I_AUTHZDACCOGPARTSORGSTRUCPOS

CDS View
28 Fields 2 CDS Views

View to get Accparts for Org position FE

I_AUTHZDACCOGPARTSORGSTRUCPOS is a CDS View in S/4HANA. View to get Accparts for Org position FE. It contains 28 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AuthzdActlPosOrgStructure view from COMPOSITE Org Structure Position FE
I_AuthzdPosOrgStructure view_entity from COMPOSITE Org Structure Position FE

Fields (28)

KeyField CDS FieldsUsed in Views
KEY DfsAssgmtNode DfsAssgmtNode 1
KEY DfsObjectPlngStatus DfsObjectPlngStatus 1
KEY DfsObjectValdtyEndDate DfsObjectValdtyEndDate 1
KEY DfsObjectValdtyStartDate DfsObjectValdtyStartDate 1
KEY ForceElementOrgSrceID ForceElementOrgSrceID 2
DfsAssgmtCorrectionValue DfsAssgmtCorrectionValue 1
DfsAssgmtIsUsedForMassMatlPlng DfsAssgmtIsUsedForMassMatlPlng 1
DfsAssgmtMaterialCategory DfsAssgmtMaterialCategory 1
DfsAssgmtMaterialCategoryDesc DfsAssgmtMaterialCategoryDesc 1
DfsAssgmtMaterialIndicatorCode DfsAssgmtMaterialIndicatorCode 1
DfsAssgmtMaterialIndicatorDesc DfsAssgmtMaterialIndicatorDesc 1
DfsAssgmtMaterialWeightingRate DfsAssgmtMaterialWeightingRate 1
DfsAssgmtNmbrOfAssgdMatl DfsAssgmtNmbrOfAssgdMatl 1
DfsAssgmtSourceType DfsAssgmtSourceType 1
DfsAssgmtStatusCode DfsAssgmtStatusCode 2
DfsAssgmtType DfsAssgmtType 1
DfsAssgmtUsageType DfsAssgmtUsageType 2
DfsAssgmtUUID DfsAssgmtUUID 2
DfsAssgmtValdtyEndDate DfsAssgmtValdtyEndDate 2
DfsAssgmtValdtyStrtDate DfsAssgmtValdtyStrtDate 2
DfsPositionID DfsPositionID 1
DfsPositionRelatedObjectType DfsPositionRelatedObjectType 1
DfsPositionSourceID DfsPositionSourceID 1
DfsPositionSourceUUID DfsPositionSourceUUID 1
FlxblMatlPlngObjectID FlxblMatlPlngObjectID 2
FlxblMatlPlngObjectUUID FlxblMatlPlngObjectUUID 1
FlxblMatlPlngObjVariantID FlxblMatlPlngObjVariantID 2
FlxblMatlPlngObjVariantUUID FlxblMatlPlngObjVariantUUID 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.

-- View to get Accparts for Org position FE
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_AUTHZDACCOGPARTSORGSTRUCPOS (
    DFSASSGMTNODE,
    DFSOBJECTPLNGSTATUS,
    DFSOBJECTVALDTYENDDATE,
    DFSOBJECTVALDTYSTARTDATE,
    FORCEELEMENTORGSRCEID,
    DFSASSGMTCORRECTIONVALUE,
    DFSASSGMTISUSEDFORMASSMATLPLNG,
    DFSASSGMTMATERIALCATEGORY,
    DFSASSGMTMATERIALCATEGORYDESC,
    DFSASSGMTMATERIALINDICATORCODE,
    DFSASSGMTMATERIALINDICATORDESC,
    DFSASSGMTMATERIALWEIGHTINGRATE,
    DFSASSGMTNMBROFASSGDMATL,
    DFSASSGMTSOURCETYPE,
    DFSASSGMTSTATUSCODE,
    DFSASSGMTTYPE,
    DFSASSGMTUSAGETYPE,
    DFSASSGMTUUID,
    DFSASSGMTVALDTYENDDATE,
    DFSASSGMTVALDTYSTRTDATE,
    DFSPOSITIONID,
    DFSPOSITIONRELATEDOBJECTTYPE,
    DFSPOSITIONSOURCEID,
    DFSPOSITIONSOURCEUUID,
    FLXBLMATLPLNGOBJECTID,
    FLXBLMATLPLNGOBJECTUUID,
    FLXBLMATLPLNGOBJVARIANTID,
    FLXBLMATLPLNGOBJVARIANTUUID,
    PRIMARY KEY (DFSASSGMTNODE, DFSOBJECTPLNGSTATUS, DFSOBJECTVALDTYENDDATE, DFSOBJECTVALDTYSTARTDATE, FORCEELEMENTORGSRCEID)
);

Learn More