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