1. Home
  2. Resources
  3. SAP Tables
  4. CVIITEM - DDS Log partial orders

SAP Table CVIITEM

DDS Log partial orders

CVIITEM (DDS Log partial orders) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CVIITEM to other SAP tables.

CVIITEM table fields

Field Data element Checktable Datatype Length Decimals
DDP_ID Distribution order package ID CVDIDDPID NUMC 20 0
DDOC_ID Partial order for document distribution CVIDDOCID NUMC 20 0
LOGSYS Logical system LOGSYS TBDLS CHAR 10 0
OBJTYPE Object type for document distribution CVDIOBJTP CHAR 10 0
OBJKEY Object ID CVDIOBJID CHAR 70 0
ORIGINAL Originals CVDIORIG CHAR 4 0
1 Original 1
2 Original 2
A Original 1 and original 2
APPLICATION Application CVIAPP CHAR 3 0
RECTP Type of recipient ID CVDIRECTP CHAR 2 0
RECID Recipient for document distribution CVDIRECNO CHAR 70 0
COM_TYPE Distribution type CVDICOMTP CHAR 3 0
SEQNO Sequence Number CVDILFDNR NUMC 3 0
OFF_RECTP Recipient type (SAPoffice) CVDIRTYPE CHAR 1 0
NULL Name
P Private distribution list
C Shared distribution list
O SAPoffice user
B SAP user
U Internet address
X X.400 address
R SAP user in another SAP System
A External address
F Fax number
D X.500 Address
L Telex number
H Organizational unit/position
J SAP object
G Organization object/ID
K Pager/SMS
1 Other Recipient Types
REC_NAME Recipient name for document distribution CVDIRNAME CHAR 241 0
NUM_COPIES Number of copies per recipient CVDINUMCOP NUMC 4 0
COPY_TYPE Type of copy CVDICPTP CHAR 3 0
DDM_ID Medium Id for document distribution CVDIDDM CHAR 10 0
REC_ACTIVE Indicator: recipient is inactive CVDIACT CHAR 1 0
X Yes
NULL No
L_ESC_DES Recipient type SO_ESC_DES CHAR 50 0
STATUS Status of partial order (internal) CVDISTAT CHAR 2 0
SY Distribute immediately
AS Distribute later
MA Distribute manually
IW Distribution order being processed
CH Distribution order checked
BD Distribution order bundled
PC Distribution order package generated
WO Wait for confirmation of output
WR Wait for confirmation of receipt
OK Distribution order completed successfully
ER Error
IG Ignored
DDI_ID Initial order ID for document distribution CVIDDIID NUMC 20 0
DDO_ID Distribution order ID CVDIDDOID NUMC 20 0
CR_USER Created by CVDICRUSER CHAR 12 0
CR_UTC Time when created (time stamp) CVICRUTC DEC 15 0
CR_DATE Creation Date CVDICRDATE DATS 8 0
CR_TIME Time of creation CVDICRTIME TIMS 6 0
CH_USER Last Changed By CVDICHUSER CHAR 12 0
CH_UTC Time of change (time stamp) CVICHUTC DEC 15 0
CH_DATE Last Changed On CVDICHDATE DATS 8 0
CH_TIME Time of last change CVDICHTIME TIMS 6 0
CONTROL_USER Person that entered the output confirmation CVICTRLUSER CHAR 12 0
CONTROL_UTC Time when created (time stamp) CVICRUTC DEC 15 0
CONTROL_DATE Output control date CVICONTDATE DATS 8 0
CONTROL_TIME Output control time CVICONTTIME TIMS 6 0
RECEIPT_USER User who received confirmation of receipt CVIRECUSER CHAR 12 0
RECEIPT_UTC Time when created (time stamp) CVICRUTC DEC 15 0
RECEIPT_DATE Date - confirmation of receipt CVIRECDATE DATS 8 0
RECEIPT_TIME Time - confirmation of receipt CVIRECTIME TIMS 6 0
NAME1 Name 1 CVINAME1 CHAR 80 0
NAME2 Name 2 CVINAME2 CHAR 80 0
STREET_POST Street / PO box CVISTREET CHAR 80 0
CITY Location CVICITY CHAR 80 0
REASONTYP Type of initiation of initial order CVDIRETYP CHAR 10 0
MAN_CALL Initial order - created manually
WF_CALL Initial order - created by Workflow
REASONBPR Context for document distribution CVDIBPRID TDIBP CHAR 10 0
DOKAR Document Type DOKAR CHAR 3 0
DOKNR Document number DOKNR CHAR 25 0
DOKVR Document Version DOKVR CHAR 2 0
DOKTL Document Part DOKTL_D CHAR 3 0
SEND_TIME Send time CVISENDTIME TIMS 6 0
SEND_DATE Date when sent CVISENDDATE DATS 8 0
DISP_OFFTP Type of distribution point for documents CVDIDISPTP CHAR 2 0
US User
O Organizational unit
C Job
S Position
A Work center
DISP_OFF Distribution point for document distribution CVDIDISP CHAR 12 0
DISP_NAME Name of the distribution point for document distribution CVIDISPNAME CHAR 241 0
CACOM_TYPE Communication type CVIZAVCOM CHAR 3 0
RETURN_DATE Return date CVI_RETURN_DATE DATS 8 0

CVIITEM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CVIITEM LOGSYS CVIITEM LOGSYS TBDLS Logical system LOGSYS
CVIITEM REASONBPR SY MANDT TDIBP DDS: context MANDT
CVIITEM REASONBPR CVIITEM REASONBPR TDIBP DDS: context REASONBPR