Fields (41)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DfsAssgmtExternalProductGroup | DfsAssgmtExternalProductGroup | 5 |
| KEY | DfsAssgmtIsDefaultAssignment | DfsAssgmtIsDefaultAssignment | 7 |
| KEY | DfsAssgmtUUID | DfsAssgmtUUID | 5 |
| KEY | DfsAssgmtValdtyEndDate | DfsAssgmtValdtyEndDate | 8 |
| KEY | DfsAssgmtValdtyStrtDate | DfsAssgmtValdtyStrtDate | 8 |
| KEY | DraftUUID | DraftUUID | 6 |
| DfsAssgmtActiveDraft | DfsAssgmtActiveDraft | 6 | |
| DfsAssgmtChangeDateTime | DfsAssgmtChangeDateTime | 6 | |
| DfsAssgmtComment | DfsAssgmtComment | 1 | |
| DfsAssgmtCorrectionReason | DfsAssgmtCorrectionReason | 1 | |
| DfsAssgmtCorrectionValue | DfsAssgmtCorrectionValue | 1 | |
| DfsAssgmtCreatedByUser | DfsAssgmtCreatedByUser | 6 | |
| DfsAssgmtCreationDateTime | DfsAssgmtCreationDateTime | 6 | |
| DfsAssgmtDamageType | DfsAssgmtDamageType | 2 | |
| DfsAssgmtInitialSupplyStatus | DfsAssgmtInitialSupplyStatus | 2 | |
| DfsAssgmtIsMandForRdnssCalc | DfsAssgmtIsMandForRdnssCalc | 1 | |
| DfsAssgmtIsOwnProvision | DfsAssgmtIsOwnProvision | 2 | |
| DfsAssgmtIsUsedForMassMatlPlng | DfsAssgmtIsUsedForMassMatlPlng | 1 | |
| DfsAssgmtLastChgdByUser | DfsAssgmtLastChgdByUser | 6 | |
| DfsAssgmtMaterialCategory | DfsAssgmtMaterialCategory | 1 | |
| DfsAssgmtMaterialIndicatorCode | DfsAssgmtMaterialIndicatorCode | 1 | |
| DfsAssgmtMaterialWeightingRate | DfsAssgmtMaterialWeightingRate | 1 | |
| DfsAssgmtMaxNmbrOfAssgdMatl | DfsAssgmtMaxNmbrOfAssgdMatl | 1 | |
| DfsAssgmtMinNmbrOfAssgdMatl | DfsAssgmtMinNmbrOfAssgdMatl | 1 | |
| DfsAssgmtNmbrOfAssgdMatl | DfsAssgmtNmbrOfAssgdMatl | 1 | |
| DfsAssgmtSourceObjectUUID | DfsAssgmtSourceObjectUUID | 2 | |
| DfsAssgmtSourceType | DfsAssgmtSourceType | 6 | |
| DfsAssgmtStatusCode | DfsAssgmtStatusCode | 6 | |
| DfsAssgmtStatusObject | DfsAssgmtStatusObject | 6 | |
| DfsAssgmtType | DfsAssgmtType | 6 | |
| DfsAssgmtUsageType | DfsAssgmtUsageType | 1 | |
| DfsAssgmtValdtyEndTime | DfsAssgmtValdtyEndTime | 6 | |
| DfsAssgmtValdtyStrtTime | DfsAssgmtValdtyStrtTime | 6 | |
| DfsAssgmtValdtyTimeZone | DfsAssgmtValdtyTimeZone | 6 | |
| FlxblMatlPlngObjectUUID | FlxblMatlPlngObjectUUID | 1 | |
| FlxblMatlPlngObjVariantUUID | FlxblMatlPlngObjVariantUUID | 1 | |
| ForceElementOrgSrceUUID | ForceElementOrgSrceUUID | 5 | |
| ForceElementOrgTargetUUID | ForceElementOrgTargetUUID | 5 | |
| HasActiveEntity | HasActiveEntity | 8 | |
| HasDraftEntity | HasDraftEntity | 6 | |
| 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 FETOSUPFE (
DFSASSGMTEXTERNALPRODUCTGROUP,
DFSASSGMTISDEFAULTASSIGNMENT,
DFSASSGMTUUID,
DFSASSGMTVALDTYENDDATE,
DFSASSGMTVALDTYSTRTDATE,
DRAFTUUID,
DFSASSGMTACTIVEDRAFT,
DFSASSGMTCHANGEDATETIME,
DFSASSGMTCOMMENT,
DFSASSGMTCORRECTIONREASON,
DFSASSGMTCORRECTIONVALUE,
DFSASSGMTCREATEDBYUSER,
DFSASSGMTCREATIONDATETIME,
DFSASSGMTDAMAGETYPE,
DFSASSGMTINITIALSUPPLYSTATUS,
DFSASSGMTISMANDFORRDNSSCALC,
DFSASSGMTISOWNPROVISION,
DFSASSGMTISUSEDFORMASSMATLPLNG,
DFSASSGMTLASTCHGDBYUSER,
DFSASSGMTMATERIALCATEGORY,
DFSASSGMTMATERIALINDICATORCODE,
DFSASSGMTMATERIALWEIGHTINGRATE,
DFSASSGMTMAXNMBROFASSGDMATL,
DFSASSGMTMINNMBROFASSGDMATL,
DFSASSGMTNMBROFASSGDMATL,
DFSASSGMTSOURCEOBJECTUUID,
DFSASSGMTSOURCETYPE,
DFSASSGMTSTATUSCODE,
DFSASSGMTSTATUSOBJECT,
DFSASSGMTTYPE,
DFSASSGMTUSAGETYPE,
DFSASSGMTVALDTYENDTIME,
DFSASSGMTVALDTYSTRTTIME,
DFSASSGMTVALDTYTIMEZONE,
FLXBLMATLPLNGOBJECTUUID,
FLXBLMATLPLNGOBJVARIANTUUID,
FORCEELEMENTORGSRCEUUID,
FORCEELEMENTORGTARGETUUID,
HASACTIVEENTITY,
HASDRAFTENTITY,
PRODUCT,
PRIMARY KEY (DFSASSGMTEXTERNALPRODUCTGROUP, DFSASSGMTISDEFAULTASSIGNMENT, DFSASSGMTUUID, DFSASSGMTVALDTYENDDATE, DFSASSGMTVALDTYSTRTDATE, DRAFTUUID)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA