I_USERDEFAULTSETTINGITEMWD

CDS View
61 Fields 2 CDS Views

User Defaults BO Item view

I_USERDEFAULTSETTINGITEMWD is a CDS View in S/4HANA. User Defaults BO Item view. It contains 61 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_UserDefaultSelectionParam view from CONSUMPTION User Default Selection Paramts for Excel
C_UserDefaultSettingItem view from CONSUMPTION Consumption view for item

Fields (61)

KeyField CDS FieldsUsed in Views
KEY BusinessObjectType BusinessObjectType 1
KEY Employee Employee 1
KEY PersonalizationID PersonalizationID 1
_AccAssgnmtCategory _AccAssgnmtCategory 1
_CompanyCode _CompanyCode 1
_Currency _Currency 1
_MaterialGroup _MaterialGroup 1
_Plant _Plant 1
_PurchasingGroup _PurchasingGroup 1
_StorageLocation _StorageLocation 1
_SupplyingPlant _SupplyingPlant 1
_User _User 1
AccountAssignmentCategory AccountAssignmentCategory 1
Asset Asset 1
AssetSubNumber AssetSubNumber 1
AuthorizationGroup AuthorizationGroup 1
BusinessObjectTypeForEdit BusinessObjectTypeForEdit 1
ChangedBy ChangedBy 1
CommSyst CommSyst 1
CompanyCode CompanyCode 1
CompanyCodeName CompanyCodeName 1
CostCenter CostCenter 1
Currency Currency 1
DeliveryDate DeliveryDate 1
EmployeeForEdit EmployeeForEdit 1
ExtPurchaseRequisitionType ExtPurchaseRequisitionType 1
FullName FullName 1
GLAccount GLAccount 1
GoodsRecipientName GoodsRecipientName 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
IsExtPurgScenario IsExtPurgScenario 1
LastChangeDateTime LastChangeDateTime 1
LogicalSystem LogicalSystem 1
MaterialGroup MaterialGroup 1
OrderID OrderID 1
Person Person 1
PersonWorkAgrmtAuthznGrpg PersonWorkAgrmtAuthznGrpg 1
Plant Plant 1
PlantName PlantName 1
ProcmtHubSSPExpertAuthorIsActv ProcmtHubSSPExpertAuthorIsActv 1
ProjectNetwork ProjectNetwork 1
ProjectNetworkDescription ProjectNetworkDescription 1
ProjectNetworkInternalID ProjectNetworkInternalID 1
PurchaseOrderPriceType PurchaseOrderPriceType 1
PurchasingDocumentType PurchasingDocumentType 1
PurchasingGroup PurchasingGroup 1
PurchasingGroupName PurchasingGroupName 1
PurchasingOrganization PurchasingOrganization 1
PurReqnHeaderCurrencySource PurReqnHeaderCurrencySource 1
RequisitionerName RequisitionerName 1
ShopOnBehalfType ShopOnBehalfType 1
SourceDetermination SourceDetermination 1
SourceSystem SourceSystem 1
StorageLocation StorageLocation 1
StorageLocationName StorageLocationName 1
SupplyingPlant SupplyingPlant 1
SupplyingPlantName SupplyingPlantName 1
UnloadingPointName UnloadingPointName 1
UserID UserID 1
WBSElement WBSElement 1
WBSElementInternalID WBSElementInternalID 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.

-- User Defaults BO Item view
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_USERDEFAULTSETTINGITEMWD (
    BUSINESSOBJECTTYPE,
    EMPLOYEE,
    PERSONALIZATIONID,
    _ACCASSGNMTCATEGORY,
    _COMPANYCODE,
    _CURRENCY,
    _MATERIALGROUP,
    _PLANT,
    _PURCHASINGGROUP,
    _STORAGELOCATION,
    _SUPPLYINGPLANT,
    _USER,
    ACCOUNTASSIGNMENTCATEGORY,
    ASSET,
    ASSETSUBNUMBER,
    AUTHORIZATIONGROUP,
    BUSINESSOBJECTTYPEFOREDIT,
    CHANGEDBY,
    COMMSYST,
    COMPANYCODE,
    COMPANYCODENAME,
    COSTCENTER,
    CURRENCY,
    DELIVERYDATE,
    EMPLOYEEFOREDIT,
    EXTPURCHASEREQUISITIONTYPE,
    FULLNAME,
    GLACCOUNT,
    GOODSRECIPIENTNAME,
    ISBUSINESSPURPOSECOMPLETED,
    ISEXTPURGSCENARIO,
    LASTCHANGEDATETIME,
    LOGICALSYSTEM,
    MATERIALGROUP,
    ORDERID,
    PERSON,
    PERSONWORKAGRMTAUTHZNGRPG,
    PLANT,
    PLANTNAME,
    PROCMTHUBSSPEXPERTAUTHORISACTV,
    PROJECTNETWORK,
    PROJECTNETWORKDESCRIPTION,
    PROJECTNETWORKINTERNALID,
    PURCHASEORDERPRICETYPE,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGGROUPNAME,
    PURCHASINGORGANIZATION,
    PURREQNHEADERCURRENCYSOURCE,
    REQUISITIONERNAME,
    SHOPONBEHALFTYPE,
    SOURCEDETERMINATION,
    SOURCESYSTEM,
    STORAGELOCATION,
    STORAGELOCATIONNAME,
    SUPPLYINGPLANT,
    SUPPLYINGPLANTNAME,
    UNLOADINGPOINTNAME,
    USERID,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (BUSINESSOBJECTTYPE, EMPLOYEE, PERSONALIZATIONID)
);

Learn More