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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ACCGO_ACRUAL_FEES | view | inner | BASIC | |
| P_ACCGO_SI_FEES | view | inner | BASIC |
Fields (78)
| Key | Field | CDS Fields | Used 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
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA