ACCGO_ND_DUMMY table in SAP ERP or S/4HANA stores Dummy Table for Netdry data. There are total 46 fields in ACCGO_ND_DUMMY table. The Dummy Table for Netdry table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ACCGO_ND_DUMMY table. It is in Net-dry CDS Views (ACCGO_NETDRY_CDS) ABAP package and is part of the Application and Call Off (LO-AGR-APP) module.
SAP ACCGO_ND_DUMMY Table Fields
Following is the list of fields that are available in SAP ACCGO_ND_DUMMY table. The primary key fields of Dummy Table for Netdry table in SAP are MANDT (Client), PRICING_KEY (A key required to access versioned pricing data), KPOSN (Condition item number), KSCHL (Condition type), KSCHL_SUBKEY (The key of a sub-condition type), DELTA_GUID (GUID assigned to the VlogP stock delta record).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT(3) | |
| PRICING_KEY | A key required to access versioned pricing data | CMM_VLOGP_PRICING_KEY | CHAR(40) | |
| KPOSN | Condition item number | KPOSN | NUMC(6) | |
| KSCHL | Condition type | KSCHL | CHAR(4) | |
| KSCHL_SUBKEY | The key of a sub-condition type | CMM_VLOGP_SUBKEY | NUMC(6) | |
| DELTA_GUID | GUID assigned to the VlogP stock delta record | CMM_VLOGP_DELTA_KEY | RAW(16) | |
| REF_DOC | Reference Document | /ACCGO/E_REF_VLOGP_DOC | CHAR(20) | |
| REF_DOC_TYPE | Reference Document (BOR) Object Type | /ACCGO/E_VLOGP_REFDOC_TYPE | * | CHAR(10) |
| REF_DOC_YEAR | Material Document Year | MJAHR | NUMC(4) | |
| VALID_FROM_TIMESTAMP | Valid-From Timestamp | CMM_MTM_VALID_FROM_TST | DEC(15) | |
| VALID_TO_TIMESTAMP | Valid-To Timestamp | CMM_MTM_VALID_TO_TST | DEC(15) | |
| MGLME | Quantity in Base Unit | CMM_MTM_MENGE_D_BASE | QUAN(17) | |
| LAGME | Base Unit of Measure | LAGME | * | UNIT(3) |
| COMMODITY_QUAN | Commodity Quantity | CMM_MTM_QUAN_COMM | QUAN(17) | |
| COMMODITY_UOM | Unit of Measure for Commodity | CMM_MTM_QUAN_COMMUOM | * | UNIT(3) |
| COMMODITY_RF_UOM | Reference unit of measure for proportion unit/product unit | REFME_WS | * | UNIT(3) |
| COMMODITY_QUAN_MASS | Open Commodity Quantity In MASS | CMM_MTM_QUAN_COMM_MASS | QUAN(17) | |
| COMMODITY_MASS_UOM | Unit of Measure for Commodity | CMM_MTM_QUAN_COMMUOM | * | UNIT(3) |
| COMMODITY_QUAN_VOLUME | Open Commodity Quantity In Volume | CMM_MTM_QUAN_COMM_VOLUME | QUAN(17) | |
| COMMODITY_VOLUME_UOM | Unit of Measure for Commodity | CMM_MTM_QUAN_COMMUOM | * | UNIT(3) |
| SOURCE_DOC | Document | CMM_VLOGP_DOCUMENT | CHAR(20) | |
| SOURCE_DOC_TYPE | Document (BOR) Object Type | CMM_VLOGP_DOC_TYPE | * | CHAR(10) |
| SOURCE_DOC_YEAR | Material Document Year | MJAHR | NUMC(4) | |
| RECORD_TYPE | Type of Data Record | CMM_VLOGP_REC_TYPE | CHAR(2) | |
| SIGNAGE_QTY | Sign of Quantity | CMM_VLOGP_SIGNAGE_QTY | INT2(5) | |
| CGROUP | MtM Condition Group | CMM_MTM_CGROUP | * | CHAR(1) |
| CGROUP_CAT | Categorization of Condition Group | CMM_MTM_CGROUP_CAT | CHAR(1) | |
| BWART | Movement type (inventory management) | BWART | * | CHAR(3) |
| CHARG | Batch Number | CHARG_D | * | CHAR(10) |
| UIS_ID | Load Data Capture Object ID | /ACCGO/E_UIS_ID | CHAR(10) | |
| EVENT_TYPE | Net Dry Event | /ACCGO/E_NETDRY_EVENT | CHAR(2) | |
| QREP_GUID | Application GUID | /ACCGO/E_QREP_GUID | RAW(16) | |
| QREP_VERSION | Version | /ACCGO/E_QREP_ID | NUMC(6) | |
| NET_QUAN | Calculated Net Quantity in Base UoM | /ACCGO/E_NET_QUANTITY | QUAN(17) | |
| NET_QUAN_COMM | Net Quantity in Commodity UoM | /ACCGO/E_NET_QUAN_COMM | QUAN(17) | |
| NET_QUAN_MASS | Open Commodity Quantity In MASS | CMM_MTM_QUAN_COMM_MASS | QUAN(17) | |
| NET_QUAN_VOLUME | Open Commodity Quantity In Volume | CMM_MTM_QUAN_COMM_VOLUME | QUAN(17) | |
| GROSS_QUAN_IN_SLOC | Gross Quantity in Storage Location | /ACCGO/E_GROSS_QUAN_IN_SLOC | QUAN(17) | |
| DPQS_ID | Schedule ID | /ACCGO/E_SCHEDULE_ID | NUMC(10) | |
| VERSION | Schedule Version | /ACCGO/E_DPQS_VERSION | NUMC(3) | |
| SCHEDULE_GUID | Schedule GUID | /ACCGO/E_SCHDL_GUID | RAW(16) | |
| EVAL_VOL | Evaluate Volume | /ACCGO/E_EVAL_VOL | CHAR(1) | |
| LOGICALLY_DEL_STAT | Logically Deleted Status | /ACCGO/E_DEL_STAT | CHAR(1) | |
| ERROR_CODE | Error Code | /ACCGO/E_ERROR_CODE | CHAR(2) | |
| DPQS_TYPE | DPQS Type | /ACCGO/DPQS_TYPE | CHAR(2) | |
| BATCH_MERGE | Batch Merge Indicator | /ACCGO/E_BATCH_MERGE | CHAR(1) |
