Fields (97)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | EWMStorageBin | EWMStorageBin | 1 |
| KEY | EWMWarehouse | EWMWarehouse | 1 |
| _FireContainmentSection | _FireContainmentSection | 1 | |
| _StorageBehaviorText | _StorageBehaviorText | 1 | |
| _StorageBinAccessType | _StorageBinAccessType | 1 | |
| _StorageBinIsEmptyText | _StorageBinIsEmptyText | 1 | |
| _StorageBinIsFullText | _StorageBinIsFullText | 1 | |
| _StorageBinIsUtilizedText | _StorageBinIsUtilizedText | 1 | |
| _StorageBinType | _StorageBinType | 1 | |
| _StorageSection | _StorageSection | 1 | |
| _StorageType | _StorageType | 1 | |
| _StorageTypeRoleText | _StorageTypeRoleText | 1 | |
| _StorBinAvailableText | _StorBinAvailableText | 1 | |
| _StorBinBlockedText | _StorBinBlockedText | 1 | |
| _StorBinMaxVolMntndText | _StorBinMaxVolMntndText | 1 | |
| _StorBinMaxWeightMntndText | _StorBinMaxWeightMntndText | 1 | |
| _StorBinPInvBlockText | _StorBinPInvBlockText | 1 | |
| _StorBinPutawayBlockText | _StorBinPutawayBlockText | 1 | |
| _StorBinRemovalBlockText | _StorBinRemovalBlockText | 1 | |
| _StorBinTotCapaMntndText | _StorBinTotCapaMntndText | 1 | |
| _VolumeUnitOfMeasureText | _VolumeUnitOfMeasureText | 1 | |
| _Warehouse | _Warehouse | 1 | |
| _WeightUnitOfMeasureText | _WeightUnitOfMeasureText | 1 | |
| ChmlCmplncInfoType | ChmlCmplncInfoType | 1 | |
| ChmlCmplncInfoUUID | ChmlCmplncInfoUUID | 1 | |
| ClassifiedAsDangerousGood | ClassifiedAsDangerousGood | 1 | |
| CmplRqApplicationComponent | CmplRqApplicationComponent | 1 | |
| CmplRqPattern | CmplRqPattern | 1 | |
| CmplRqPatternName | CmplRqPatternName | 1 | |
| CmplRqRsltCalculatedStatus | CmplRqRsltCalculatedStatus | 1 | |
| CmplRqRsltDngrsGdsModeOfTrUUID | CmplRqRsltDngrsGdsModeOfTrUUID | 1 | |
| CmplRqRsltHasReldVersLtstRevsn | CmplRqRsltHasReldVersLtstRevsn | 1 | |
| CmplRqRsltProcessingStatus | CmplRqRsltProcessingStatus | 1 | |
| CmplRqRsltReferencedObjectType | CmplRqRsltReferencedObjectType | 1 | |
| CmplRqRsltReferencedObjectUUID | CmplRqRsltReferencedObjectUUID | 1 | |
| CmplRqUUID | CmplRqUUID | 1 | |
| CmplRqVers | CmplRqVers | 1 | |
| CmplRqVersIsLatest | CmplRqVersIsLatest | 1 | |
| CmplRqVersUUID | CmplRqVersUUID | 1 | |
| DangerousGoodsClass | DangerousGoodsClass | 1 | |
| DangerousGoodsIdnNumberCnctntd | DangerousGoodsIdnNumberCnctntd | 1 | |
| DangerousGoodsPackingGroup | DangerousGoodsPackingGroup | 1 | |
| DisplayVolumeUnit | DisplayVolumeUnit | 1 | |
| DisplayWeightUnit | DisplayWeightUnit | 1 | |
| DngrsGdsLogsPackgInstrnUUID | DngrsGdsLogsPackgInstrnUUID | 1 | |
| DngrsGoodIsPartiallyPackaged | DngrsGoodIsPartiallyPackaged | 1 | |
| DngrsGoodsModeOfTransport | DngrsGoodsModeOfTransport | 1 | |
| EffectiveDate | EffectiveDate | 1 | |
| EnclosureVariant | EnclosureVariant | 1 | |
| EWMFireContainmentSection | EWMFireContainmentSection | 1 | |
| EWMStorageBehavior | EWMStorageBehavior | 1 | |
| EWMStorageBinAccessType | EWMStorageBinAccessType | 1 | |
| EWMStorageBinIsEmpty | EWMStorageBinIsEmpty | 1 | |
| EWMStorageBinIsFull | EWMStorageBinIsFull | 1 | |
| EWMStorageBinIsUtilized | EWMStorageBinIsUtilized | 1 | |
| EWMStorageBinMaxDepthValue | EWMStorageBinMaxDepthValue | 1 | |
| EWMStorageBinMaximumVolume | EWMStorageBinMaximumVolume | 1 | |
| EWMStorageBinMaximumWeight | EWMStorageBinMaximumWeight | 1 | |
| EWMStorageBinMaxVolumeIsMntnd | EWMStorageBinMaxVolumeIsMntnd | 1 | |
| EWMStorageBinMaxWeightIsMntnd | EWMStorageBinMaxWeightIsMntnd | 1 | |
| EWMStorageBinOccupiedVolume | EWMStorageBinOccupiedVolume | 1 | |
| EWMStorageBinRemainDepthValue | EWMStorageBinRemainDepthValue | 1 | |
| EWMStorageBinType | EWMStorageBinType | 1 | |
| EWMStorageBinUnusedVolume | EWMStorageBinUnusedVolume | 1 | |
| EWMStorageBinUnusedWeight | EWMStorageBinUnusedWeight | 1 | |
| EWMStorageBinUsedCapacityValue | EWMStorageBinUsedCapacityValue | 1 | |
| EWMStorageBinUsedDepthValue | EWMStorageBinUsedDepthValue | 1 | |
| EWMStorageBinUsedWeight | EWMStorageBinUsedWeight | 1 | |
| EWMStorageSection | EWMStorageSection | 1 | |
| EWMStorageType | EWMStorageType | 1 | |
| EWMStorageTypeRole | EWMStorageTypeRole | 1 | |
| EWMStorBinAvailCapacityValue | EWMStorBinAvailCapacityValue | 1 | |
| EWMStorBinFreeDefinedAisleText | EWMStorBinFreeDefinedAisleText | 1 | |
| EWMStorBinFreeDefinedLevelText | EWMStorBinFreeDefinedLevelText | 1 | |
| EWMStorBinFreeDefinedStackText | EWMStorBinFreeDefinedStackText | 1 | |
| EWMStorBinHndlgUnitAvailCapVal | EWMStorBinHndlgUnitAvailCapVal | 1 | |
| EWMStorBinIsAvailable | EWMStorBinIsAvailable | 1 | |
| EWMStorBinIsBlocked | EWMStorBinIsBlocked | 1 | |
| EWMStorBinIsBlockedDueToPInv | EWMStorBinIsBlockedDueToPInv | 1 | |
| EWMStorBinIsBlockedForPutaway | EWMStorBinIsBlockedForPutaway | 1 | |
| EWMStorBinIsBlockedForRemoval | EWMStorBinIsBlockedForRemoval | 1 | |
| EWMStorBinMaxNmbrOfHndlgUnits | EWMStorBinMaxNmbrOfHndlgUnits | 1 | |
| EWMStorBinMaxVolumeInDspUnit | EWMStorBinMaxVolumeInDspUnit | 1 | |
| EWMStorBinMaxWeightInDspUnit | EWMStorBinMaxWeightInDspUnit | 1 | |
| EWMStorBinNrOfHndlgUnitsWthMax | EWMStorBinNrOfHndlgUnitsWthMax | 1 | |
| EWMStorBinNumberOfHndlgUnits | EWMStorBinNumberOfHndlgUnits | 1 | |
| EWMStorBinTotalCapacityIsMntnd | EWMStorBinTotalCapacityIsMntnd | 1 | |
| EWMStorBinTotalCapacityValue | EWMStorBinTotalCapacityValue | 1 | |
| PackingInstructionNumber | PackingInstructionNumber | 1 | |
| PackingInstructionSystemUUID | PackingInstructionSystemUUID | 1 | |
| ProdCmplncDngrsGdsIdnNmbr | ProdCmplncDngrsGdsIdnNmbr | 1 | |
| ProdCmplncDngrsGdsIdnNmbrType | ProdCmplncDngrsGdsIdnNmbrType | 1 | |
| Product | Product | 1 | |
| TransportPermission | TransportPermission | 1 | |
| TransportPermissionCriticality | TransportPermissionCriticality | 1 | |
| VolumeUnit | VolumeUnit | 1 | |
| WeightUnit | WeightUnit | 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 _CUBE (
EWMSTORAGEBIN,
EWMWAREHOUSE,
_FIRECONTAINMENTSECTION,
_STORAGEBEHAVIORTEXT,
_STORAGEBINACCESSTYPE,
_STORAGEBINISEMPTYTEXT,
_STORAGEBINISFULLTEXT,
_STORAGEBINISUTILIZEDTEXT,
_STORAGEBINTYPE,
_STORAGESECTION,
_STORAGETYPE,
_STORAGETYPEROLETEXT,
_STORBINAVAILABLETEXT,
_STORBINBLOCKEDTEXT,
_STORBINMAXVOLMNTNDTEXT,
_STORBINMAXWEIGHTMNTNDTEXT,
_STORBINPINVBLOCKTEXT,
_STORBINPUTAWAYBLOCKTEXT,
_STORBINREMOVALBLOCKTEXT,
_STORBINTOTCAPAMNTNDTEXT,
_VOLUMEUNITOFMEASURETEXT,
_WAREHOUSE,
_WEIGHTUNITOFMEASURETEXT,
CHMLCMPLNCINFOTYPE,
CHMLCMPLNCINFOUUID,
CLASSIFIEDASDANGEROUSGOOD,
CMPLRQAPPLICATIONCOMPONENT,
CMPLRQPATTERN,
CMPLRQPATTERNNAME,
CMPLRQRSLTCALCULATEDSTATUS,
CMPLRQRSLTDNGRSGDSMODEOFTRUUID,
CMPLRQRSLTHASRELDVERSLTSTREVSN,
CMPLRQRSLTPROCESSINGSTATUS,
CMPLRQRSLTREFERENCEDOBJECTTYPE,
CMPLRQRSLTREFERENCEDOBJECTUUID,
CMPLRQUUID,
CMPLRQVERS,
CMPLRQVERSISLATEST,
CMPLRQVERSUUID,
DANGEROUSGOODSCLASS,
DANGEROUSGOODSIDNNUMBERCNCTNTD,
DANGEROUSGOODSPACKINGGROUP,
DISPLAYVOLUMEUNIT,
DISPLAYWEIGHTUNIT,
DNGRSGDSLOGSPACKGINSTRNUUID,
DNGRSGOODISPARTIALLYPACKAGED,
DNGRSGOODSMODEOFTRANSPORT,
EFFECTIVEDATE,
ENCLOSUREVARIANT,
EWMFIRECONTAINMENTSECTION,
EWMSTORAGEBEHAVIOR,
EWMSTORAGEBINACCESSTYPE,
EWMSTORAGEBINISEMPTY,
EWMSTORAGEBINISFULL,
EWMSTORAGEBINISUTILIZED,
EWMSTORAGEBINMAXDEPTHVALUE,
EWMSTORAGEBINMAXIMUMVOLUME,
EWMSTORAGEBINMAXIMUMWEIGHT,
EWMSTORAGEBINMAXVOLUMEISMNTND,
EWMSTORAGEBINMAXWEIGHTISMNTND,
EWMSTORAGEBINOCCUPIEDVOLUME,
EWMSTORAGEBINREMAINDEPTHVALUE,
EWMSTORAGEBINTYPE,
EWMSTORAGEBINUNUSEDVOLUME,
EWMSTORAGEBINUNUSEDWEIGHT,
EWMSTORAGEBINUSEDCAPACITYVALUE,
EWMSTORAGEBINUSEDDEPTHVALUE,
EWMSTORAGEBINUSEDWEIGHT,
EWMSTORAGESECTION,
EWMSTORAGETYPE,
EWMSTORAGETYPEROLE,
EWMSTORBINAVAILCAPACITYVALUE,
EWMSTORBINFREEDEFINEDAISLETEXT,
EWMSTORBINFREEDEFINEDLEVELTEXT,
EWMSTORBINFREEDEFINEDSTACKTEXT,
EWMSTORBINHNDLGUNITAVAILCAPVAL,
EWMSTORBINISAVAILABLE,
EWMSTORBINISBLOCKED,
EWMSTORBINISBLOCKEDDUETOPINV,
EWMSTORBINISBLOCKEDFORPUTAWAY,
EWMSTORBINISBLOCKEDFORREMOVAL,
EWMSTORBINMAXNMBROFHNDLGUNITS,
EWMSTORBINMAXVOLUMEINDSPUNIT,
EWMSTORBINMAXWEIGHTINDSPUNIT,
EWMSTORBINNROFHNDLGUNITSWTHMAX,
EWMSTORBINNUMBEROFHNDLGUNITS,
EWMSTORBINTOTALCAPACITYISMNTND,
EWMSTORBINTOTALCAPACITYVALUE,
PACKINGINSTRUCTIONNUMBER,
PACKINGINSTRUCTIONSYSTEMUUID,
PRODCMPLNCDNGRSGDSIDNNMBR,
PRODCMPLNCDNGRSGDSIDNNMBRTYPE,
PRODUCT,
TRANSPORTPERMISSION,
TRANSPORTPERMISSIONCRITICALITY,
VOLUMEUNIT,
WEIGHTUNIT,
PRIMARY KEY (EWMSTORAGEBIN, EWMWAREHOUSE)
);
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