CCREG

Transparent Table Application Table
45 Fields 1 CDS Views

Simplified Consignment Register Diary Table

CCREG is an SAP database table in S/4HANA. Simplified Consignment Register Diary Table. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BillingGnrtdCustCsgnmtReg view from BASIC Consignment Register from Billing

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY id CUSTCSGNMTREGUUID Cust. Csgmt Register UUID
proc_type PROC_TYPE Process Type
sign SIGN +/- Sign
cocode BUKRS Company Code
salesorg VKORG Sales Org.
dlvnr VBELN_VL Delivery
dlvitmnr POSNR_VL Item
deptcntry OTAXCNTY Tax Departure Ctry/Reg.
destcntry ITAXCNTY Tax Destination Ctry/Reg.
gmdat WADAT_IST Actual GI Date
specialstockcustomer NSDM_KUNNR Customer SID
soldtoparty KUNAG Sold-to Party
soldtopartyadrnr ADRNR_AG Sold-To Address
shiptoparty KUNWE Ship-to Party
shiptopartyadrnr ADRNR_WE Ship-to address
custvatid STCEG VAT Reg. No.
dlvdate GRDATE Goods Receipt Date
matnr MATNR Material
docqty MENGE_D Quantity
signeddocqty SIGNEDDOCQTY Signed Documented Qty
matunit MEINS Base Unit
netvalue NETWR Net Value
salesorder VBELN_VA Sales Document
salesorderitem POSNR_VA Item
transcrcy WAERK Doc. Currency
dlvplant DLVPLANT Delivering Plant
bildocnr VBELN_VF Billing Doc.
bildocitemnr POSNR_VF Item
canceledbildocnr SFAKN Canceld Bill.Dc
materialdocument MBLNR Material Doc.
materialdocumentyear MJAHR Mat. Doc. Year
materialdocumentitem MBLPO Mat. Doc.Item
acctgdocnr BELNR_D Document Number
fiscalyear GJAHR Fiscal Year
batch CHARG_D Batch
isbatchmanaged XCHAR Batches
iscancellation ISCANCELLATION Cancellation of Another Entry
iscanceled XCANCELED Cancellation Ind
external_ref EXTERNAL_REF External Reference
isdeleted UFDELETED Deletion Flag
remark REGISTERUPLDREMARK Remark
createdby CREATEDBY Created By
createddate ERSDA Created On
createdtime FOT_CRTTIM Created At

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.

-- Simplified Consignment Register Diary Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CCREG (
    MANDT,                 -- Client [MANDT]
    ID,                    -- Cust. Csgmt Register UUID [CUSTCSGNMTREGUUID]
    PROC_TYPE,             -- Process Type [PROC_TYPE]
    SIGN,                  -- +/- Sign [SIGN]
    COCODE,                -- Company Code [BUKRS]
    SALESORG,              -- Sales Org. [VKORG]
    DLVNR,                 -- Delivery [VBELN_VL]
    DLVITMNR,              -- Item [POSNR_VL]
    DEPTCNTRY,             -- Tax Departure Ctry/Reg. [OTAXCNTY]
    DESTCNTRY,             -- Tax Destination Ctry/Reg. [ITAXCNTY]
    GMDAT,                 -- Actual GI Date [WADAT_IST]
    SPECIALSTOCKCUSTOMER,  -- Customer SID [NSDM_KUNNR]
    SOLDTOPARTY,           -- Sold-to Party [KUNAG]
    SOLDTOPARTYADRNR,      -- Sold-To Address [ADRNR_AG]
    SHIPTOPARTY,           -- Ship-to Party [KUNWE]
    SHIPTOPARTYADRNR,      -- Ship-to address [ADRNR_WE]
    CUSTVATID,             -- VAT Reg. No. [STCEG]
    DLVDATE,               -- Goods Receipt Date [GRDATE]
    MATNR,                 -- Material [MATNR]
    DOCQTY,                -- Quantity [MENGE_D]
    SIGNEDDOCQTY,          -- Signed Documented Qty [SIGNEDDOCQTY]
    MATUNIT,               -- Base Unit [MEINS]
    NETVALUE,              -- Net Value [NETWR]
    SALESORDER,            -- Sales Document [VBELN_VA]
    SALESORDERITEM,        -- Item [POSNR_VA]
    TRANSCRCY,             -- Doc. Currency [WAERK]
    DLVPLANT,              -- Delivering Plant [DLVPLANT]
    BILDOCNR,              -- Billing Doc. [VBELN_VF]
    BILDOCITEMNR,          -- Item [POSNR_VF]
    CANCELEDBILDOCNR,      -- Canceld Bill.Dc [SFAKN]
    MATERIALDOCUMENT,      -- Material Doc. [MBLNR]
    MATERIALDOCUMENTYEAR,  -- Mat. Doc. Year [MJAHR]
    MATERIALDOCUMENTITEM,  -- Mat. Doc.Item [MBLPO]
    ACCTGDOCNR,            -- Document Number [BELNR_D]
    FISCALYEAR,            -- Fiscal Year [GJAHR]
    BATCH,                 -- Batch [CHARG_D]
    ISBATCHMANAGED,        -- Batches [XCHAR]
    ISCANCELLATION,        -- Cancellation of Another Entry [ISCANCELLATION]
    ISCANCELED,            -- Cancellation Ind [XCANCELED]
    EXTERNAL_REF,          -- External Reference [EXTERNAL_REF]
    ISDELETED,             -- Deletion Flag [UFDELETED]
    REMARK,                -- Remark [REGISTERUPLDREMARK]
    CREATEDBY,             -- Created By [CREATEDBY]
    CREATEDDATE,           -- Created On [ERSDA]
    CREATEDTIME,           -- Created At [FOT_CRTTIM]
    PRIMARY KEY (MANDT, ID)
);

Learn More