P_APPLDOC_DATA

P_APPLDOC_DATA is an SAP database table in S/4HANA. It contains 78 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_ACCGO_ACRUAL_FEES view inner BASIC
P_ACCGO_SI_FEES view inner BASIC

Fields (78)

KeyField CDS FieldsUsed in Views
adj_uom adj_uom 1
appl_status_objnr appl_status_objnr 1
appl_uom laq_uom 1
appldoc appldoc 1
appldoc_type appldoc_type 1
applied_qty_raw laq_qty 1
assgd_quan_orig assgd_quan_orig 1
assgmt_guid assgmt_guid 1
changed_by changed_by 1
changed_on changed_on 1
company_code company_code 1
contract contract 1
contract_curr contract_curr 1
contract_doc_type contract_doc_type 1
contract_itm contract_itm 1
contract_qty contract_qty 1
contract_side side 1
contract_status contract_status 1
contract_subitem contract_subitem 1
contract_type contract_type 1
contract_uom contract_uom 1
created_by created_by 1
created_on created_on 1
delivery_item delivery_item 1
delivery_side delivery_side 1
delivery_type delivery_type 1
dist_chnl dist_chnl 1
division division 1
doc_curr doc_curr 1
doc_typ doc_typ 1
document_qty document_qty 1
document_uom document_uom 1
full_ship_qty full_ship_qty 1
item item 1
item_qty gross_qty 1
item_uom gross_uom 1
material material 1
nomit nomit 1
nomnr nomnr 1
nomtk nomtk 1
ob_delivery ob_delivery 1
order_itm order_itm 1
order_no order_no 1
order_side order_side 1
order_type order_type 1
plant plant 1
prcfx_asg_qty prcfx_asg_qty 1
prepaymentagreement prepaymentagreement 1
prepaymentagrmtrefdocitem prepaymentagrmtrefdocitem 1
prepaymentagrmtrefdocument prepaymentagrmtrefdocument 1
price_fixation_number price_fixation_number 1
pricing_aspect_counter pricing_aspect_counter 1
pricing_aspect_id pricing_aspect_id 1
profit_center profit_center 1
prxfx_asg_uom prxfx_asg_uom 1
purch_grp purch_grp 1
purch_org purch_org 1
qrep_guid qrep_guid 1
qrep_version qrep_version 1
ref_app_doc ref_app_doc 1
ref_app_doc_typ ref_app_doc_typ 1
sales_org sales_org 1
settl_cat settl_cat 1
settl_doc settl_doc 1
settl_item settl_item 1
settl_scenario settl_scenario 1
settl_side settl_side 1
settl_type settl_type 1
settl_yr settl_yr 1
sold_to_party sold_to_party 1
stl_status_objnr stl_status_objnr 1
sub_item sub_item 1
supplier supplier 1
tot_quantity_adj tot_quantity_adj 1
uis_evnt_guid uis_evnt_guid 1
uis_evnt_id uis_evnt_id 1
unit_quantity unit_quantity 1
unit_uom unit_uom 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_APPLDOC_DATA (
    ADJ_UOM,
    APPL_STATUS_OBJNR,
    APPL_UOM,
    APPLDOC,
    APPLDOC_TYPE,
    APPLIED_QTY_RAW,
    ASSGD_QUAN_ORIG,
    ASSGMT_GUID,
    CHANGED_BY,
    CHANGED_ON,
    COMPANY_CODE,
    CONTRACT,
    CONTRACT_CURR,
    CONTRACT_DOC_TYPE,
    CONTRACT_ITM,
    CONTRACT_QTY,
    CONTRACT_SIDE,
    CONTRACT_STATUS,
    CONTRACT_SUBITEM,
    CONTRACT_TYPE,
    CONTRACT_UOM,
    CREATED_BY,
    CREATED_ON,
    DELIVERY_ITEM,
    DELIVERY_SIDE,
    DELIVERY_TYPE,
    DIST_CHNL,
    DIVISION,
    DOC_CURR,
    DOC_TYP,
    DOCUMENT_QTY,
    DOCUMENT_UOM,
    FULL_SHIP_QTY,
    ITEM,
    ITEM_QTY,
    ITEM_UOM,
    MATERIAL,
    NOMIT,
    NOMNR,
    NOMTK,
    OB_DELIVERY,
    ORDER_ITM,
    ORDER_NO,
    ORDER_SIDE,
    ORDER_TYPE,
    PLANT,
    PRCFX_ASG_QTY,
    PREPAYMENTAGREEMENT,
    PREPAYMENTAGRMTREFDOCITEM,
    PREPAYMENTAGRMTREFDOCUMENT,
    PRICE_FIXATION_NUMBER,
    PRICING_ASPECT_COUNTER,
    PRICING_ASPECT_ID,
    PROFIT_CENTER,
    PRXFX_ASG_UOM,
    PURCH_GRP,
    PURCH_ORG,
    QREP_GUID,
    QREP_VERSION,
    REF_APP_DOC,
    REF_APP_DOC_TYP,
    SALES_ORG,
    SETTL_CAT,
    SETTL_DOC,
    SETTL_ITEM,
    SETTL_SCENARIO,
    SETTL_SIDE,
    SETTL_TYPE,
    SETTL_YR,
    SOLD_TO_PARTY,
    STL_STATUS_OBJNR,
    SUB_ITEM,
    SUPPLIER,
    TOT_QUANTITY_ADJ,
    UIS_EVNT_GUID,
    UIS_EVNT_ID,
    UNIT_QUANTITY,
    UNIT_UOM
);