P_RABUSRECNCLNDETWITHCNDNTYPE
Business Reconciliation Detail with Condition Type
P_RABUSRECNCLNDETWITHCNDNTYPE is a CDS View in S/4HANA. Business Reconciliation Detail with Condition Type. It contains 39 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_RABusRecnclnDetWithCndnType | view_entity | from | COMPOSITE | Business Recncln with Condition Type |
| P_RABusRecnclnConditionType | view_entity | from | COMPOSITE | Document Condition Type |
| P_RABusRecnclnDetWithHeaderId | view_entity | from | COMPOSITE | Business Reconciliation Detail with Header id |
| R_RABusRecnclnDetWthCndnTypeTP | view_entity | from | TRANSACTIONAL | Business Recncln with Condition Type |
Fields (39)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingPrinciple | AccountingPrinciple | 1 |
| KEY | CompanyCode | CompanyCode | 1 |
| KEY | ConditionType | ConditionType | 1 |
| KEY | PerformanceObligation | PerformanceObligation | 1 |
| KEY | RevenueAccountingContract | RevenueAccountingContract | 1 |
| _AccountingPrinciple | _AccountingPrinciple | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _Contract | _Contract | 1 | |
| _Mapping | _Mapping | 1 | |
| _RAPerformanceObligation | _RAPerformanceObligation | 1 | |
| _SenderComponentMapping | _SenderComponentMapping | 1 | |
| ActualCostCriticality | ActualCostCriticality | 1 | |
| AdditionalCurrency1 | AdditionalCurrency1 | 1 | |
| AdditionalCurrency2 | AdditionalCurrency2 | 1 | |
| BusRecnclnItemCreatedByUser | BusRecnclnItemCreatedByUser | 1 | |
| BusRecnclnItmCreatedDateTime | BusRecnclnItmCreatedDateTime | 1 | |
| CARevnRecgnQtyUnit | CARevnRecgnQtyUnit | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 1 | |
| ContractualPriceCriticality | ContractualPriceCriticality | 1 | |
| CostCurrency | CostCurrency | 1 | |
| DataValidationHasError | DataValidationHasError | 1 | |
| InvoiceCurrency | InvoiceCurrency | 1 | |
| InvoicedAmountCriticality | InvoicedAmountCriticality | 1 | |
| Material | Material | 1 | |
| MaterialName | MaterialName | 1 | |
| OperationalDocItemQty | OperationalDocItemQty | 1 | |
| OrderQuantityCriticality | OrderQuantityCriticality | 1 | |
| PerfOblgnContractualQuantity | PerfOblgnContractualQuantity | 1 | |
| RABusinessRecnclnViewType | RABusinessRecnclnViewType | 1 | |
| RAContrLiabilityAssetIsCalcd | RAContrLiabilityAssetIsCalcd | 1 | |
| RAGenLdgrCorrectionAccount | RAGenLdgrCorrectionAccount | 1 | |
| RAGenLdgrRecognitionAccount | RAGenLdgrRecognitionAccount | 1 | |
| RAOperationalDocumentItem | RAOperationalDocumentItem | 1 | |
| RevnAcctgOperationalDocument | RevnAcctgOperationalDocument | 1 | |
| RevnAcctgPerfOblgnStatus | RevnAcctgPerfOblgnStatus | 1 | |
| SalesDocumentCurrency | SalesDocumentCurrency | 1 | |
| TotalCostCriticality | TotalCostCriticality | 1 | |
| TransactionCurrency | TransactionCurrency | 1 | |
| ValidationDateTime | ValidationDateTime | 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.
-- Business Reconciliation Detail with Condition Type
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RABUSRECNCLNDETWITHCNDNTYPE (
ACCOUNTINGPRINCIPLE,
COMPANYCODE,
CONDITIONTYPE,
PERFORMANCEOBLIGATION,
REVENUEACCOUNTINGCONTRACT,
_ACCOUNTINGPRINCIPLE,
_COMPANYCODE,
_CONTRACT,
_MAPPING,
_RAPERFORMANCEOBLIGATION,
_SENDERCOMPONENTMAPPING,
ACTUALCOSTCRITICALITY,
ADDITIONALCURRENCY1,
ADDITIONALCURRENCY2,
BUSRECNCLNITEMCREATEDBYUSER,
BUSRECNCLNITMCREATEDDATETIME,
CAREVNRECGNQTYUNIT,
COMPANYCODECURRENCY,
CONTRACTUALPRICECRITICALITY,
COSTCURRENCY,
DATAVALIDATIONHASERROR,
INVOICECURRENCY,
INVOICEDAMOUNTCRITICALITY,
MATERIAL,
MATERIALNAME,
OPERATIONALDOCITEMQTY,
ORDERQUANTITYCRITICALITY,
PERFOBLGNCONTRACTUALQUANTITY,
RABUSINESSRECNCLNVIEWTYPE,
RACONTRLIABILITYASSETISCALCD,
RAGENLDGRCORRECTIONACCOUNT,
RAGENLDGRRECOGNITIONACCOUNT,
RAOPERATIONALDOCUMENTITEM,
REVNACCTGOPERATIONALDOCUMENT,
REVNACCTGPERFOBLGNSTATUS,
SALESDOCUMENTCURRENCY,
TOTALCOSTCRITICALITY,
TRANSACTIONCURRENCY,
VALIDATIONDATETIME,
PRIMARY KEY (ACCOUNTINGPRINCIPLE, COMPANYCODE, CONDITIONTYPE, PERFORMANCEOBLIGATION, REVENUEACCOUNTINGCONTRACT)
);
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