P_DGR_Appl_UpdateDPQS

Update DPQS details for net quantity calculation | view: PDGRAPPLUDPQS | TRAN | Extraction: Not supported | Component: Application and Call Off
Tables used: /ACCGO/T_APPDATA, /ACCGO/T_CAS_CAH, /ACCGO/T_CAS_CAI, WBHI, ACDOCA, /ACCGO/T_STLCTNR, PAYR, /ACCGO/DEND_RUN, /ACCGO/T_SCH_HST, /ACCGO/T_UISEVNT, /ACCGO/T_UISHDR, JEST, /ACCGO/T_QR_AP_M, /ACCGO/T_QR_AP_Q, /ACCGO/T_STLINV, JCDS, /ACCGO/T_STLHEAD, /ACCGO/T_SNPHD1, T001K, MARA, /ACCGO/T_PLNTGRP, /ACCGO/T_DPQS_H, /ACCGO/T_VOL_SHD, /ACCGO/T_STLSTAT, CMM_VLOGP, MARC, /ACCGO/T_NEGSTRL, /ACCGO/T_CAKSTAT, /ACCGO/DEND_CUT
Column Name Description
Column Name Description
Column Name Description
CommodityQuantityInBaseUnit null
Column Name Description
StorageStartDate Storage Start Date
StorageEndDate Commingle: Storage End Date
WarehouseStartDate Warehouse Start Date
WarehouseEndDate Warehouse End Date
PostingDate Posting Date in the Document
ApplItemChangedOnDate null
DailyGrainReportDate null
ApplItemCreatedOnDate null
ApplItemCancelledDate Creation date of the change document
ApplItemAppliedDate Appl Item Created On Date
ApplItemSettlementDate null
DPQSHistoryDate null
Column Name Description
Side Side Show values
WarehouseReceiptType Warehouse Receipt Type Show values
ObligationType Obligation Type Show values
LoadDataObjectType LDC Type Show values
SettlementStatus Settlement Document Category Show values
SettlementType Settlement Type Show values
ApplicationId Snapshot Application Show values
ContractIsConfirmationRelevant Confirmation Relevancy Indicator Show values
Column Name Description Domain name
ApplicationDocument Application Document Number /ACCGO/D_APPLDOC
ApplicationDocumentItem null
SubItem Application Document Item Number WLF_GENERIC_ITEM_NUM
ApplicationItemCategory Application Document Item Category /ACCGO/D_APPLDOC_ITEM_CAT
ItemGuid Application Document Item GUID SYSUUID_X16
RootItem Application Document Root Item WLF_GENERIC_ITEM_NUM
ParentItem null
ApplicationStatusObject Object number J_OBJNR
WarehouseReceiptNo Warehouse Receipt Number /ACCGO/D_WHREC
Plant Plant WERKS
StorageLocation Storage location LGORT
MaterialGroup Material Group MATKL
LoadDataCaptureObjectID Load Data Capture Object ID /ACCGO/D_UIS_ID
LoadDataObjectUUID Load Data Capture Key SYSUUID_X16
Material Material Number MATNR
Vendor Account Number of Supplier LIFNR
CompanyCode Company Code BUKRS
ApplItemChangedOnDateTime null
ApplicationUUID Application GUID SYSUUID_X16
ApplicationVersion Application Version
TradingContractNumber Trading Contract TKONN
TradingContractItem Item Number of Trading Contract TPOSN
DailyGrainReportDisplayUnit null
DailyGrainReportType null
SettlementUnitUUID Settlement Header GUID SYSUUID
ContractNumber Trading Contract TKONN
ContractItem Item Number of Trading Contract TPOSN
ContractCommodityItem Commodity Subitem Number TPOSN
SettlementStatusObject null
ContractQtyCancellationUUID Contract GUID SYSUUID
SettlmtDoc Settlement Unit /ACCGO/D_SETTL_DOC
SettlmtDocYear Settlement Unit Year /ACCGO/D_SETTL_YR
StatusCode Object status J_STATUS
SttlInvoicePaymentDateTime null
ApplicationDocumentType Application Document Type /ACCGO/D_APPL_DOC_TYPE
LoadDataCaptureApplInstruction LDC Application Instruction /ACCGO/D_UIS_APPL_INSTR
ApplItemCreatedOnDateTime null
ApplItemCancelledDateTime Status Time Stamp TZNTSTMPS
ApplItemAppliedDateTime null
ApplItemSettlementDateTime Created On /ACCGO/D_TZNTSTMPS
EndOfDayTimestamp Valid-From Timestamp TZNTSTMPS
PreviousEndOfDayTimestamp Valid-From Timestamp TZNTSTMPS
BegingingBookBalancetTimestamp Valid-From Timestamp TZNTSTMPS
EndOfDayBusinessEntityKey Key of an Business Entity requiring an End-of-day snapshot
ActionDateTime Snapshot Timestamp TZNTSTMPS
ContractStatus Application Status of Trading Contract BTBSTA
ContractType Trading Contract Type TCTYP
PlantGroup Plant Group /ACCGO/D_PLANT_GROUP
PhysicalCommodity Physical Commodity TBA_STOEFFCHEN
QuantityRepositoryUUID Application GUID SYSUUID_X16
QuantityRepositoryVersion Version /ACCGO/D_QREP_ID
SubstitutedPlant Plant WERKS
SubstitutedMaterial Material Number MATNR
IsSubstitutedRecord null
DiscPremQtyScheduleUniqueID null
DiscPremQtyScheduleVersion null
DPQSValidityVersion null