Fields (57)
| Key | Field | CDS Fields | Used 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)
);
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