_STATUS

_STATUS is an SAP database table in S/4HANA. It contains 57 fields.

Fields (57)

KeyField CDS FieldsUsed in Views
KEY PPSSupplierRegistrationStatus PPSSupplierRegistrationStatus 1
_CalendarDate _CalendarDate 1
AccountingDocumentStatus AccountingDocumentStatus 1
ActivityStatusName ActivityStatusName 2
BillOfExchangeAcceptStatusName BillOfExchangeAcceptStatusName 1
ChangeLogUTCDateTime ChangeLogUTCDateTime 1
ChmlCmplncRawMatlCmpstnCritlty ChmlCmplncRawMatlCmpstnCritlty 1
CompletionStatus Status 1
ConsolidationTaskStatusText ConsolidationTaskStatusText 2
CreatedByUser CreatedByUser 1
CreatedByUserName CreatedByUserName 1
Criticality Criticality 1
description description 1
DomainText ExpnPlngProcessingStatusText,PricingStatusText 4
EWMHandlingUnitIsNotInStock EWMHandlingUnitIsNotInStock 1
EWMHandlingUnitIsNotLoaded EWMHandlingUnitIsNotLoaded 1
EWMHandlingUnitIsNotPlanned EWMHandlingUnitIsNotPlanned 1
EWMHandlingUnitIsNotUnloaded EWMHandlingUnitIsNotUnloaded 1
EWMHUAttrbtChngIsNotBlocked EWMHUAttrbtChngIsNotBlocked 1
EWMHUContentChangeIsNotBlocked EWMHUContentChangeIsNotBlocked 1
EWMHUIsNotBlockedByCustoms EWMHUIsNotBlockedByCustoms 1
EWMHUIsNotPackedForShipping EWMHUIsNotPackedForShipping 1
EWMHUMvmntChangeIsNotBlocked EWMHUMvmntChangeIsNotBlocked 1
EWMHUPostingChangeIsNotBlocked EWMHUPostingChangeIsNotBlocked 1
EWMTranspUnitIsNotAssigned EWMTranspUnitIsNotAssigned 1
FinSGLErrorItemStatusText FinSGLErrorItemStatusText 3
FldLogsNumberOfItemsPicked FldLogsNumberOfItemsPicked 2
FldLogsNumberOfItemsReceived FldLogsNumberOfItemsReceived 2
FldLogsNumberOfItmsToBeRcvd FldLogsNumberOfItmsToBeRcvd 2
FlxMtPlObjVarStatusDescription FlxMtPlObjVarStatusDescription 1
IntcoValChnDocItmStsCritlty IntcoValChnDocItmStsCritlty 2
IntcoValueChainDocStsCritlty IntcoValueChainDocStsCritlty 1
InternalOrderSystemStatus ACMSettlementGroupStatus,ACMSettlementUnitStatus,InternalOrderSystemStatus 3
MaterialStockRptProcedStatus MaterialStockRptProcedStatus 1
OperationActivitySFIGroup OperationActivitySFIGroup 1
OrderStatusInternalID OrderStatusInternalID 1
PackingInstructionNumber PackingInstructionNumber 1
PackingInstructionText PackingInstructionText 1
ParkedByUser ParkedByUser 1
PaymentProcessingStatus PaymentProcessingStatus 1
SCMDeliveryStatus SCMDeliveryStatus 1
SCMDeliveryStatusDurnInHours SCMDeliveryStatusDurnInHours 1
SCMDeliveryStatusEndDate SCMDeliveryStatusEndDate 1
SCMDeliveryStatusEndDateTime SCMDeliveryStatusEndDateTime 1
SCMDeliveryStatusStrtDate SCMDeliveryStatusStrtDate 1
SCMDeliveryStatusStrtDateTime SCMDeliveryStatusStrtDateTime 1
StatusCode Status,StatusCode 5
StatusDesc StatusDesc 1
StatusDescription Status 1
StatusIsInactive StatusIsInactive 1
statusName statusName 1
StatusProfile StatusProfile 2
SystemStatusName SystemStatusName 1
TaskProcessingStatus TaskProcessingStatus 1
VarCnfUIExtensionStatusText VarCnfUIExtensionStatusText 1
Workflow Workflow 1
WorkItem WorkItem 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 _STATUS (
    PPSSUPPLIERREGISTRATIONSTATUS,
    _CALENDARDATE,
    ACCOUNTINGDOCUMENTSTATUS,
    ACTIVITYSTATUSNAME,
    BILLOFEXCHANGEACCEPTSTATUSNAME,
    CHANGELOGUTCDATETIME,
    CHMLCMPLNCRAWMATLCMPSTNCRITLTY,
    COMPLETIONSTATUS,
    CONSOLIDATIONTASKSTATUSTEXT,
    CREATEDBYUSER,
    CREATEDBYUSERNAME,
    CRITICALITY,
    DESCRIPTION,
    DOMAINTEXT,
    EWMHANDLINGUNITISNOTINSTOCK,
    EWMHANDLINGUNITISNOTLOADED,
    EWMHANDLINGUNITISNOTPLANNED,
    EWMHANDLINGUNITISNOTUNLOADED,
    EWMHUATTRBTCHNGISNOTBLOCKED,
    EWMHUCONTENTCHANGEISNOTBLOCKED,
    EWMHUISNOTBLOCKEDBYCUSTOMS,
    EWMHUISNOTPACKEDFORSHIPPING,
    EWMHUMVMNTCHANGEISNOTBLOCKED,
    EWMHUPOSTINGCHANGEISNOTBLOCKED,
    EWMTRANSPUNITISNOTASSIGNED,
    FINSGLERRORITEMSTATUSTEXT,
    FLDLOGSNUMBEROFITEMSPICKED,
    FLDLOGSNUMBEROFITEMSRECEIVED,
    FLDLOGSNUMBEROFITMSTOBERCVD,
    FLXMTPLOBJVARSTATUSDESCRIPTION,
    INTCOVALCHNDOCITMSTSCRITLTY,
    INTCOVALUECHAINDOCSTSCRITLTY,
    INTERNALORDERSYSTEMSTATUS,
    MATERIALSTOCKRPTPROCEDSTATUS,
    OPERATIONACTIVITYSFIGROUP,
    ORDERSTATUSINTERNALID,
    PACKINGINSTRUCTIONNUMBER,
    PACKINGINSTRUCTIONTEXT,
    PARKEDBYUSER,
    PAYMENTPROCESSINGSTATUS,
    SCMDELIVERYSTATUS,
    SCMDELIVERYSTATUSDURNINHOURS,
    SCMDELIVERYSTATUSENDDATE,
    SCMDELIVERYSTATUSENDDATETIME,
    SCMDELIVERYSTATUSSTRTDATE,
    SCMDELIVERYSTATUSSTRTDATETIME,
    STATUSCODE,
    STATUSDESC,
    STATUSDESCRIPTION,
    STATUSISINACTIVE,
    STATUSNAME,
    STATUSPROFILE,
    SYSTEMSTATUSNAME,
    TASKPROCESSINGSTATUS,
    VARCNFUIEXTENSIONSTATUSTEXT,
    WORKFLOW,
    WORKITEM,
    PRIMARY KEY (PPSSUPPLIERREGISTRATIONSTATUS)
);